Senior Data Migration & ETL Analyst (Banking)

Accenture PLC; Kuala Lumpur; On-site; MYR 120,000 - 180,000; Full time

Job summary

Accenture PLC is seeking an experienced Data Engineer to develop, test, and maintain ETL pipelines across the assigned data domain in a banking context. You will implement transformation logic, conduct unit/integration tests, and document artefacts to ensure accuracy, performance, and auditability throughout migration cycles.

The role requires strong SQL, data profiling, and hands-on experience with Informatica/DataStage/PySpark and Azure Data Factory, with mentoring responsibilities for junior

Qualifications

• Minimum 3 years of experience in data engineering, ETL development, or data migration delivery.
• Bachelor's degree in Computer Science, IT, or related engineering discipline.
• Banking or financial services experience is advantageous.
• Ability to deliver technical workstreams independently within defined standards and timelines.
• Early experience reviewing or guiding junior team members is a plus.

Responsibilities

• Develop, test, and maintain ETL pipelines for the assigned data domain or country, ensuring accuracy, performance, and auditability in line with approved functional specifications.
• Implement data transformation and cleansing logic, adhering to defined migration standards and technical guidelines set by the Sub Lead.
• Conduct unit and integration testing of migration pipelines, document defects, and support resolution in a timely manner.
• Maintain technical artefacts including ETL specifications, data dictionaries, and technical runbooks for the assigned scope.
• Execute source system data profiling to identify and document anomalies, nulls, duplicates, and referential integrity issues.
• Implement data quality checks and reconciliation controls within ETL pipelines, investigating and resolving reconciliation breaks identified during dry runs and UAT.
• Participate in performance testing of migration pipelines, supporting optimisation of queries and transformation logic for throughput.
• Contribute to the technical cutover runbook and execute assigned tasks during dry-run and live cutover windows.
• Support rollback procedures and post-migration technical validation for the assigned domain.
• Review work produced by Analysts, providing constructive feedback and guidance to support their development.
• Escalate technical risks and blockers to the Sub Lead promptly, with clear documentation of the issue and impact.

Skills

ETL Development

SQL

Data profiling

Data migration

Performance testing

Mentoring juniors

Education

Bachelor's degree in Computer Science or related

Tools

Informatica

DataStage

Python/PySpark

Azure Data Factory

Job description

Accenture PLC is seeking an experienced Data Engineer to develop, test, and maintain ETL pipelines across the assigned data domain in a banking context. You will implement transformation logic, conduct unit/integration tests, and document artefacts to ensure accuracy, performance, and auditability throughout migration cycles.

The role requires strong SQL, data profiling, and hands-on experience with Informatica/DataStage/PySpark and Azure Data Factory, with mentoring responsibilities for junior