Leads data migration initiatives from legacy systems to modern architectures. Designs ETL strategies using SSIS and Oracle ODI, develops PL/SQL scripts, validates data accuracy, tunes Java applications and database queries, troubleshoots migration issues, collaborates on data mapping, and documents technical processes and best practices.
Data Migration Engineers
Summary
We are seeking an experienced Data Migration Engineer to lead critical data transformation initiatives within our IT Services sector. This pivotal role involves orchestrating the seamless transfer of complex datasets from legacy systems to modern architectures, ensuring data integrity, accuracy, and consistency throughout the migration lifecycle. The successful candidate will play a fundamental part in optimizing system performance and supporting the organization's strategic digital transformation goals by managing high-volume data operations with precision and efficiency.
Responsibilities
- Design and execute comprehensive data migration strategies using industry-standard tools such as SSIS and Oracle ODI.
- Develop and maintain robust PL/SQL scripts within Oracle environments to handle complex data extraction, transformation, and loading (ETL) processes.
- Conduct rigorous data validation procedures to verify the accuracy and completeness of migrated information across different platforms.
- Optimize application and database performance through advanced tuning techniques, specifically focusing on Java-based components and database queries.
- Collaborate with cross-functional teams to analyze source data structures and define mapping requirements for target systems.
- Troubleshoot and resolve technical issues related to data flow, connectivity, and system performance during migration phases.
- Document migration processes, technical specifications, and best practices to ensure knowledge transfer and operational continuity.
Requirements
Requirements:
- Minimum of 5 years of professional experience in data engineering, ETL development, or related technical fields.
- Proficiency in Java programming for building scalable data processing applications.
- Deep expertise in performance tuning methodologies for databases and enterprise applications.
- Strong command of Oracle PL/SQL for writing complex stored procedures and functions.
- Hands-on experience with Microsoft SQL Server Integration Services (SSIS) for data integration tasks.
- Practical knowledge of Oracle Data Integrator (ODI) for managing large-scale data migration projects.
- Proven track record in performing thorough data validation and ensuring data quality standards.
- Familiarity with IT Services industry standards and best practices for data management.
Similar Jobs
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Manage end-to-end transaction banking and retail payments projects within the BFSI sector, including compliance and regulatory initiatives. Lead Agile delivery, ISO 20022 payments projects, stakeholder communications across multiple geographies, release cycles, delivery management, RAID tracking, escalations, and senior stakeholder engagement. Mobile release management experience is preferred.
Top Skills:
AgileConfluenceIso 20022JIRA
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Business Analyst responsible for payments and digital journey initiatives within retail and global banking. The role involves requirements elicitation, backlog and Agile delivery management, customer channel analysis, MVP prioritization, epics and user stories, stakeholder alignment, market and As-Is analysis, solution walkthroughs, implementation support, and coordination across business, technology, operations, risk, legal, compliance, and UX teams.
Top Skills:
ConfluenceJIRA
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Business Analyst supporting payments and digital banking journeys for global retail banking clients. Responsibilities include requirements elicitation, backlog management, Agile delivery, customer channel analysis, MVP prioritization, Epic and user story creation, stakeholder coordination, As-Is analysis, market research, solution walkthroughs, and implementation support across business, technology, operations, risk, legal, compliance, and UX teams.
Top Skills:
Browser Front-End SolutionsConfluenceJIRAMobile Banking Applications
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
