Data Warehouse Engineer (Informatica Lead)

Job Title: Data Warehouse Engineer
Location: Uncasville, CT
Work Mode: Hybrid
Experience Required: 14–20 Years
Employment Type: Fulltime

Role Overview
We are seeking an experienced Data Warehouse Engineer to design, develop, and maintain enterprise data warehouse infrastructure and ETL solutions that support business intelligence, analytics, and strategic decision-making.

This role requires strong expertise in Informatica, Snowflake, SQL, Python, and modern data engineering practices. The successful candidate will work closely with business stakeholders and technical teams to deliver scalable, reliable, and high-performing data solutions.

Key Responsibilities
ETL Development & Data Integration
Design, develop, and maintain complex ETL workflows using Informatica.
Extract, transform, and load data from multiple source systems into enterprise data warehouse environments.
Implement automated validation and reconciliation processes to ensure data accuracy and integrity.
Develop Python scripts and APIs for automation, data processing, and system integration.
Support enterprise-wide data integration initiatives.
Data Warehouse Design & Optimization
Design and maintain scalable data warehouse structures including schemas, tables, views, and materialized views.
Optimize performance through query tuning, clustering strategies, and partitioning techniques.
Apply best practices in data modeling and data architecture.