Oracle PL/SQL Data Migration Developer
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
Tata Consultancy Services (MEA) seeks an Oracle PL/SQL Data Migration Developer in Dubai to design and optimize PL/SQL packages for large-scale data migration projects. The role involves data mapping, ETL development, reconciliation, and performance tuning.
Key Skills for This Role
Responsibilities
- Design, develop, and optimize Oracle PL/SQL packages, procedures, functions, and scripts for large scale data migration projects
- Analyze source and target data models, perform data mapping, transformation, validation, and reconciliation
- Develop ETL and migration workflows to extract, cleanse, transform, and load data while ensuring data integrity and quality, preferably in Snaplogic
- Create automated validation, reconciliation, and audit reports to verify migration accuracy
- Optimize SQL/PLSQL performance for high volume data processing and migration activities
- Support migration testing, mock runs, production cutovers, and post migration validation
- Collaborate with business, application, and technical teams to resolve data issues and ensure successful migration delivery
- Develop advanced PL/SQL packages utilizing Collections, Bulk Collect, FORALL, Dynamic SQL, and Ref Cursors for high performance data processing
- Design reusable PL/SQL frameworks for configurable data validation, transformation, error handling, and audit logging
- Implement parallel processing, restartable batch jobs, and exception management mechanisms to support large scale migration workloads
- Develop metadata driven migration utilities and generic PL/SQL components to minimize code duplication and improve maintainability
- Perform code reviews, establish PL/SQL development standards, and mentor junior developers on best practices and performance optimization techniques
Requirements
- Strong experience in Oracle SQL and PL/SQL development
- Expertise in advanced PL/SQL concepts including Packages, Collections, Bulk Processing, Dynamic SQL, Ref Cursors, and Performance Tuning
- Proven experience in data migration projects involving source to target mapping, data validation, and reconciliation
- Strong knowledge of reconciliation techniques including record level, aggregate level, and business rule based validation
- Experience with Oracle Data Pump, SQL*Loader, Oracle Scheduler, and database performance tuning
- Strong analytical, troubleshooting, and problem solving skills
- Experience working in Agile project environments is preferred
- Strong experience in Snaplogic pipeline development
Full Job Posting
Job Title & Company
- Oracle PL/SQL Data Migration Developer at TCS (MEA) in Dubai, United Arab Emirates
About Us
- Tata Consultancy Services (TCS) is an IT services, consulting and business solutions organization partnering with many of the world’s largest businesses for over 50 years.
- TCS offers a consulting led, cognitive powered, integrated portfolio of business, technology and engineering services and solutions delivered through its Location Independent Agile™ delivery model.
- A part of the Tata group, TCS has over 616,171 consultants with 157 nationalities in 53 countries.
Job Description
- Design, develop, and optimize Oracle PL/SQL packages, procedures, functions, and scripts for large scale data migration projects.
- Analyze source and target data models, perform data mapping, transformation, validation, and reconciliation.
- Develop ETL and migration workflows to extract, cleanse, transform, and load data while ensuring data integrity and quality, preferably in Snaplogic.
- Create automated validation, reconciliation, and audit reports to verify migration accuracy.
- Optimize SQL/PLSQL performance for high volume data processing and migration activities.
- Support migration testing, mock runs, production cutovers, and post migration validation.
- Collaborate with business, application, and technical teams to resolve data issues and ensure successful migration delivery.
- Develop advanced PL/SQL packages utilizing Collections, Bulk Collect, FORALL, Dynamic SQL, and Ref Cursors for high performance data processing.
- Design reusable PL/SQL frameworks for configurable data validation, transformation, error handling, and audit logging.
- Implement parallel processing, restartable batch jobs, and exception management mechanisms to support large scale migration workloads.
- Develop metadata driven migration utilities and generic PL/SQL components to minimize code duplication and improve maintainability.
- Perform code reviews, establish PL/SQL development standards, and mentor junior developers on best practices and performance optimization techniques.
Required Skills & Experience
- Strong experience in Oracle SQL and PL/SQL development.
- Expertise in advanced PL/SQL concepts including Packages, Collections, Bulk Processing, Dynamic SQL, Ref Cursors, and Performance Tuning.
- Proven experience in data migration projects involving source to target mapping, data validation, and reconciliation.
- Strong knowledge of reconciliation techniques including record level, aggregate level, and business rule based validation.
- Experience with Oracle Data Pump, SQL*Loader, Oracle Scheduler, and database performance tuning.
- Strong analytical, troubleshooting, and problem solving skills.
- Experience working in Agile project environments is preferred.
- Strong experience in Snaplogic pipeline development.
Additional Information
- Application Deadline: 15 July 2026
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Tata Consultancy Services
Senior Infrastructure Analyst
Calgary, CAN
Tata Consultancy Services is seeking a Senior Infrastructure Analyst to drive vulnerability remediation, improve patch compliance, and optimize monitoring and observability platforms. The role requires expertise in SCCM,
Kafka Architect / Streaming Data Architect
Jeddah, KSA
Tata Consultancy Services is seeking a Kafka Architect / Streaming Data Architect for a full-time role in Jeddah, KSA. The role involves designing enterprise-scale Kafka architecture for a Bank Lakehouse, implementing ev
Enterprise / Data Architect
Jeddah, KSA
Tata Consultancy Services is seeking an Enterprise/Data Architect for a role in Jeddah, KSA. The position involves owning end-to-end Data Lakehouse architecture, ensuring alignment with Medallion Architecture, and govern
AWS Technical Project Manager
Toronto, CAN
Tata Consultancy Services is seeking an AWS Technical Project Manager to work directly with the engineering team supporting Data Products, Data Fabric, Data Portal, metadata, and AI enablement. The role requires strong J
Data Analyst – Risk & Business Analytics
Montreal, CAN
TCS is looking for a Data Analyst to perform fast, accurate, and independent data analysis supporting business and risk management decisions. You will work with large datasets, develop dashboards, and deliver actionable
Tax compliance
Jeddah, KSA
Tata Consultancy Services (TCS) in Jeddah is hiring a Tax Compliance professional to ensure compliance with tax laws, prepare returns, manage VAT and corporate tax obligations, and liaise with tax authorities. The role r
Business Analyst
Mississauga, CAN
Tata Consultancy Services seeks a Payments Business Analyst with deep domain expertise in payments processing, clearing & settlement, and digital payments. The role requires strong experience in payments and knowledge of
Teradata Developer - Application Support
Jeddah, KSA
Tata Consultancy Services is seeking a skilled Teradata Developer & Data Lakehouse Application Support Engineer for a full-time role in Jeddah, Saudi Arabia. The role involves developing and optimizing Teradata SQL scrip
Senior Infrastructure Analyst
Calgary, CAN
Kafka Architect / Streaming Data Architect
Jeddah, KSA
Enterprise / Data Architect
Jeddah, KSA
AWS Technical Project Manager
Toronto, CAN
Data Analyst – Risk & Business Analytics
Montreal, CAN
Tax compliance
Jeddah, KSA
Business Analyst
Mississauga, CAN
Teradata Developer - Application Support
Jeddah, KSA