Data Migration Analyst / Data Engineer - Banking

We are seeking for a contract resources (6 month duration) to support a strategic data migration and reporting transformation initiative. The objective of the project is to migrate existing tables, datasets, and reports currently sourced from a legacy datamart and manual data sources to newly established enterprise data martsThe successful candidates will be responsible for analysing existing data processing and reporting logic, mapping legacy and manual data sources to the new data marts, redeveloping scripts and workflows, validating migrated outputs, and producing comprehensive data documentation. This role requires strong SAS, SQL and Python development skills, data analysis capabilities, and experience working with Hadoop-based data platformsJob responsibilities:Data Analysis & DiscoveryAnalyse existing tables, reports, datasets, and data processing workflows currently sourced from legacy data marts and manual processesReview and understand existing scripts, transformation logic, data dependencies, and business rulesIdentify data sources, data lineage, reporting requirements, and current-state processesEngage business to understand existing reporting methodologies and requirementsSource Mapping & MigrationPerform source-to-target mapping between legacy data marts/manual sources and new data martsAnalyse and document field mappings, transformation rules, calculations, and business logicIdentify gaps, inconsistencies, and opportunities for process optimisation during migrationDevelop migration specifications and ensure alignment with business requirementsDevelopment & AutomationDevelop, enhance, and maintain SQL scripts using Hive and Impala engines via HueDevelop scripts for data extraction, transformation, validation, and reporting processesRebuild existing tables, reporting datasets, and data preparation processes using the new data marts as source systemsConfigure and support workflow scheduling and automation using OozieEnsure developed solutions are scalable, efficient, and maintainableData Validation & TestingPerform reconciliation and validation between outputs generated from current sources and outputs generated from the new data martsValidate data accuracy, completeness, consistency, and timelinessInvestigate and resolve data discrepancies and defects identified during testingSupport User Acceptance Testing (UAT) and business validation activitiesEnsure migrated reports and datasets meet defined business and technical requirementsDocumentation & GovernanceProduce and maintain project artefacts, including:Source-to-target mapping documentsData lineage documentationBusiness and technical logic documentationMetadata documentationData dictionariesReconciliation and validation reportsTechnical specifications and operational runbooksEnsure documentation complies with enterprise data governance and documentation standardsJob requirement: Strong SQL, SAS or Python scripting and data manipulation skills. Hands-on experience with: Hue, Hive, Impala, Oozie Experience in data warehousing, ETL development, data migration, or data engineering projects. Experience working with large and complex datasets. Strong understanding of relational databases and data modelling concepts. Qualifications:Degree in Computer Science, Information Systems, Engineering, Mathematics, Statistics, or a related disciplineMinimum 3 years of relevant experience in data engineering, ETL development, data warehousing, reporting, or data migration projectsData Management Skills:Source-to-target mappingData lineage analysis and documentationMetadata managementData dictionary creation and maintenanceData quality assessment and reconciliationTechnical and functional documentationSoft Skills:Strong analytical and problem-solving abilitiesAbility to understand and reverse-engineer legacy code and reporting processesGood stakeholder engagement and communication skillsAbility to work independently and manage multiple deliverables within tight timelinesPreferred Experience:Experience in banking, financial services, or large enterprise environmentsExperience working with Hadoop ecosystem technologiesExposure to reporting transformation, data modernisation, or data migration programmesFamiliarity with enterprise data governance and metadata management practices