Senior ETL Developer

Posted Monday, November 17, 2025 at 5:00 AM

Versant Health is one of the nation’s leading administrators of managed vision care, serving millions of our clients’ members nationwide. We are driven by our mission to help members enjoy the wonders of sight through healthy eyes and vision.

As a Versant Health associate, you can enjoy a comprehensive Total Rewards package, which includes health and dental insurance, tuition reimbursement, 401(k) with company match, pet insurance, no-cost-to-you vision insurance for you and your qualified dependents. We are also invested in your success. There are many opportunities for advancement and development throughout all stages of your career with us.

See how you can make a difference with the support of strong leadership and a team environment.

See Everything, Be Anything™.

Senior Informatica ETL Developer is primarily responsible for supporting ETL development using Informatica Power Center and IICS and support activities. Job assignments will include analyzing, designing, development, and delivery of data using Informatica ETL tool from operational systems and files into a staging area, operational data stores, data warehouse, data marts and files and developing ETL mapping, mapping documents and SQL queries.

The Senior Informatica ETL Developer will also assist in the design, development and implementation of the enterprise integration architecture and will provide ETL expertise to other areas of the organization.

• ETL developers are responsible for designing and creating the data warehouse and all related extraction, transformation and load of data functions in the company
• After development work completes, developers also must test their designs to ensure the system runs smoothly
• Developers must be experts at taking a big-picture view of a company's data situation
• Design, develop and maintain database objects such as the tables, views and stored procedures needed to support reporting and/or analytics solutions
• Analyze data to understand gaps, inconsistencies and other quality issues, and devise data quality improvement solutions
• Analyze and remedy database and query performance issues
• Developers need to be able to read, analyze and digest what a business wants to accomplish with its data, and design the best possible ETL process around those goals
• Work with business users and gathering data and reporting requirements.
• Work with business users and QA team with user-acceptance testing and issue resolution.
• Must be proficient with SQL Queries
• Needs to have greater understanding and experience of Data warehousing, data transformation, and business intelligence.
• Must have experience working with dimensional modeling
• Must have some experience in Python scripting
• Must be a team-player and willing to work under tight timeline
• Other duties as assigned

• Bachelor’s Degree in Computer Science, Computer Engineering, Information Systems or related field or equivalent relevant experience.
• 8 years of hands‑on experience using Informatica Power Center, IICS, IDQ tools.
• 3 years of experience in Python with data science libraries is plus.
• Should have worked on complex reporting scenarios involving Multiple Tables, Loops, Contexts, Prompts, Aggregate Awareness, Derived Tables, Charts, Ranking, and Percentages etc.
• Solid hands‑on experience in SQL programming and writing stored procedures, functions, views, SQL queries is required.
• Ability to quickly assess data structures and processes to interpret how business data sets relate to each other.
• Strong desire to learn how things work and to apply that knowledge to problem resolution.

All Associates must comply with the Health Insurance Portability Accountability Act of 1996 (HIPAA) as it pertains to disclosures of protected health information (PHI) as described in the Notice of Privacy Practices and HIPAA Privacy Policies and Procedures. As a component of job roles and responsibilities, Associates may have access to covered information, cardholder data or other confidential customer information which must be…