Datawarehouse Consultant

Job Title – Data warehouse Consultant

Company – TCS (MEA)

Location – Jeddah, Saudi Arabia

Job type – Full time

Tata Consultancy Services (TCS) is an IT services, consulting and business solutions organization that has been partnering with many of the world’s largest businesses in their transformation journeys for over 50 years. TCS offers a consulting‑led, cognitive powered, integrated portfolio of business, technology and engineering services and solutions. This is delivered through its unique Location Independent Agile delivery model, recognized as a benchmark of excellence in software development.

A part of the Tata group, India's largest multinational business group, TCS has over 616,171 of the world’s best‑trained consultants with 157 nationalities in 53 countries. For more information, visit  and follow TCS news at @.

• Own and govern the end-to-end Data Lakehouse architecture
  , ensuring consistency across data ingestion, storage, processing, consumption, and governance layers.
• Define and validate the target state Medallion Architecture (Bronze, Silver, Gold) in alignment with enterprise architecture principles.
• Ensure robust architectural patterns for batch, near real‑time, and historical data processing.

• Ensure architectural consistency and seamless integration across:
• Cloudera Data Platform
• Teradata Enterprise Data Warehouse
• Informatica (ETL, Data Quality, Metadata)
• Denodo (Data Virtualization & Consumption)
• Review and approve low‑level designs, data flows, and integration patterns across platforms.

• Perform architectural assessment and validation of Phase 1 deliverables
  , including:
• Data pipelines
• Logical and physical data models
• Gold layer aggregations (Teradata)
• Identify architectural gaps, anti‑patterns, and misalignments.
• Define remediation and rebuild strategies aligned with target architecture.

• Govern the implementation of logical and physical data models aligned to:
• FSLDM (Financial Services Logical Data Model)
• FSAS aggregation standards
• Ensure correctness, consistency, and reusability of enterprise and subject‑area models.
• Validate aggregation logic, hierarchies, and reporting readiness.

• Ensure alignment with:
• NDMO (National Data Management Office)
• NDI (National Data Index)
• data classification, privacy, and security standards
• Oversee metadata, lineage, data quality, and auditability design.
• Ensure architecture supports regulatory reporting, traceability, and reconciliation requirements.

• Define architecture patterns for:
• High availability (≥99.9% uptime)
• Horizontal scalability
• Disaster recovery and point‑in‑time restore
• Review and guide performance tuning strategies for ingestion, transformation, and reporting workloads.

• Act as the primary architectural interface with IT, Data Governance, Security, and Business teams.
• Participate in architecture review boards, design walkthroughs, and governance forums.
• Clearly articulate architectural decisions, trade‑offs, and impacts to senior stakeholders.

• Strong experience in Enterprise Data Architecture
  , including:
• EDW modernisation
• Data Lake / Lakehouse architectures
• Medallion architecture patterns
• Deep understanding of BFSI data domains and enterprise reference models:
• FSLDM
• FSAS
• Hands‑on architectural exposure to:
• Cloudera CDP (HDFS, Spark, Hive, Kafka)
• Teradata Vantage
• Informatica (ETL)
• Denodo

• Proven experience designing governance‑driven architectures:
• Metadata and lineage
• Data quality frameworks
• Security, masking, and encryption
• Strong understanding of regulatory and compliance‑driven data platforms.

• Expertise in:
• Performance and workload optimization
• Scalability and capacity planning
• Resilience, backup, and recovery design

• Strong communication and stakeholder management skills.
• Ability to lead cross‑vendor and cross‑functional technical discussions.
• Governance mindset with pragmatic delivery orientation.

Thank you for your interest in applying for this position with TCS. We will review your application and will get back to you if we are considering your interest in this opportunity.

Final date to receive applications: 30‑May‑2026

Privacy Notice: