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.
