Data Warehouse Engineer (Informatica)

Job Title: Data Warehouse Engineer (Informatica)

Location: Uncasville, CT (Hybrid)

Job Type: Full-Time

Experience Required: 8+ Years

Job Summary

We are seeking an experienced Data Warehouse Engineer with strong expertise in Informatica, Snowflake, SQL, and Python to design, develop, and support enterprise data warehouse solutions. The ideal candidate will have hands-on experience building scalable ETL processes, optimizing cloud data warehouse environments, integrating data from multiple sources, and supporting business intelligence and analytics initiatives.

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 data validation and quality assurance processes.

• Develop Python scripts and automation solutions for data integration and processing.

<>Data Warehouse Design & Optimization

• Design and maintain data warehouse schemas, tables, views, and related database objects.

• Optimize query performance and implement best practices for scalability and efficiency.

• Perform performance tuning, partitioning, and data architecture improvements.

• Support and maintain cloud-based data warehouse platforms.

<>Data Pipeline Development

• Build and maintain scalable data pipelines and ingestion frameworks.

• Develop integrations using APIs and web services.

• Support real-time and batch data processing requirements.

• Ensure data reliability, availability, and performance.

<>Business Intelligence Support

• Partner with business and technical stakeholders to gather requirements and deliver data solutions.

• Troubleshoot complex data and reporting issues.

• Support business intelligence and analytics platforms.

• Ensure high-quality, accurate, and accessible data for reporting and decision-making.

Required Qualifications

• Bachelor''s degree in Computer Science, Engineering, Information Systems, or a related field.

• 5+ years of experience in data warehousing, ETL development, and database management.

• Strong hands-on experience with Informatica.

• Experience working with Snowflake data warehouse platforms.

• Advanced SQL development and query optimization skills.

• Python programming experience for data engineering and automation.

• Experience with API integration and data exchange processes.

• Strong analytical, troubleshooting, and problem-solving abilities.

• Excellent communication and collaboration skills.

Preferred Qualifications

• Experience with Power BI and/or Cognos.

• Strong understanding of data modeling and data architecture principles.

• Experience with cloud-based data warehouse technologies.

• Familiarity with Snowflake features such as Snowpipe, Streams, Tasks, and Data Sharing.

• Knowledge of SDLC methodologies and data governance best practices.

• Experience with ITIL, COBIT, or similar governance frameworks.

Work Arrangement

Hybrid position based in Uncasville, Connecticut.