Teradata Consultant

Job Description

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).
SQL Mastery: Expert in writing and optimizing complex analytical SQL queries

Desired Candidate Profile

Any Nationality

Bachelor of Science

Any

8 year in teradata