Summary
We are looking for a Software Engineer to be part of the Data Migration team - 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
- Bachelors Degree in Computer Science, Information Technology, or a related field.
- 38 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.
