VHSenior ETL Developer_IT
Versant Health is a leading managed vision care company focused on enhancing eye health and providing comprehensive vision solutions.
Senior 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?
Senior 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 Informatca 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.
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.
• 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
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 [$125,000.00 to $130,000.00].
All incentives and benefits are subject to the applicable plan terms.
Apply now
Please let Versant Health know you found this job on Himalayas. This helps us grow!
About the job
Apply before
Posted on
Job type
Full Time
Experience level
Senior
Salary
Salary: 130k-130k USD
Location requirements
Hiring timezones
Italy +/- 0 hoursJob categories
About Versant Health
Learn more about Versant Health and their company culture.
Versant Health is dedicated to the mission of helping members enjoy the wonders of sight through healthy eyes and vision. Our operations include a variety of services, such as Commercial Third Party, Government Solutions, and Provider Networks. Our commitment goes beyond just providing vision care; we strive to be a resource for eye health and engage in initiatives that promote eye care awareness.
As one of the nation's leading managed vision care companies, Versant Health is powered by Davis Vision and Superior Vision, providing quality service backed by decades of experience. Our infrastructure supports a fully automated eyewear manufacturing lab, testing and certifying eyeglass production, delivering stylish, affordable, and high-quality eyewear to customers across the U.S. We are proud to serve over 41 million members, collaborating with over 30 Fortune 1000 companies. Our continuous innovation in vision care reflects our commitment to enhancing members' health and quality of life.
VHVersant Health
Company size
1001-5000 employees
Founded in
2017
Chief executive officer
Meredith Ryan-Reid
Markets
Employees live in
United StatesSimilar remote jobs
Here are other jobs you might want to apply for.
10 remote jobs at Versant Health
Explore the variety of open remote roles at Versant Health, offering flexible work options across multiple disciplines and skill levels.
Remote companies like Versant Health
Find your next opportunity by exploring profiles of companies that are similar to Versant Health. Compare culture, benefits, and job openings on Himalayas.
Find your dream job
Sign up now and join over 85,000 remote workers who receive personalized job alerts, curated job matches, and more for free!
Japan only
Canada only
Taiwan only
