Informatica ETL Developer

Davita Inc.; Fishers (IN); Remote; USD 100,000 - 125,000; Full time

Job summary

A leading company is looking for an Intermediate ETL Developer. You will design and implement ETL solutions using Informatica PowerCenter, automate data processes, and provide technical support. This fully remote position requires strong skills in SQL, Teradata, and various data technologies, and offers competitive pay and benefits.

Benefits

Medical, dental & vision

401(k) Retirement Plan

Life Insurance

Short and long-term disability

Health Spending Account

Qualifications

• Automate data staging processes and optimize ETL job scheduling.
• Experience with scripting languages such as Python, R, or JavaScript.
• Knowledge of BI and data integration technologies.

Responsibilities

• Design and implement ETL solutions using Informatica PowerCenter.
• Monitor and troubleshoot ETL jobs across environments.
• Communicate project status and deliverables to leadership.

Skills

Informatica

ETL

SQL

Teradata

PowerCenter

Unix Shell

Education

5+ years of data warehouse development experience

5+ years of data modeling experience

2+ years of experience with Azure Data Factory and Snowflake

Tools

Azure

Snowflake

ERWIN

Job description

*Description*

* Design and implement ETL solutions using Informatica PowerCenter to extract, transform, and
load data from various agency sources.
* Automate data staging processes and optimize ETL job scheduling for performance and
efficiency.
* Administer and support ETL environments, including development and production systems.
* Perform repository backups, recovery operations, and system maintenance.
* Develop mappings, mapplets, sessions, and workflows using a wide range of Informatica
transformations.
* Monitor and troubleshoot ETL jobs across development, testing, and production environments.
* Write and optimize complex SQL queries and Unix Shell scripts for data marts and interfaces in
Teradata.
* Collaborate with stakeholders to define requirements, document technical solutions, and
support project planning.
* Participate in unit, integration, and system testing.
* Provide technical support, mentoring, and guidance to team members.
* Communicate project status and deliverables to leadership and clients.
* Continuously learn and apply new technologies to enhance system performance and
capabilities.

*Skills*

Informatica, etl, etl development, SQL, Teradata, PowerCenter, unix shell, Medicaid, ERWIN, Azure, Snowflake, IDQ, Medicare, Agile, BI

*Top Skills Details*

Informatica,etl,etl development,SQL,Teradata,PowerCenter,unix shell

*Additional Skills & Qualifications*

* Residing in or near Springfield, IL.
* 5+ years of data warehouse development experience.
* 5+ years of data modeling experience using ERWIN or similar tools.
* 2+ years of experience with Azure Data Factory and Snowflake.
* Experience with scripting languages such as Python, R, or JavaScript (React).
* Familiarity with Informatica Data Quality (IDQ), Address Doctor, and Metadata Manager.
* Experience with Medicaid, Medicare, or healthcare data systems.
* Experience working in Agile environments.
* Knowledge of BI and data integration technologies across relational and multidimensional
systems.

*Experience Level*

Intermediate Level
*Pay and Benefits*
The pay range for this position is $7.25 - $50.00/hr.
Eligibility requirements apply to some benefits and may depend on your job
classification and length of employment. Benefits are subject to change and may be
subject to specific elections, plan, or program terms. If eligible, the benefits
available for this temporary role may include the following:
* Medical, dental & vision
* Critical Illness, Accident, and Hospital
* 401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available
* Life Insurance (Voluntary Life & AD&D for the employee and dependents)
* Short and long-term disability
* Health Spending Account (HSA)
* Transportation benefits
* Employee Assistance Program
* Time Off/Leave (PTO, Vacation or Sick Leave)
*Workplace Type*
This is a fully remote position.
*Application Deadline*
This position is anticipated to close on Jun 20, 2025.
h4>About TEKsystems:


We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.


The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.


About TEKsystems and TEKsystems Global Services

We're a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We're a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We're strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We're building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.


The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.