Technical Architect

Informatica DEI / BDM Technical Architect – Data Lakehouse

Experience- 10 to 15+ Years

• Define and govern end-to-end Informatica DEI/BDM architecture aligned with the Data Lakehouse strategy.
• Design enterprise data integration patterns for batch, micro-batch, and real-time processing.
• Establish architecture standards, reusable frameworks, and best practices across development and operations.
• Review and approve technical designs, mappings, workflows, and deployment models.

Design ingestion and transformation pipelines across:

• Architect scalable ETL/ELT solutions for structured, semi-structured, and unstructured data.
• Ensure metadata-driven development and reusable integration components.

• Spark-based processing
• Define coding standards, deployment standards, and performance guidelines.
• Mentor development teams and conduct architecture reviews.

• Architect real-time and near real-time integration using:
• CDC (Change Data Capture)
• Kafka integration
• Ensure low-latency, scalable, and resilient integration frameworks.

Hadoop Ecosystem

• Optimize distributed processing, workload balancing, and resource utilization.

• Implement metadata management, lineage, and impact analysis.
• Ensure compliance with enterprise data governance standards.
• Support data quality, reconciliation, validation, and auditability requirements.

• Define optimization strategies for:
• Mappings
• Workflows
• Blaze executions
• Ensure scalability, fault tolerance, high availability, and operational excellence.
• Support 24x7 production environments and critical BFSI workloads.

• Oracle
• SQL Server
• APIs
• Messaging platforms
• Optimize source extraction and target load performance.

• Identify design, scalability, and performance gaps.
• Lead remediation, modernization, and optimization initiatives.
• Support onboarding of new data sources and business domains.

• Work closely with:
• Data Architects
• Cloudera Platform Teams
• Business Stakeholders
• Participate in architecture governance boards and design reviews.
• Provide technical leadership across onsite and offshore teams.

10+ years of Informatica experience.

• Strong expertise in:
• Experience with CDC and real-time ingestion architectures.
• Cloudera Data Platform (CDP)
• Hadoop Ecosystem
• Spark
• Hive
• HDFS
• Kafka
• Data Lakehouse Expertise
• Data Lakehouse Architecture
• Data Modeling Concepts
• Data Governance Frameworks
• Databases
• Oracle
• SQL Server
• Performance tuning and optimization
• Architecture & Engineering Skills
• ETL / ELT Design Patterns
• Capacity Planning
• Scalability & High Availability Design
• Dev Ops & CI/CD Integration
• Domain Expertise
• Regulatory Reporting
• Customer, Finance, Risk and Treasury Data Domains
• Experience with FSLDM / FSAS is highly preferred

• Informatica Professional / Architect Certifications.
• Experience in large-scale Banking Data Lakehouse programs.
• Experience with Cloudera, Kafka, and Enterprise Data Warehousing.
• Knowledge of Data Vault, FSLDM, FSAS, and Medallion Architecture.

• 10–15+ years in enterprise data integration and architecture.
• Minimum 5+ years as Informatica DEI/BDM Architect.
• Proven experience delivering large-scale BFSI Data Lakehouse or Data Warehouse transformation programs.
• Experience managing hybrid onsite-offshore delivery models.