Data Engineer (6 months, Bank) ESY
Summary
6-month Data Engineer contract at a bank focusing on data migration from legacy data marts—analyzing existing workflows, performing source-to-target mapping, developing SQL/Hive/Impala scripts, validating migrated data, and producing thorough documentation.
Data Analysis & Discovery
. Analyse existing tables, reports, datasets and data processing workflows from legacy data marts and manual processes.
. Understand existing scripts, transformation logic, business rules and reporting methodologies.
. Identify data lineage, dependencies and reporting requirements.
. Work closely with business users to understand current reporting processes and migration requirements.
Data Migration & Source Mapping
. Perform source to target mapping between legacy systems and new enterprise data marts.
. Document field mappings, transformation logic and business rules.
. Identify data gaps and recommend improvements where appropriate.
. Develop migration specifications aligned with business requirements.
Development
. Develop and enhance SQL scripts for data extraction, transformation and reporting.
. Work with Hive and Impala to support data migration activities.
. Rebuild existing reporting datasets using the new enterprise data marts.
. Support workflow automation where applicable.
Testing & Validation
. Perform reconciliation between legacy and migrated datasets.
. Validate data accuracy, completeness and consistency.
. Investigate and resolve data discrepancies.
. Support User Acceptance Testing (UAT) and business validation.
Documentation
Prepare and maintain project documentation including:
. Source to target mapping
. Data lineage
. Technical specifications
. Data dictionaries
. Metadata documentation
. Validation and reconciliation reports
. Operational runbooks
Requirements
Experience
. Degree in Computer Science, Information Systems, Engineering or a related discipline.
. 3 to 5 years of relevant experience in data engineering, data migration, ETL development, reporting or data management.
. Experience within banking or financial services will be an advantage.
Interested candidates, please email your resume to (HIDDEN TEXT)
Anna See Sing Yee
CEI Reg R25157535
Recruit Express Pte Ltd
EA License No: 99C4599
We regret that only shortlisted candidates will be contacted