Etl Specialist

Job Title:

Key Responsibilities

• Design, develop, and maintain logic for

  data controls

  to ensure data integrity from source to target, meeting data quality standards for FCRM purposes.
• Design and implement

  data pipelines and ETL processes

  using

  Python

  and

  SQL

  .
• Optimize database performance through tuning, indexing, and partitioning strategies.
• Collaborate with technology development and testing teams to ensure accurate development and testing of data transformation logic.
• Independently analyze

  Source-to-Target Mapping documents

  , data dictionaries for root cause analysis and business understanding.
• Perform

  data profiling

  and end-to-end root cause analysis for data issues; work with stakeholders to remediate issues as part of the

  DQ Exception Management Process

  .
• Develop detailed documentation of end-to-end data processes.
• Engage stakeholders and participate in triage meetings to resolve data quality issues.
• Define

  test scripts and cases

  for SIT, UAT, and perform testing.

Minimum Requirements

• Education:

  University degree in Technology/Engineering.

• Experience:

• 7–10 years in a financial institution (preferably global banks).
• 7–10 years in

  SQL development

  (query optimization, stored procedures, indexing).
• Strong hands-on experience in

  Python

  for data manipulation, scripting, and automation.
• Comfortable working across time zones (US & SG) and onsite at Wipro location.
• Understanding of

  Compliance domain

  concepts (AML, KYC, Customer Risk Rating).
• 5–7 years in

  data lifecycle, governance, quality, metadata, and issue resolution

  .
• 3+ years in

  system testing and data issue exception management

  .
• Experience with

  Informatica ETL Tool

  (mandatory).
• Project management experience is an added advantage.

Skills & Competencies

• Critical Thinking & Problem Solving
• Strong Communication & Articulation
• Adaptability & Collaboration
• Interpersonal Skills
• Decision Making