Informatica Data Lakehouse – BDM, CDC & Axon Platform Administrator & Support Engineer

Position Overview

TCS (MEA) is seeking a highly skilled Informatica Data Lakehouse – BDM, CDC & Axon Platform Administrator & Support Engineer to join our dynamic team in Jeddah, Saudi Arabia. This role is pivotal in administering, supporting, and optimizing our enterprise-grade data integration and governance platforms, ensuring seamless data operations across our Data Lakehouse and Data Warehouse environments. The ideal candidate will possess deep expertise in Informatica’s BDM/DEI, PowerExchange (CDC), and Axon platforms, along with a strong background in Spark-based ETL processing, Oracle databases, and 24/7 production support.

Key Responsibilities

As a core member of our data operations team, you will be responsible for the following critical functions:

• Informatica Platform Administration (BDM / DEI):
  • Administer and support the Informatica Data Engineering Integration (BDM/DEI) platform, including configurations, services, and environment setups.
  • Manage Spark-based runtime execution for ETL pipelines, ensuring optimal performance and reliability.
  • Execute upgrades, patching, and routine maintenance to keep the platform secure and up-to-date.
• Batch Data Integration Support:
  • Monitor and support ETL workflows, mappings, and pipelines to ensure adherence to SLAs for batch data loads into the Data Lakehouse.
  • Perform failure handling, reruns, and recovery activities to minimize downtime and data loss.
  • Optimize performance through techniques such as partitioning, pushdown optimization, and tuning.
• Real-Time Integration (CDC Support):
  • Monitor CDC pipelines, including capture and apply processes, to ensure reliable real-time and near real-time data ingestion.
  • Troubleshoot latency, lag, and data consistency issues to maintain seamless integration between the Data Warehouse and Data Lakehouse.
• Metadata & Governance (Axon Support):
  • Administer and support Informatica Axon and other data governance tools to ensure data lineage, business glossary, and metadata traceability.
  • Maintain governance standards across enterprise data platforms to support audit, compliance, and data quality initiatives.
• Platform & Runtime Support (Tomcat, Spark):
  • Monitor Informatica services running on Tomcat and support Spark cluster execution and resource utilization.
  • Troubleshoot service failures, memory issues, and performance bottlenecks to ensure platform availability and stability.
• Database & Repository Management (Oracle Metadata Repository):
  • Manage Informatica metadata repositories in Oracle, including performance monitoring, storage management, and connectivity.
  • Support backup, restore, and repository maintenance activities to ensure data integrity and availability.
• Incident & Change Management:
  • Provide L1/L2 production support using ITIL processes to resolve incidents and implement fixes promptly.
  • Conduct root cause analysis (RCA) and recommend preventive measures to avoid recurrence.
  • Support deployments, releases, and production cutovers, including participation in on-call and shift-based support rotations.
• Monitoring, Documentation & Automation:
  • Maintain comprehensive runbooks, standard operating procedures (SOPs), and operational dashboards for efficient platform management.
  • Automate monitoring, alerting, and routine administrative tasks to enhance operational efficiency and reduce manual intervention.
  • Document platform architecture, support procedures, and troubleshooting guides to ensure knowledge continuity.

Technology Stack

The successful candidate will work with the following technologies and platforms:

• Data Integration: Informatica BDM / DEI (Big Data Management)
• CDC / Real-Time: Informatica PowerExchange
• Governance: Informatica Axon
• Runtime: Spark, Tomcat
• Database: Oracle (Metadata Repository)
• Platform: Data Warehouse + Cloudera Data Lakehouse

Required Skills & Experience

To excel in this role, candidates must meet the following qualifications:

• Experience: 5–8 years in Informatica platform administration and support, with a focus on BDM/DEI, PowerExchange (CDC), and Axon.
• Technical Expertise: Strong knowledge of Spark-based ETL processing, Oracle databases, and metadata repositories.
• Data Platforms: Hands-on experience with Data Lakehouse and Data Warehouse integration environments.
• Troubleshooting & Performance Tuning: Proven ability to diagnose and resolve complex issues, optimize performance, and implement best practices.
• Support Skills: Experience in providing 24/7 SLA-driven production support in dynamic, high-pressure environments.
• Collaboration: Excellent communication and teamwork skills to collaborate with cross-functional teams, including developers, architects, and business stakeholders.

Why Join TCS?

TCS is a global leader in IT services, consulting, and business solutions, with a rich legacy of over 50 years in driving digital transformation for enterprises worldwide. As part of the esteemed Tata group, we offer a collaborative work environment, opportunities for professional growth, and the chance to work with cutting-edge technologies on transformative projects. Our Location Independent Agile™ delivery model ensures flexibility and excellence in software development, making TCS a benchmark in the industry.

If you are a motivated professional with a passion for data integration, governance, and platform administration, we invite you to apply for this exciting opportunity in Jeddah, Saudi Arabia.