Data Engineer Architect

Overview

10–12 Years

Location: Remote

Notice Period: Immediate Joiner or max 15days

Role Objective

We are seeking a seasoned and highly experienced Lead Data Engineer / Architect to drive the design and implementation of a modern Data Lakehouse for a large-scale international financial services program.

The ideal candidate must have deep expertise in the Financial Services Logical Data Model and strong hands-on experience with Informatica PowerCenter / Informatica Intelligent Cloud Services.

This role will be responsible for transforming raw financial data into a structured, high-performance Lakehouse architecture that supports enterprise BI, regulatory reporting, and advanced analytics.

Key Responsibilities

Data Modeling & Architecture

• Lead the implementation and customization of the Financial Services Logical Data Model to align with enterprise Lakehouse requirements.
• Design and maintain scalable Data Lakehouse layers (Bronze/Silver/Gold or Raw/Integrated/Access).
• Define enterprise-level data architecture standards for financial data platforms.
  
  

• Architect and develop robust data pipelines using Informatica PowerCenter and/or Informatica Intelligent Cloud Services.
• Design scalable data ingestion frameworks for structured and semi-structured data.
• Migrate and integrate data from multiple source systems into Teradata Vantage and Lakehouse environments.
  
  

• Optimize complex Teradata SQL queries and utilities (BTEQ, FastLoad, MultiLoad).
• Tune Informatica workflows and mappings for high-volume financial data processing.
• Ensure efficient handling of complex financial calculations and reporting workloads.
  
  

• Implement strong data governance practices including:
• Data lineage
• Data quality validation
• Metadata management
• Ensure compliance with financial and regulatory reporting standards.
• Maintain consistency with FSLDM architectural guidelines.
  

• Collaborate with Business Analysts, Data Scientists, and Finance stakeholders.
• Translate complex financial requirements into scalable technical models.
• Provide technical leadership and architectural guidance to engineering teams.
  
  

• Expert-level knowledge of Financial Services Logical Data Model.
• Extensive hands-on experience with Teradata Vantage (Architecture, Utilities such as BTEQ, FastLoad, MultiLoad).
• Advanced proficiency in Informatica PowerCenter and/or Informatica Intelligent Cloud Services.
• Proven experience in designing and implementing Data Lakehouse architectures.
  
  

• Strong understanding of Banking and Financial Services domains, including:
• Risk & Finance
• Regulatory Reporting
• Retail Banking
• Financial Data Governance
  

• Experience working on large-scale international banking programs.
• Exposure to modern cloud-based data platforms.
• Strong architectural documentation and leadership capabilities.
• Ability to mentor and guide offshore/onshore data engineering teams.