Informatica Data Integration Architect

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.

• 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