Data Migration Engineer
Other
Hybrid
Full-Time
We are looking for a Data Migration Engineer / Data Engineer who will play a key role in the end-to-end design, development, and execution of data migration processes between legacy and target banking systems. You will work with modern data engineering tools, build robust migration pipelines, ensure data quality, and collaborate closely with business and technology stakeholders.
What You Will Do
- Design and build data migration pipelines using Python, SQL, dbt, and ETL/ELT frameworks.
- Develop and optimize transformations using SQL, PL/SQL, Python scripts, and dbt models.
- Extract, transform, and load data from systems (Oracle, SQL Server, APIs) into PostgreSQL and cloud environments.
- Implement data validation, cleansing, and reconciliation with automated checks and reporting.
- Analyze and profile legacy data to identify gaps, anomalies, and data quality issues.
- Optimize pipeline and SQL performance through partitioning, indexing, parallelization, and tuning.
- Collaborate with architects, engineers, and analysts to define mapping rules, transformation logic, and integration requirements.
- Support UAT, trial runs, production migration, and post-migration audits.
- Maintain documentation for mappings, pipelines, and migration procedures.
- Communicate migration progress, risks, and blockers to project stakeholders.
What We're Looking For
- 3–5 years of hands-on experience in data migration, data engineering, or ETL/ELT development.
- Strong proficiency in SQL (complex queries, performance tuning) and at least one scripting language — Python preferred.
- Experience with ETL/ELT tools (dbt, Airflow, Talend, SSIS, Informatica, Apache NiFi) and solid understanding of data pipeline design.
- Practical experience with Oracle, SQL Server, PostgreSQL, and working with large-scale relational datasets.
- Strong knowledge of data profiling, cleansing, validation, and reconciliation techniques.
- Experience working with cloud platforms (AWS, Azure, or GCP) and cloud-native storage/compute services.
- Familiarity with data governance, GDPR, and data protection best practices.
- Strong analytical and troubleshooting skills with the ability to investigate complex data issues.
- Effective communication skills and ability to work collaboratively with cross-functional technical and business teams.
- Experience with Agile/Scrum software development processes.
