Informatica and Teradata Architect – Data Warehouse Modernization

ITC Infotech India Ltd; Jeddah; On-site; USD 60,000 - 100,000; Full time

Job summary

An established industry player is on the lookout for a skilled Informatica and Teradata Architect to spearhead a transformative Data Lakehouse program for a prominent banking client. This exciting role involves leading the architecture and design of ETL frameworks, optimizing data pipelines, and ensuring data integrity across multiple systems. The ideal candidate will have extensive experience in data warehousing, ETL modernization, and a deep understanding of banking data integration. Join a forward-thinking company where your expertise will drive significant advancements in data management and analytics.

Qualifications

• 10+ years of experience in data warehousing and ETL architecture.
• Strong hands-on experience with Informatica and Teradata.
• Experience in migrating ETL logic to Lakehouse environments.

Responsibilities

• Lead the design of Informatica-based ETL frameworks for data migration.
• Develop strategies for ETL workload optimization and performance tuning.
• Collaborate with teams to ensure data accuracy and completeness.

Skills

Informatica PowerCenter

Teradata

ETL architecture

Data warehousing

Data integration

Performance tuning

Data quality frameworks

ETL lifecycle

Tools

Cloudera Data Platform (CDP)

Spark

Hive

Job description

We are seeking a highly skilled and detail-oriented Informatica and Teradata Architect to lead the data integration and warehousing architecture efforts as part of a large-scale Data Lakehouse transformation program for a leading banking client. The ideal candidate will possess deep expertise in Informatica (PowerCenter and IDQ) and Teradata, with a strong grasp of enterprise-grade data integration, ETL modernization, and data warehouse optimization. This role requires close collaboration with data architects, engineers, QA teams, and banking domain stakeholders.

Key Responsibilities:

• Lead the architecture and design of Informatica-based ETL frameworks to migrate and modernize existing data pipelines from legacy systems to the new Lakehouse platform.
• Design efficient Teradata data models to support gold-layer consumption and reporting needs.
• Develop strategies for ETL workload optimization, code migration, and performance tuning on both Informatica and Teradata platforms.
• Define standards, best practices, and governance around ETL design, parameterization, error handling, and metadata tracking.
• Work with SNB and oversight partner to map legacy DWH logic to new Cloudera-based Bronze/Silver architecture and Teradata-based Gold Layer.
• Provide technical oversight and guidance to developers and data engineers implementing integration and transformation logic.
• Collaborate with testing and validation teams to ensure data accuracy, lineage, and completeness through all layers.
• Support impact analysis and dependency checks across ~50 tables and 150+ ETL packages per source system.

Required Skills and Experience:

• 10+ years of experience in data warehousing, data integration, and enterprise ETL architecture.
• Strong hands-on experience with Informatica PowerCenter, Informatica IDQ, and Teradata (SQL, utilities, and performance optimization).
• In-depth understanding of ETL lifecycle, data quality frameworks, and integration patterns in a banking context.
• Demonstrated ability to lead ETL modernization efforts and architect scalable, reusable data pipelines.
• Experience in migrating ETL logic from on-prem systems to Lakehouse environments (e.g., Cloudera, Spark-based processing).
• Experience in tuning large-volume ETL jobs and Teradata queries to meet SLA-driven performance goals.
• Familiarity with data governance principles, error logging, and metadata management.

Preferred Attributes:

• Experience with Cloudera Data Platform (CDP), Spark, Hive, or Iceberg tables.
• Knowledge of DevOps/DataOps for Informatica deployments and integration with CI/CD tools.
• Exposure to data masking, synthetic data generation, and regulatory data controls.
• Good understanding of banking use cases in areas like risk reporting, compliance, credit, and finance.

Employment Type

Full Time

Company Industry

• IT - Software Services

Department / Functional Area

• IT Software

Keywords

• ETL Architect
• Informatica

Disclaimer: Naukrigulf.com is only a platform to bring jobseekers & employers together. Applicants are advised to research the bonafides of the prospective employer independently. We do NOT endorse any requests for money payments and strictly advice against sharing personal or bank related information. We also recommend you visit Security Advice for more information. If you suspect any fraud or malpractice, email us at [e-mail]

People Looking for Data Architect Jobs also searched