ETL Informatica Developer- W2

Location:
Onsite-Waukegan, IL OR Pleasant Prairie, WI

Type: FTE with client

Fuel the future of data engineering and analytics for our growing North American company! As a Senior Informatica Developer, you’ll play a pivotal role in constructing and maintaining our new, cutting-edge data collection systems and analytics platform.

• Strong Informatica Power Center expertise;
  Ability to work with ETL/data integration pipelines;
  Ability to navigate complex source → target integrations;
• Strong SQL (heavy SQL Server environment);
  Comfort working with DB2;
• Understanding of Snowflake/star schema data modelling. Hands-on experience with data warehouse projects

• Partner with business users to design and build BI and data warehouse solutions.
• Engage with project leads, analysts and business users to implement and test data warehouse applications.
• Build complex data engineering processes to support business analytics and reporting.
• Perform unit, performance and regression testing on ETL mappings.
• Follow coding standards, review code and enhance quality practices.
• Oversee production deployments and coordinate with other teams to execute.
• Bachelor s degree in information technology or related field.
• 8+ years in data engineering.
• 5+ years of hands-on experience developing ETL using Informatica Power Center.
• Proven experience writing complex T-SQL and DB performance tuning.
• Strong troubleshooting skills to resolve data issues.
• Knowledge of SSIS, Python, Azure, Snowflake or Databricks is a plus.