Application Developer – Informatica ETL

TechDigital Group; Chicago (IL); On-site; USD 90,000 - 120,000; Full time

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.