Aetna ETL Application Developer in Southfield, Michigan
Req ID: 50409BR
*Position location will be Aetna's office in New Albany, OH or Southfield, MI
Visa transfer or sponsorship will not be offered for this position
We are hiring an ETL Application Developer for our EDI team. This position will develop EDI solutions and maintain, implement, and troubleshoot client/vendor inbound/outbound files in a heterogeneous environment. The preferred candidate has experience managing work in this type of environment, working on multiple projects ,new implementations/new services, researching issues, and contributing to improved efficiencies.
EDI/ETL Application Developer possessing solid design and database administration skills. EDI Team focuses on the design using WTX and ETL tools (SSIS) , implementation, and maintenance of physical data models and databases. Key activities include developing SSIS packages, access method analysis, application consulting, performance tuning, device allocation, data organization, security, and statistical methods, including the development and monitoring of standards and procedures affecting models, database management, design and maintenance. Proficient in the utilization of DBA toolsets and more than one DBMS. Exhibits very strong technical or leadership skills.
2+ years of relevant experience with concentration in Database Analysis, Design, and Development 2+ years of experience in T-SQL development Experience with SSIS packages, SSRS and SSAS Demonstrate the ability to adapt to an SSIS/SQL server environment including data extraction, cleansing/data integration, and loading from different data sources Ability to manage all phases of Extract/Transform/Load (ETL) development including reviewing technical documentation, development work, conducting design reviews, coordinating packaging & release deployments, and testing solutions in a complex environment. Extensive Stored Procedure development Experience with any EDI transition tool (preferably WTX and Healthcare EDI transactions ) experience is desiredSolid skills in database performance fine tuning and optimizing poorly performing queries, stored procedures Model and generate database structures Support day to day production inquiries and questions from other technology groups. Demonstrate an understanding of what is considered protected health information such as HIPPA and PHI Address data quality issues; work with business partners to build business understanding of data issues. Handle individual workload and deliver upon project milestones on time and on budget. Skilled in developing dimensional databases and data cubes Proven experience with SQL Server Analysis Services. Proven experience with SQL Server Reporting Services. Ability to design unit and system test plans, and execute testing. Extensive database administration experience Proven teamwork skills Excellent communicator both verbally and written with coordination and facilitation skills. Ability to multi-task and complete in a timely manner multiple assignments. Handle backups and restores On call responsibilities Rights administration Production bug fix issues
Requires in-depth knowledge of Microsoft toolsets. Ideal candidate will be required to lead the technical design of complex, highly re-usable processes including the creation and maintenance of technical application and component design specifications. Ability to code to the technical specifications and often times, guide other technical resources through development activities within an onshore/offshore staffing model. Responsible for interacting with multiple teams while working through technical and design issues in order to support the applications. Ability to work independently as well as in small groups, performing technical activities including analysis, design, development, and testing and production installation of all components applications. Willingness to be in an On Call rotation once every 5 weeks.
The highest level of education desired for candidates in this position is a Bachelor's degree or equivalent experience.
LICENSES AND CERTIFICATIONS
Information Technology/Microsoft Certified Professional (MCP) is desired
Functional - Information Management/Database Structures/1-3 Years
Functional - Information Management/Database Design (Physical)/1-3 Years
Functional - Information Technology/Application maintenance & support/1-3 Years
Functional - Information Technology/Security/1-3 Years
Technical - Development Tools/Microsoft Visual Studio/1-3 Years/End User
Technical - Development Languages/SQL/1-3 Years/End User
ADDITIONAL JOB INFORMATION
Aetna is about more than just doing a job. This is our opportunity to re-shape healthcare for America and across the globe. We are developing solutions to improve the quality and affordability of healthcare. What we do will benefit generations to come.
We care about each other, our customers and our communities. We are inspired to make a difference, and we are committed to integrity and excellence.
Together we will empower people to live healthier lives.
Aetna is an equal opportunity & affirmative action employer. All qualified applicants will receive consideration for employment regardless of personal characteristics or status. We take affirmative action to recruit, select and develop women, people of color, veterans and individuals with disabilities.
We are a company built on excellence. We have a culture that values growth, achievement and diversity and a workplace where your voice can be heard.
Benefit eligibility may vary by position. Click here to review the benefits associated with this position.
Aetna takes our candidate's data privacy seriously. At no time will any Aetna recruiter or employee request any financial or personal information (Social Security Number, Credit card information for direct deposit, etc.) from you via e-mail. Any requests for information will be discussed prior and will be conducted through a secure website provided by the recruiter. Should you be asked for such information, please notify us immediately.
Job Function: Information Technology