Senior Data Warehouse/Integration Engineer

The Senior Data Warehouse/Integration Engineer will support the development, maintenance, and modernization of a large-scale enterprise data warehouse and related system-to-system integrations. The ideal candidate brings strong expertise in Informatica PowerCenter, advanced SQL skills, and experience in complex, mission-critical data integration environments.

Location: United States

Responsibilities

• Design, build, and maintain Informatica PowerCenter mappings, sessions, workflows, web services, and related data integration pipelines
• Build and support cross-system interfaces, including automated and manual data conversion processes, in alignment with project milestones
• Create and maintain accurate data mapping, operations, and maintenance documentation, including standard procedures and recurring checklists
• Assess system performance and implement tuning strategies for Informatica workflows, SQL queries, and related database processes
• Support ongoing integration reliability, scalability, and operational readiness across enterprise data warehouse environments

Requirements

• US Citizen
• BS in Computer Science, a related field or equivalent experience
• 5+ year’s experience with advanced SQL and relational data modeling
• 5+ year’s experience with data integration, ETL/ELT, and enterprise data warehouse environments
• Strong analytical and problem-solving skills
• Knowledge of Windows and/or Perl scripting
• Strong written and verbal communication skills