Job Description

Summary

We are looking for a Software Engineer to lead and execute the transition of data from legacy systems to modern platforms, ensuring accuracy, integrity, and minimal disruption to business operations. The ideal candidate will have hands-on expertise in

ETL processes, database management, data validation, and troubleshooting complex migration issues.

Key Responsibilities

Planning & Analysis

Review existing data sources, structures, and dependencies to identify potential challenges. Gather business requirements and define the scope of migration. Work closely with business and IT teams to establish migration plans, including cutover and rollback strategies.

Data Extraction, Transformation & Loading (ETL)

Design and implement scripts to extract, transform, and load data into target systems. Cleanse, map, and standardize data to meet system requirements. Execute both incremental and full migrations while minimizing downtime. Safeguard data consistency, integrity, and accuracy during transfers.

Testing & Validation

Conduct trial runs and verify data accuracy and completeness post-migration. Diagnose and resolve migration errors. Implement reconciliation processes, error-handling protocols, and rollback procedures.

Performance & Optimization

Enhance migration processes for handling large datasets efficiently. Monitor system performance and resolve bottlenecks during data transfers. Ensure compliance with organizational security standards and data protection policies

Requirements

Bachelor's Degree or Diploma in Computer Science, Information Technology, or a related field. 3-8 years of experience working on large-scale systems and applications. Strong programming background with

Java, Python, JavaScript, .NET, or C#

, including solid understanding of object-oriented principles, concurrency, and design patterns. Proficient in

SQL

and relational databases such as

Oracle, MySQL, SQL Server, and PostgreSQL

. Hands-on experience with

ETL processes, data migration, validation, reconciliation, and quality assurance

. Proficiency in developing and consuming

web services and APIs

(JavaScript, .NET Core, XML, HTML). Skilled in

application integration, monitoring, and automated testing.

Experience using

software development tools

(Git, Jenkins, JIRA). Familiarity with

RESTful APIs

and connecting frontend applications to backend services. Strong knowledge of

SDLC methodologies

and full project life cycle. * Ability to analyze requirements, prepare technical specifications, and develop test scenarios.