Solution Architect Informatica BDM & PowerExchange

Overview

Requirements

• 15-20 years of overall IT experience
• 8+ years working with Informatica BDM/DEI and Big Data platforms
• 5+ years in Solution Architecture or Technical Leadership roles
• Banking/BFSI experience preferred
• Experience delivering large-scale data migration and modernization programs

Informatica & Data Integration

• Strong expertise in Informatica Data Engineering Integration (BDM/DEI)
• Experience designing scalable ETL/ELT frameworks and reusable components
• Knowledge of Spark-based processing and pushdown optimization
• Experience with batch and near real-time data ingestion

Powerexchange & Cdc

• Hands-on experience with Informatica PowerExchange and Change Data Capture (CDC)
• Designing real-time and incremental data ingestion from Oracle, PostgreSQL, and other RDBMS platforms

Data Lakehouse & Big Data

• Strong understanding of Data Lakehouse architectures and Medallion (Bronze/Silver/Gold) design
• Experience with Spark, Hadoop, Hive, and large-scale data processing
• Familiarity with Iceberg, Hudi, or Delta Lake is preferred

Data Architecture & Migration

• Experience designing historical and incremental migration pipelines
• Ability to assess legacy environments and define migration, remediation, and optimization strategies
• Strong data modeling knowledge (ODS, DWH, Dimensional Models)

Governance & Performance

• Experience with data quality, lineage, security, and governance frameworks
• Expertise in performance tuning, partitioning, and high-volume data processing

Responsibilities

• Design and implement Informatica-based ETL/ELT and CDC architectures
• Lead PowerExchange-based ingestion and data migration initiatives
• Build scalable batch and real-time data pipelines
• Drive migration remediation, reconciliation, and data quality activities
• Optimize platform performance and ensure governance compliance
• Collaborate with business, architecture, and reporting teams to deliver end-to-end data solutions
• Produce architecture, design, and source-to-target mapping documentation
• *** Only successful candidates will be contacted ***
• Salt is acting as an Employment Agency in relation to this vacancy.