EDW Informatica ETL Developer (4 positions)

Lensa; United States; Remote; USD 170,000 - 720,000; Full time

Job summary

Lensa is seeking an experienced Informatica ETL Developer to join their Enterprise Data Warehouse team. This fully remote role focuses on designing, developing, and maintaining ETL processes, primarily for healthcare data systems. Candidates should have extensive experience with Informatica, SQL, and data warehousing best practices. Strong communication and collaboration skills are essential.

Qualifications

• 7+ years of ETL development experience.
• 5+ years with SQL and performance tuning.
• Experience with Teradata utilities.

Responsibilities

• Design and implement ETL solutions using Informatica PowerCenter.
• Automate data staging processes and optimize ETL job scheduling.
• Collaborate with stakeholders for requirement definitions.

Skills

SQL

Data integration

Performance tuning

Data warehousing best practices

Communication

Collaboration

Education

Bachelor's degree in IT, Computer Science, Mathematics or related field

Tools

Informatica PowerCenter

Teradata

Unix Shell scripting

Job description

2 days ago Be among the first 25 applicants

Lensa is a career site that helps job seekers find great jobs in the US. We are not a staffing firm or agency. Lensa does not hire directly for these jobs, but promotes jobs on LinkedIn on behalf of its direct clients, recruitment ad agencies, and marketing partners. Lensa partners with DirectEmployers to promote this job for DATAMAXIS.

Location: Telecommute (with occasional travel to Springfield, IL)

Rate: depending on experience

Job Summary

We are seeking a highly experienced Informatica Extract Transform Load (ETL) Developer to join our Enterprise Data Warehouse (EDW) team. This role is responsible for designing, developing, and maintaining robust ETL processes using Informatica PowerCenter and Teradata. The ideal candidate will have a deep understanding of data integration, performance tuning, and data warehousing best practices, with a focus on supporting healthcare-related data systems.

Required Qualifications

• 7+ years of experience with Informatica PowerCenter and ETL development.
• 5+ years of experience writing complex SQL and performance tuning.
• 5+ years of experience with Teradata (v17+), including Fastload, TPT, and Multiload utilities.
• 5+ years of Informatica PowerCenter administration experience.
• 2+ years of Unix Shell (Bash/Korn) scripting experience.
• Strong communication, collaboration, and mentoring skills.
• Bachelor's or advanced degree in IT, Computer Science, Mathematics, or a related field.
• Strong organizational and time management skills.
  
  

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

Key Responsibilities

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

If you have questions about this posting, please contact [e-mail]

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Business Development and Sales

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Lensa by 2x

Sign in to set job alerts for “ETL Developer” roles.

Continue with Google Continue with Google

Continue with Google Continue with Google

United States $170,000 - $720,000 3 days ago

United States $170,000 - $720,000 2 weeks ago

United States $170,000 - $720,000 1 week ago

United States
$170,000.00
-
$720,000.00
2 weeks ago

Remote Role - SSIS ETL Developer with State of Louisiana

United States
$90,000.00
-
$110,000.00
2 weeks ago

California, United States
$100,000.00
-
$720,000.00
2 weeks ago

United States
$125,000.00
-
$130,000.00
5 days ago

Remote Alteryx ETL developer Full time or Part Time

Senior ETL Developer Lead with Guidewire Experience - Remote

Yonkers, NY
$110,000.00
-
$120,000.00
5 days ago

United States
$75,000.00
-
$80,000.00
2 weeks ago

Chicago, IL
$80,000.00
-
$130,000.00
7 months ago

Columbus, OH $90,000 - $110,000 4 hours ago

United States $98,000 - $108,000 1 week ago

Gaithersburg, MD $96,058.56 - $144,081.59 1 month ago

Software Engineer L5 - Data and Feature Infrastructure, Machine Learning Platform

United States $100,000 - $720,000 2 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.