ETL Developer

ETL Developer

Who are we?

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™.

What are we looking for?

Informatica ETL Developer is primarily responsible for supporting ETL development using Informatica PowerCenter 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. 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.

Where you will have an impact

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

What’s necessary to do the job?

Bachelor’s Degree in Computer Science, Computer Engineering,

Information Systems or related field or equivalent relevant experience.

6+ years of hands-on experience using Informatica Power center, IICS IDQ tools

2+ 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

HIPAA & Security Requirements

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 protected at all times. As a result, Associates must explicitly adhere to all data security guidelines established within the Company’s Privacy & Security Training Program.

Versant Health will never request money from candidates who seek employment with us and will never ask for any payment as part of the recruitment process.

Versant Health is a proud Equal Employment Opportunity and Affirmative Action employer dedicated to attracting, retaining, and developing a diverse and inclusive workforce. All qualified applicants will receive consideration for employment at Versant Health without regards to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity or expression, age, disability, national origin, marital or domestic/civil partnership status, genetic information, citizenship status, uniformed service member or veteran status, or any other characteristic protected by law.

The wage range for applicants for this position is [$100,000.00 to $110,000.00].

All incentives and benefits are subject to the applicable plan terms.