Data Analytics ETL Architect + ADF

• Requirements gathering and solution designing.
• Experience working in an Enterprise environment.
• Good Data Modeling skills.
• Performance tuning and Optimization.
• Strong experience with PL/SQL.
• Experience in extracting data from ERP source applications (Oracle Fusion or EBS, SAP, CRM) and RestAPI data sources.
• Experience with at least one Cloud Data Warehouse platform.
• Experience or Strong understanding of Fusion Analytics Warehouse is preferred.
• Extensive experience working with Oracle Data Integrator (ODI).

Responsibilities

• Design Data Integration (ETL) projects using Oracle Data Integrator (ODI).
• Translates basic business functions into conceptual, logical, and physical data models.
• Works with business users to translate business strategy into discrete requirements compatible with current technical architectures.
• Designing and developing data extraction, cleansing, transformation, and loading processes and workflows to load data.
• Communicate and promote adoption of practices & standards with ETL development teams.

Requirements

• Must have 8+ years of experience in Oracle DBMS, Oracle Data Integrator (ODI), PL/SQL, Data modelling, ETL Design & Architecture, Performance Tuning, etc.
• Experience extracting data from ERP source applications (Oracle Fusion, Oracle EBS, SAP, CRM) and REST API based data sources.
• Experience in Oracle FAW / FDI, Snowflake, Informatica / IICS, Azure Data Factory (ADF), Power BI, Python, etc will be an added advantage.

Education and Qualifications

Bachelors or Master's Degree in Engineering, or Computer Science, or Computer Applications