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.

LTIMINDTREE LIMITED Careers

LTIMINDTREE LIMITED Careers

Jobs in similar companies

Job Categories