Data Engineer/Data Migration Analyst

Job Summary We 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-set Bachelor'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-set Experience 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. Responsibilities Analyze 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 governance Should you be interested in this career opportunity, please send in your updated resume to (HIDDEN TEXT) 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