Data Engineer/Data Migration Analyst (JD#11236)

Job SummaryWe are seeking a detail-oriented and analytical Data Engineer / Data Migration Analyst to support enterprise data migration and reporting transformation initiatives, in a renowned bank. The successful candidate will analyze legacy data assets, develop and optimize data processing solutions, perform source-to-target mapping, and ensure the successful migration of reporting datasets to modern data platforms.Mandatory Skill-setBachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, Statistics, or a related discipline;Must have minimum 3 years' experience in Data Engineering, ETL Development, Data Warehousing, Reporting, Data Migration, or a related field;Strong SQL development and data manipulation skills;Proficiency in SAS and/or Python scripting;Hands-on experience with Hue, Hive, Impala, Oozie;Experience in data warehousing, ETL development, data engineering, or data migration projects;Experience working with large and complex datasets;Strong understanding of relational databases, SQL optimization, and data modelling concepts.Desired Skill-setExperience working with Hadoop ecosystem technologies;Exposure to enterprise reporting transformation, data modernization, or migration programs;Familiarity with enterprise data governance, metadata management, and data quality frameworks.ResponsibilitiesAnalyze existing tables, reports, datasets, and data processing workflows sourced from legacy data marts and manual processes;Review and understand existing SQL scripts, transformation logic, business rules, and data dependencies;Identify source systems, data lineage, reporting requirements, and current-state data processes;Collaborate with business users to understand reporting methodologies and translate business requirements into technical solutions;Perform source-to-target mapping between legacy data marts, manual data sources, and new enterprise data marts;Document field mappings, transformation logic, calculations, and business rules;Develop, enhance, and maintain SQL scripts using Hive and Impala through the Hue environment;Build data extraction, transformation, validation, and reporting processes;Rebuild existing reporting datasets, tables, and data preparation workflows using new enterprise data marts;Perform reconciliation between legacy reporting outputs and outputs generated from the new data platform;Validate data accuracy, completeness, consistency, and timeliness;Involved in documentation and data governanceShould you be interested in this career opportunity, please send in your updated resume to [email protected] at the earliest.When you apply, you voluntarily consent to the disclosure, collection and use of your personal data for employment/recruitment and related purposes in accordance with the SCIENTE Group Privacy Policy, a copy of which is published at SCIENTE’s website (https://www.sciente.com/privacy-policy).Confidentiality is assured, and only shortlisted candidates will be notified for interviews.EA Licence No. 07C5639