Role Overview: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.

Key Responsibilities:Support and monitor the implementation of project governance, standards, and best practices across portfolios.Track and report on program/project progress, milestones, risks, and deliverables using PMO dashboards and KPIs.Coordinate across departments, consultants, and stakeholders to ensure project alignment and timely delivery.Maintain and improve PMO templates, documentation standards, and knowledge repositories.Conduct quality assurance checks, project health checks, and audits to ensure compliance with PMO methodology.Prepare executive reports and presentations for senior stakeholders, including ministries or regulatory bodies.Support capacity building and training sessions on project management tools and methodologies.Collaborate with strategic partners and vendors to ensure project tracking and governance is in place. Required Qualifications & Skills:Bachelor’s degree in Project Management, Business Administration, Engineering, or a related field.2+ years of experience in PMO functions, preferably within the Middle East region.Excellent communication skills (Arabic is a plus, English is a must).Strong stakeholder management and cross-functional coordination abilities.