Oracle ETL Developer
Posted Updated
Description
- We are looking for an experienced Oracle ETL professional who can assess and analyse the existing Oracle ETL architecture, understand data workflows, and document the underlying logic, dependencies, and business processes.
- EXP- 4 years of experience
- Key Responsibilities:
- Understand and analyse existing Oracle ETL architecture and workflows.
- Review existing ETL jobs, scripts, and transformation logic.
- Identify and explain database tables used across different ETL processes.
- Analyse Oracle PL/SQL packages, stored procedures, functions, and dependencies.
- Understand and map end-to-end data flows, transformations, and business logic.
- Identify dependencies between ETL processes, database objects, and workflows.
- Document existing architecture, data mappings, and process-level logic.
- Provide technical insights and recommendations based on the assessment.
- Mandatory Technical Skills:
- Strong hands-on experience with Oracle Database and Oracle ETL.
- Good knowledge of SQL and PL/SQL.
- Experience analysing Oracle packages, stored procedures, functions, and triggers.
- Understanding of ETL workflows, data extraction, transformation, and loading.
- Experience working with relational database tables, views, and dependencies.
- Ability to analyse existing code and understand complex business logic.
- Strong troubleshooting and documentation skills.
- Preferred Skills:
- Experience with Oracle Data Integrator (ODI).
- Knowledge of Oracle SQL Developer.
- Experience with ETL assessment, reverse engineering, and data flow analysis.
- Exposure to large-scale enterprise data environments.
- Expected Deliverables:
- Assessment of existing Oracle ETL architecture.
- Documentation of ETL workflows and dependencies.
- Identification of tables and database objects used across processes.
- Analysis of Oracle packages, procedures, and transformation logic.
- End-to-end data flow and business logic
Skills
Sign in to read and join the discussion.