Big Data Management Technical Architect – Data Lakehouse

Informatica BDM (Big Data Management) Technical Architect – Data Lakehouse

Experience : 10 – 15 years

An Informatica / BDM Technical Architect is responsible for designing, governing, and implementing enterprise-scale data integration and Data Lakehouse solutions using Informatica technologies. The architect defines end-to-end data ingestion, transformation, and processing frameworks across Big Data platforms such as Cloudera, Hadoop, and Spark while ensuring scalability, performance, data governance, and real-time integration capabilities.

• 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.
• Lead architecture and governance of:
• 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.
• Cloudera Data Platform (CDP)
• 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.
• Design integrations with:
• 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 Architecture
• Data Modeling Concepts
• Data Governance Frameworks

• Oracle
• SQL Server
• Performance tuning and optimization

• ETL / ELT Design Patterns
• Capacity Planning
• Scalability & High Availability Design
• Dev Ops & CI/CD Integration

• 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.