Application Developer – Informatica ETL

TechDigital Group

Chicago (IL)

On-site

USD 90,000 - 120,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

A technology firm is seeking an experienced Application Developer in Chicago to design and maintain ETL workflows using Informatica and optimize data pipelines on Yellowbrick. The ideal candidate should have 5–10+ years in ETL development and a solid understanding of data warehousing, regulatory compliance, and insurance data. Strong SQL and analytical skills are vital for success in this role, as well as the ability to collaborate with stakeholders and provide production support.

Qualifications

  • 5–10+ years of hands-on experience in Informatica ETL development.
  • Strong experience with Yellowbrick or similar MPP data warehouse platforms.
  • Solid understanding of data warehousing and ETL best practices.

Responsibilities

  • Design, develop, and maintain ETL workflows using Informatica.
  • Optimize data pipelines on Yellowbrick data warehouse.
  • Document ETL processes and provide production support.

Skills

Informatica ETL development
Yellowbrick
SQL
data profiling
performance optimization
problem-solving
communication

Tools

Informatica PowerCenter
Informatica IICS

Job description

Project Domain: Insurance Technology
Department: Application Development

We are seeking an experienced Application Developer with strong expertise in Informatica ETL and Yellowbrick to join our Insurance Technology team. The ideal candidate will design, develop, and maintain data integration solutions that support insurance operations, analytics, and compliance requirements.

Key Responsibilities
Technical Responsibilities
  • Design, develop, and maintain ETL workflows using Informatica PowerCenter or Informatica IICS.
  • Build and optimize data pipelines on Yellowbrick data warehouse platform.
  • Collaborate with business analysts and insurance stakeholders to gather requirements and translate them into technical solutions.
  • Ensure data accuracy, consistency, and compliance with insurance regulatory standards.
  • Perform performance tuning and troubleshooting of ETL jobs and SQL queries.
  • Document ETL processes, data mappings, and system configurations.
  • Provide production support and resolve data-related issues promptly.
Optional Team Lead Responsibilities (if applicable)
  • Lead and mentor a team of ETL and data warehouse developers.
  • Allocate tasks, manage workloads, and ensure timely delivery of project milestones.
  • Conduct code reviews and enforce coding standards and best practices.
  • Coordinate with cross-functional teams including QA, DevOps, and business stakeholders.
  • Facilitate Agile ceremonies such as sprint planning and daily stand-ups.
  • Act as a point of escalation for technical and delivery challenges.
Required Skills & Qualifications
  • 5–10+ years of hands-on experience in Informatica ETL development.
  • Strong experience with Yellowbrick or similar MPP data warehouse platforms.
  • Proficiency in SQL, data profiling, and performance optimization.
  • Solid understanding of data warehousing, data modeling, and ETL best practices.
  • Experience working in the insurance domain, with knowledge of policy, claims, and regulatory data.
  • Excellent problem-solving, analytical, and communication skills.
Preferred Qualifications
  • Exposure to cloud platforms (AWS, Azure) and cloud-native data tools.
  • Experience with data governance and compliance frameworks.
  • Insurance certifications or domain-specific training is a plus.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Informatica Developer
Informatica Developer

TechDigital Group • Morristown (NJ)

On-site
USD 100,000 - 130,000
Informatica Developer
Informatica Developer

TechDigital Group • Denver (CO)

On-site
USD 95,000 - 120,000
Informatica Developer - Bloomington, IL
Informatica Developer - Bloomington, IL

AHU Technologies Inc. • United States

Remote
USD 120,000 - 170,000
ETL Informatica Developer
ETL Informatica Developer

Envision Technology Solutions • Plano (TX)

On-site
USD 85,000 - 120,000
ETL Informatica PowerCenter Developer
ETL Informatica PowerCenter Developer

OptechUs • Auburn Hills (MI)

On-site
USD 90,000 - 110,000
ETL Informatica/Hadoop Developer
ETL Informatica/Hadoop Developer

Envision Technology Solutions • Plano (TX)

On-site
USD 90,000 - 150,000
ETL Developer
ETL Developer

Ethereum Technologies LLC • Charlotte (NC)

On-site
USD 90,000 - 130,000
Informatica Developer
Informatica Developer

TechDigital Group • Purchase (NY)

On-site
USD 120,000 - 150,000
ETL Engineer
ETL Engineer

Valiant Technologies LLC • Columbia (SC)

On-site
USD 110,000 - 150,000
Informatica Developer
Informatica Developer

Ethereum Technologies LLC • Atlanta (GA)

On-site
USD 110,000 - 150,000