Informatica ETL Engineer

E-Solutions Group - Chicago, IL

Full-time

Chicago, IL

Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services

About the position

We are seeking a skilled Informatica PowerCenter ETL Engineer to join our team in Chicago, IL. This long-term contract position requires a strong focus on ETL processes, data integration, and Master Data Management (MDM). The ideal candidate will have extensive experience in Informatica tools and will be responsible for designing, developing, and maintaining ETL processes while collaborating with cross-functional teams.

Responsibilities

• Design, develop, and maintain ETL processes using Informatica PowerCenter.
• Implement and manage data integration solutions to ensure seamless data flow across systems.
• Develop and support MDM solutions to ensure data consistency, accuracy, and reliability.
• Optimize ETL processes for performance and scalability.
• Ensure high data quality through validation, cleansing, and transformation processes.
• Work closely with business analysts, data architects, and other stakeholders to understand data requirements and deliver solutions.
• Create and maintain comprehensive documentation for ETL processes, data mappings, and workflows.
• Provide post-production support and troubleshoot issues as needed.

Requirements

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• 5+ years of experience in ETL development using Informatica PowerCenter.
• Proven experience in data integration and MDM.
• Strong SQL skills and experience with relational databases (e.g., Oracle, SQL Server).
• Experience with Unix/Linux scripting.
• Excellent problem-solving and analytical skills.
• Strong communication and interpersonal skills.
• Ability to work independently and as part of a team.

Nice-to-haves

• Knowledge of data warehousing concepts and BI tools is a plus.