Summary:
The candidate is expected to manage and execute the migration of data from legacy systems to new platforms, ensuring accuracy, integrity, and minimal disruptions to business operations.
He/she should have hands-on experience in ETL processes, database management, and data quality validation, along with strong problem-solving skills to troubleshoot complex data issues.
Responsibilities:
Planning and analysis
Assess existing data sources, data structures, and dependencies
Understand business requirements and migration scope
Collaborate with business and IT teams to plan migration timelines and strategies (e.g., cutover plan, rollback plan)
Data extraction, transformation, and loading
Design, develop, and execute data migration scripts
Map, transform, and cleanse data to meet the target system’s requirements
Perform incremental and full data migrations with minimal downtime
Ensure data integrity, consistency and accuracy
Testing and validation
Conduct trial migrations and validate data accuracy and completeness
Investigate and fix any data issues
Implement error handling, rollback plans, and data reconciliation processes
Performance and optimization
Optimize migration processes for performance and large data volumes
Monitor data transfer performance and resolve bottlenecks
Ensure the migration process adheres to data security and compliance policies.
Requirements:
Possess a degree in Computer Science/Information Technology or related fields.
Minimum 3 years of experience in developing and supporting large-scale systems and applications, with strong object-oriented and core programming skills (e.g., Java, Python, JavaScript, .NET, C#, etc.)
Possess a good understanding of object-oriented concepts, design patterns, concurrency, and software techniques.
Proficient in Web services, API technologies, and concepts (e.g., JavaScript, .NET Core, XML, HTML, etc.).
Experience in application integration, monitoring, and control with exposure to automated tests.
Proven experience in data migration or ETL engineering.
Strong knowledge of SQL and relational databases (Oracle, MySQL, SQL Server, PostgreSQL).
Experience with data validation, reconciliation, and quality assurance.
Proficient in consuming data from a variety of sources and connecting frontend applications to backend services.
Good at analyzing requirements, creating technical specifications, and using test cases and scenarios.
Experience with software development tools (e.g., Git, Jenkins, JIRA)
Good understanding of the full System Development Life Cycle.
Ensure compliance with IT security standards, policies, and procedures.
Strong problem-solving, analytical, written, and communication skills.
Ability to work collaboratively in cross-functional teams under tight deadlines
#J-18808-Ljbffr