> Markdown version of [/jobs/ext/2853260-informatica-data-integration-architect](https://www.wearedevelopers.com/jobs/ext/2853260-informatica-data-integration-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Informatica Data Integration Architect - **Company:** ProRec Resource Solutions - **Location:** Mechanicsburg, PA, United States - **Contract:** Temporary contract - **Skills:** Agile Methodology, Business Analytics Applications, Data Analysis, CA Workload Automation Ae, Microsoft Azure, Batch Processing, Cloud Computing, Cloud Database, Databases, Data Validation, Data Integration, Extract Transform Load (ETL), Data Warehousing, Database Queries, DevOps, Monitoring of Systems, Systems Analysis, Data Intelligence, Microsoft SQL Server, Operational Databases, Oracle Databases, Oracle (Applications), Performance Tuning, Azure Data Lake, SQL Databases, Systems Integration, Data Storage Technologies, Sql Optimization, Informatica Powercenter, Data Lakes, Data Management, Control M - **Published:** September 11, 2026 - **Apply:** https://www.careerbuilder.com/job-details/informatica-data-integration-architect-mechanicsburg-pa--dba9b126-20cb-44bf-93a4-578ddaec00c7 ## About the Role * 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., * 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. Skills: Acceptance Testing, Agile Programming Methodologies, Analysis Skills, CA Workload Automation AE (AutoSys Edition), Cloud Computing, Communication Skills, Cross-Functional, Data Analysis, Data Lake, Data Management, Data Quality, Data Storage, Data Warehousing, Database Extract Transform and Load (ETL), DevOps, Environmental Monitoring, Government, Healthcare, Identify Issues, Incident Management, Informatica, Maintain Compliance, Medicaid, Medicare, Microsoft SQL Server, Microsoft Windows Azure, On Call, Oracle Database, Performance Tuning/Optimization, Problem Solving Skills, Production Support, Production Systems, Root Cause Analysis, SQL (Structured Query Language), System Integration (SI), Systems Analysis, Testing ## Description 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., * 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. ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Brewing Tea over the Internet](https://www.wearedevelopers.com/videos/697-brewing-tea-over-the-internet) - [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Database DevOps with Containers](https://www.wearedevelopers.com/videos/145-database-devops-with-containers) - [Automated MS SQL Server database deployments with dacpacs and Azure DevOps](https://www.wearedevelopers.com/videos/334-automated-ms-sql-server-database-deployments-with-dacpacs-and-azure-devops) ## Related Articles - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Best Coding Boot Camps in Germany](https://www.wearedevelopers.com/magazine/237-best-coding-boot-camps-in-germany) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)