Key Facts

Remote From:

India

Fixed term

Senior (5-10 years)

English

Hard Skills

Other Skills

•
Collaboration
•
Communication
•
Teamwork
•
Analytical Thinking
•
Problem Solving

Roles & Responsibilities

Expert-level knowledge of the Financial Services Logical Data Model (FSLDM).
Extensive experience with Teradata (Vantage) and utilities (BTEQ, FastLoad, MultiLoad).
Advanced proficiency in Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS).
Proven experience building or maintaining Data Lakehouse architectures (combining data lakes and data warehouses).

Requirements:

Lead the implementation and customization of Teradata FSLDM to meet Lakehouse program needs.
Design and maintain the Data Lakehouse layers (Bronze/Silver/Gold or Raw/Integrated/Access) to support large-scale financial data.
Architect and develop robust ETL/ELT pipelines using Informatica (PowerCenter/IICS) to migrate data from disparate sources into Teradata and the Lakehouse.
Ensure data governance, data lineage, quality checks, and metadata management within the FSLDM framework; collaborate with Business Analysts and Data Scientists.

Awign

Information Technology & Services

About Awign

Awign is India's largest on-demand work fulfilment platforms, helping enterprises run their business at scale through end-to-end management and outcome-based execution of core business functions. This is done through our mobile and distributed community of 1.3mn+ gig partners across 12,000+ pin codes in India. Our tech-driven solution allows enterprises to variabilize their fixed costs, optimize toplines and focus on business profitability. We work with enterprises to take up recurring business functions, such as auditing, due diligence, invigilation, proctoring, last-mile delivery, new business development, telecalling along with content & data operations. Our division for high-skill gig talent, Awign Expert helps enterprises hire high-skill talent on a contractual basis and manage the entire lifecycle of those professionals.We are on a mission to uplift lives of 100mn people in India by providing them a platform to leverage and grow their skills. Awign enables gig partners to expand their income potential beyond the bounds of time, location and skills. Gig partners can choose between multiple gig opportunities across varied skill sets according to their own time and location-based flexibility. One platform, infinite avenues. #AwignEkMaukeAnek

Company type: Scaleup

Industry: Information Technology & Services

Founded: 2018

Company size: 201 - 500

Website LinkedIn See all jobs →

Job description

Job Title: Lead Data Engineer / Architect (FSLDM & Data Lakehouse)

Experience: 10+ Years

Project: International Financial Data Lakehouse Program

Duration: 6 Months initially

Location: Remote

Role Objective

We are seeking a seasoned Data Professional to drive the design and implementation of a modern Data Lakehouse for a major financial services program. The ideal candidate will be an expert in the Teradata FSLDM framework and possess deep expertise in Informatica for complex ETL/ELT orchestration. You will be responsible for transforming raw financial data into a structured, high-performance Lakehouse architecture that supports both BI and advanced analytics.

Key Responsibilities

Data Modeling: Lead the implementation and customization of the Teradata FSLDM (Financial Services Logical Data Model) to ensure it meets the specific needs of the Lakehouse program.
Architecture Design: Design and maintain the Data Lakehouse layers (Bronze/Silver/Gold or Raw/Integrated/Access) to support massive scales of financial data.
ETL/ELT Development: Architect and develop robust data pipelines using Informatica (PowerCenter or IICS) to migrate data from disparate sources into Teradata and the Lakehouse environment.
Performance Tuning: Optimize Teradata SQL and Informatica mappings for high-volume data processing and complex financial calculations.
Data Governance: Ensure compliance with financial regulations by implementing data lineage, quality checks, and metadata management within the FSLDM framework.
Stakeholder Collaboration: Work closely with Business Analysts and Data Scientists to translate financial business requirements into scalable technical schemas.

Technical Requirements

Core Model: Expert-level knowledge of FSLDM (Financial Services Logical Data Model) is mandatory.
Primary Database: Extensive experience with Teradata (Vantage, Architecture, Utilities like BTEQ, FastLoad, MultiLoad).
Integration Tools: Advanced proficiency in Informatica (PowerCenter/Informatica Intelligent Cloud Services).
Lakehouse Experience: Proven experience in building or maintaining Data Lakehouse architectures (combining the flexibility of data lakes with the performance of data warehouses).
Domain Knowledge: Strong understanding of Banking/Financial Services domains (Risk, Finance, Regulatory Reporting, or Retail Banking).