Lead ETL ODI

Lead ETL ODI

Exp : 9+yrs

Location : Remote

Contract : 6 month extendable

Immediate Joiners only

We are seeking a skilled and experienced Data Integration Specialist with over 9 years of experience in designing and developing data solutions using Oracle Data Integrator (ODI). The ideal candidate will have strong expertise in data modeling, ETL / ELT processes, and SQL, along with exposure to Python scripting for API-based data ingestion.

Key Responsibilities :

• Design, develop, and maintain functions and stored procedures using Oracle Data Integrator (ODI).
• Create and document data warehouse schemas, including fact and dimension tables, based on business requirements.
• Develop and execute SQL scripts for table creation and collaborate with Database Administrators (DBAs) for deployment.
• Analyze various data sources to identify relationships and align them with Business Requirements Documentation (BRD).
• Design and implement Extract, Load, Transform (ELT) processes to load data from source systems into staging and target environments.
• Validate and profile data using Structured Query Language (SQL) and other analytical tools to ensure data accuracy and completeness.
• Apply best practices in data governance, including query optimization, metadata management, and data quality monitoring.
• Demonstrate strong data modeling skills to support scalable and efficient data architecture.
• Utilize Python to automate data collection from APIs, enhancing integration workflows and enabling real-time data ingestion.
• Investigate and resolve data quality issues through detailed analysis and root cause identification.
• Communicate effectively with stakeholders through strong written, verbal, and analytical skills.
• Exhibit excellent problem-solving and research capabilities in a fast-paced, data-driven environment.

If interested, please mail me your details at komal@viennaconsultancy.com

Total Experience :

Relevant Experience in ETL ODI :

Highest Education :

Current Company :

Current Designation :

Current Location :

Pin Code :

Offer in hand :

LinkedIn Link :

Notice Period :

Last Working Day (If serving notice period) :

Current CTC (Monthly) :

Expected CTC (Monthly) :

Passport size pic (Please attach) :

Updated cv (Please attach) :

LWD / Relieving letter(Please attach) :