ETL Specialist

Data Engineer(ETL ODI) Exp: 5+yrs Location: Remote Contract: 3 month extendable We are seeking a skilled and experienced Data Integration Specialist with over 5 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: Link: Notice Period: Last Working Day (If serving notice period): LWD Pic from portal(Please attach): Current CTC (Monthly): Expected CTC (Monthly): Passport size pic (Please attach): Updated cv (Please attach):