FSLDM Data Mapper

Avensys is a reputed global IT professional services company headquartered in Singapore. Our service spectrum includes enterprise solution consulting, business intelligence, business process automation and managed services. Given our decade of success we have evolved to become one of the top trusted providers in Singapore and service a client base across banking and financial services, insurance, information technology, healthcare, retail and supply chain.

We are currently looking to hire
FSLDM Data Mapper
This is an exciting opportunity to expand your skill set, achieve job satisfaction and work-life balance. More details as below.

Notice Period: Immediate-15 days

Contract: Longterm Contract

Experience: Min 8+ Years

Job Description:

Data Analyst – Business & Data Mapping (Teradata FSLDM)

Role Summary

This role combines data analysis, business requirement gathering, and data mapping expertise for projects built on the Teradata Financial Services Logical Data Model (FSLDM). You will work across business stakeholders, data architects, and ETL teams to translate financial services requirements into accurate source-to-target mappings and analytics-ready datasets.

Key Responsibilities

Business Analysis & Stakeholder Engagement

• Collaborate with business teams to gather, analyse, and document requirements for reporting, analytics, and regulatory needs.
• Conduct workshops to understand banking/financial services processes and map them to FSLDM subject areas.
• Create functional specifications, process flows, and business glossaries.

Data Analysis & Profiling

• Perform data profiling to assess source data quality, completeness, and integrity.
• Identify data gaps and recommend remediation strategies.
• Analyse existing FSLDM structures to determine fitment for business requirements.

Data Mapping & Transformation Rules

• Develop Source-to-Target Mapping (STTM) documents aligning source systems (e.g., BANCs, LOS, CLOS, MUREX) with FSLDM entities and attributes.
• Define data transformation logic, lookup references, and business rules for ETL developers.
• Ensure mappings comply with data governance, regulatory, and naming standards.

FSLDM Model Understanding

• Leverage FSLDM's logical/physical model to align business needs with enterprise data architecture.
• Identify required extensions or customizations to FSLDM.
• Support integration with analytical layers like FSAS.

Testing & Validation

• Support SIT/UAT by validating data outputs against business rules and source data.
• Coordinate defect triage and resolution with development teams.

Governance & Documentation

• Maintain mapping inventories, data dictionaries, and lineage documentation.
• Follow governance standards for metadata, change control, and versioning.

Required Skills & Experience

Category

Details

Domain Expertise

5–10 years in data/business analysis within
banking or financial services
; exposure to regulatory reporting (Basel, BCBS 239).

FSLDM Knowledge

Understanding of Teradata FSLDM or other financial services data models.

Data Mapping Skills

Strong in creating STTMs, transformation rules, and mapping documentation.

Data Analysis

Proficient in SQL for data extraction, profiling, and validation (Teradata, Oracle, or similar).

Business Analysis

Experience in requirement gathering, stakeholder management, and functional documentation.

ETL Collaboration

Ability to work with developers using Informatica, DataStage, or Talend.

Tools

ERwin (or similar modeling tools), Excel, PowerPoint, Confluence, Jira.

Soft Skills

Strong communication, presentation, and analytical thinking skills.

Preferred Qualifications

• Teradata Vantage experience.
• Experience with metadata tools (IBM Information Governance Catalog or Informatica Enterprise Data Catalog (EDC) or erwin Data Intelligence (DI)).
• Exposure to data governance and quality frameworks.
• Knowledge of multiple source systems in banking (payments, trade finance, credit, GL).

WHAT'S ON OFFER:

You will be remunerated with an excellent base salary and entitled to attractive company benefits. Additionally, you will get the opportunity to enjoy a fun and collaborative work environment, alongside a strong career progression.

To submit your application, please apply online or email your UPDATED CV in Microsoft Word format to - Your interest will be treated with strict confidentiality.

CONSULTANT DETAILS:

Consultant Name : varra Chaitanya

Avensys Consulting Pte Ltd EA Licence 12C5759

Privacy Statement: Data collected will be used for recruitment purposes only. Personal data provided will be used strictly in accordance with the relevant data protection law and Avensys' privacy policy