Informatica Data Integration Architect

Location: Mechanicsburg, PA 17050
Work Arrangement: 100% Onsite (Mechanicsburg, PA 17050)
Schedule: 8 hours/day
Interview: Virtual
Contract: Sep 28, 2026 - Mar 27, 2027 (6 Months)
Visas Accepted: USC, GC

Role Overview

This Informatica Data Integration Architect role will design, develop, optimize, and support enterprise ETL/ELT solutions across data warehouse, data lake, and analytics environments. The position centers on Informatica PowerCenter, Informatica Intelligent Data Management Cloud (IDMC), SQL, scalable data integration patterns, and production data operations.

This is a 100% onsite role in Mechanicsburg, Pennsylvania. Candidates must be local to the area or willing to relocate.

Primary Responsibilities

• Design, develop, and maintain ETL/ELT solutions using Informatica PowerCenter and IDMC (CDI) to support enterprise data warehouse, data lake, and analytics platforms.
• Analyze source systems and business requirements to implement scalable data integration, transformation, and loading processes.
• Develop and optimize Informatica mappings, workflows, taskflows, and SQL queries to ensure performance, reliability, and data quality.
• Support data warehouse processing, including fact and dimension loading, historical data management, and data validation.
• Provide production and on-call support, troubleshoot ETL failures, resolve data issues, and perform root cause analysis.
• Support deployments across DEV, TEST, UAT, and PROD environments, including monitoring, validation, and release support.

Required Technical Skills

• Advanced hands-on experience with Informatica PowerCenter and Informatica Intelligent Data Management Cloud (IDMC).
• Expert understanding of ETL/ELT architecture, data integration patterns, data warehousing, and Data Lake/Lakehouse concepts.
• Advanced SQL capability for data analysis, troubleshooting, and performance tuning.
• Advanced practical experience supporting production ETL environments, including incident management, root cause analysis, and on-call support.
• Advanced capability in performance optimization and tuning of ETL workflows, mappings, and database queries.
• Advanced knowledge of batch processing, workflow monitoring, and job recovery procedures.
• Strong independent working capability with effective collaboration across cross-functional teams.
• Advanced analytical and problem-solving capability with strong communication skills.

Preferred Qualifications

• Working experience with public sector data platforms, including Integrated Eligibility systems and Medicare/Medicaid claims and encounters data.
• Basic familiarity with Oracle and/or SQL Server.
• Advanced practical experience with Azure Cloud Services, including Azure Data Lake Storage (ADLS Gen2).
• Working experience in regulated, compliance-driven, healthcare, or government environments.
• Advanced experience with batch scheduling and monitoring tools such as Control-M, Autosys, and Informatica Workflow Monitor.
• Advanced experience supporting cloud-based data integration and modernization initiatives.
• Advanced knowledge of Agile delivery methodologies and DevOps practices.