Elevance Health
This listing was posted on Broadbean.
Engineer III (Lead Data and ETL Developer)
Location:
Indianapolis, IN
Description:
Engineer III (Lead Data and ETL Developer)Location: This position will work a hybrid model (remote and in office 1 - 2 days per week). Ideal candidates will live within 50 miles of one of our Pulse Point locations in Indianapolis, IN and Atlanta, GA.The Engineer III (Lead Data and ETL Developer) is responsible for the delivery of end-to-end system development and maintenance on complex technology systems within assigned client group, business unit or corporate department.How you will make an impact: * Participate in ETL design of new or changing Mappings and Workflows with the team and prepare technical design. * Create ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter and prepare corresponding documentation. * Design and build integrations supporting standard data warehousing objects (dimensions, aggregations, star schema, etc.). * Perform source system analysis as needed. * Work with DBAs and Data Architects to plan and implement appropriate data partitioning strategy. * Develop stored procedures, database triggers and SQL queries and tune SQL code for optimization. * Document and review design specifications, unit test plans and implementation release plans. * Perform hands-on ETL job design, development, and unit testing. * Ensure compliance to best practices, including driving and participating in design and code review sessions and processes. * Maintain active relationships with customers to understand business requirements and focus on optimal solutions. * Guide product teams offering a strategic view on the application of technology. * Spearhead stability, performance, and scalability improvements across critical business systems. * Implement processes to eliminate roadblocks in projects, services, and processes. * Work on deployment patterns and coordinate with other teams to oversee the change request process. * Define application scope and objectives for applications and services, supervising the preparation of technical and functional specifications. * Conduct technical design reviews and code reviews for programming adjustments. * Ensure the unit testing process matches the business and functional requirements. * Develop and perform system testing and fix defects identified during testing and re-execute unit tests to validate results. * Aid in integrating activities with other IT departments for successful implementation and support of project efforts. * Provide on call support, monitor the system, and identify system deficiencies.Minimum Requirements:Requires an BA/BS degree in Information Technology, Computer Science or related field of study and a minimum of 3 years' experience on one platform, multi-database, multi-language or multi-business application; or any combination of education and experience, which would provide an equivalent background.Preferred Skills, Capabilities and Experiences: * Experience mentoring others, leading small projects, and providing troubleshooting support strongly preferred. * Experience with ETL data integration projects using Informatica PowerCenter/Informatica Power Exchange strongly preferred. * Hands-on experience with Unix/Linux and Perl scripting strongly preferred. * Experience with SQL and PL/SQL strongly preferred. * Work experience in Agile environment with application teams strongly preferred. * Ability to lead and guide junior developers and be an SME strongly preferred. * Experience in coding and testing critical code deliverables, listing out critical use cases for testing and reviewing code deliverables of developers strongly preferred. * Experience acquiring and integrating data from relational, mainframe, and flat-file sources preferred. * Experience working with test leads to define test scenarios for Integration, Performance and Regression Testing preferred. * Strong analytical, troubleshooting, knowledge sharing, collaboration and mentoring skills preferred.If this job is assigned to any Government Business Division entity, the applicant and incumbent fall under a 'sensitive position' work designation and may be subject to additional requirements beyond those associates outside Government Business Divisions. Requirements include but are not limited to more stringent and frequent background checks and/or government clearances, segregation of duties principles, role specific training, monitoring of daily job functions, and sensitive data handling instructions. Associates in these jobs must follow the specific policies, procedures, guidelines, etc. as stated by the Government Business Division in which they are employed.Please be advised that Elevance Health only accepts resumes for compensation from agencies that have a signed agreement with Elevance Health. Any unsolicited resumes, including those submitted to hiring managers, are deemed to be the property of Elevance Health.Who We AreElevance Health is a health company dedicated to improving lives and communities - and making healthcare simpler. We are a Fortune 25 company with a longstanding history in the healthcare industry, looking for leaders at all levels of the organization who are passionate about making an impact on our members and the communities we serve.How We WorkAt Elevance Health, we are creating a culture that is designed to advance our strategy but will also lead to personal and professional growth for our associates. Our values and behaviors are the root of our culture. They are how we achieve our strategy, power our business outcomes and drive our shared success - for our consumers, our associates, our communities and our business.We offer a range of market-competitive total rewards that include merit increases, paid holidays, Paid Time Off, and incentive bonus programs (unless covered by a collective bargaining agreement), medical, dental, vision, short and long term disability benefits, 401(k) +match, stock purchase plan, life insurance, wellness programs and financial education resources, to name a few.Elevance Health operates in a Hybrid Workforce Strategy. Unless specified as primarily virtual by the hiring manager, associates are required to work at an Elevance Health location at least once per week, and potentially several times per week. Specific requirements and expectations for time onsite will be discussed as part of the hiring process. Candidates must reside within 50 miles or 1-hour commute each way of a relevant Elevance Health location.The health of our associates and communities is a top priority for Elevance Health. We require all new candidates in certain patient/member-facing roles to become vaccinated against COVID-19. If you are not vaccinated, your offer will be rescinded unless you provide an acceptable explanation. Elevance Health will also follow all relevant federal, state and local laws.Elevance Health is an Equal Employment Opportunity employer and all qualified applicants will receive consideration for employment without regard to age, citizenship status, color, creed, disability, ethnicity, genetic information, gender (including gender identity and gender expression), marital status, national origin, race, religion, sex, sexual orientation, veteran status or any other status or condition protected by applicable federal, state, or local laws. Applicants who require accommodation to participate in the job application process may contact elevancehealthjobssupport@elevancehealth.comfor assistance.
Company:
Elevance Health
Posted:
November 13 on Broadbean
Visit Our Partner Website
This listing was posted on another website. Click here to open: Go to Broadbean
Important Safety Tips
- Always meet the employer in person.
- Avoid sharing sensitive personal and financial information.
- Avoid employment offers that require a deposit or investment.
To learn more, visit the Safety Center or click here to report this listing.
More About this Listing: Engineer III (Lead Data and ETL Developer)
Engineer III (Lead Data and ETL Developer) is a Technology Developer Job at Elevance Health located in Indianapolis IN. Find other listings like Engineer III (Lead Data and ETL Developer) by searching Oodle for Technology Developer Jobs.
Engineer III (Lead Data and ETL Developer) is a Technology Developer Job at Elevance Health located in Indianapolis IN. Find other listings like Engineer III (Lead Data and ETL Developer) by searching Oodle for Technology Developer Jobs.