VI
Oracle Data Engineer - ODI and PL/SQL
VARITE INDIA PRIVATE LIMITED
- 🇮🇳 India
- On-site
- 1 day ago
- AI
- Machine Learning
- ETL
- ELT
- Oracle
- PL/SQL
- Oracle Database
1 day ago
About The Client:
A global IT services and consulting company, multinational information technology (IT), headquartered in Tokyo, Japan. The Client offers a wide array of IT services, including application development, infrastructure management, and business process outsourcing. Their consulting services span business and technology, while their digital solutions focus on transformation and user experience design. It excels in data and intelligence services, emphasizing analytics, AI, and machine learning. Additionally, their cybersecurity, cloud, and application services round out a comprehensive portfolio designed to meet the diverse needs of businesses worldwide.
Essential Job Functions:
- Design, develop, and maintain ETL/ELT processes using Oracle Data Integrator (ODI).
- Develop, enhance, and optimize complex PL/SQL packages, procedures, functions, triggers, and scripts.
- Build and support data-integration workflows between multiple source and target systems.
- Perform data extraction, transformation, and loading activities for enterprise data warehouse environments.
- Analyze business and technical requirements and translate them into reliable data solutions.
- Monitor and troubleshoot data pipelines, ETL jobs, and database performance issues.
- Implement performance-tuning strategies for Oracle databases and PL/SQL programs.
- Ensure data quality, consistency, integrity, and security across data platforms.
- Collaborate with data architects, business analysts, reporting teams, and application developers.
- Create and maintain technical design documents, ETL specifications, and operational runbooks.
- Support production environments, incident resolution, and root-cause analysis.
- Experience (Relevant) in Years: 4+
- Oracle PL SQL
- ODI
- 6 am to 3 pm
- 2 pm to 11 pm
- Including weekends on a rotation basis.
- 8+ years of data engineering or related Oracle data-integration experience.
- Strong hands-on experience with Oracle Data Integrator (ODI).
- Advanced experience developing and optimizing PL/SQL packages, procedures, functions, triggers, and scripts.
- Experience designing and supporting ETL/ELT processes and enterprise data warehouse integrations.
- Strong Oracle database performance-tuning and troubleshooting skills.
- Experience with data quality, data integrity, data security, and data-reconciliation practices.
- Experience supporting production data pipelines and participating in incident and root-cause analysis.
- Ability to translate business and technical requirements into maintainable data solutions.
- N/A
- Bachelor’s degree in Computer Science or equivalent work experience (template default; validate)
- Experience collaborating with data architects, reporting teams, and application development teams.
- Experience creating ETL specifications, technical designs, and operational runbooks.
- Experience supporting enterprise data warehouse environments.
Unlock Rewards: Refer Candidates and Earn.
If you're not available or interested in this opportunity, please pass this along to anyone in your network who might be a good fit and interested in our open positions. VARITE offers a Candidate Referral program, where you'll receive a one-time referral bonus based on the following scale if the referred candidate completes a three-month assignment with VARITE.
Experience Level Bonus Referral:
| 0-2 years | INR 5,000 |
| 2-6 years | INR 7,500 |
| 6+ years | INR 10,000 |
About VARITE: VARITE is a global staffing and IT consulting company providing technical consulting and team augmentation services to Fortune 500 Companies in USA, UK, CANADA and INDIA. VARITE is currently a primary and direct vendor to the leading corporations in the verticals of Networking, Cloud Infrastructure, Hardware and Software, Digital Marketing and Media Solutions, Clinical Diagnostics, Utilities, Gaming and Entertainment, and Financial Services.
Equal Opportunity Employer:
VARITE is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, marital status, veteran status, or disability status.
Oracle Data Engineer - ODI and PL/SQL · VARITE INDIA PRIVATE LIMITED