Description

You will design, develop, and maintain ETL load plans for Oracle Autonomous Data Warehouse (ADW), ensuring data integrity and performance.

Responsibilities

• Design and develop ETL load plans for Oracle ADW using Oracle maintenance and optimization techniques.
• Develop and modify existing ETL processes, stored procedures, FTP workflows, and SSIS packages.
• Perform performance tuning for SQL, Oracle Data Integrator (ODI), Weblogic, and JVM environments.
• Validate and monitor ETL feeds to ensure data integrity across multiple SQL servers.
• Maintain and optimize the local data environment, including dimensional data modelling and flat file systems.

Required Skills

• 8+ years of experience in database development.
• Strong proficiency in SQL and PL/SQL.
• Extensive experience with Oracle Database (11g/12c) and SQL Server.
• Hands-on experience with Oracle Data Integrator (ODI), Informatica, or similar ETL tools.
• Practical knowledge of dimensional data modelling.
• Experience working with flat file systems.
• Ability to tune SQL, Weblogic, and JVM performance.
• Any graduate degree.

Preferred Skills

• Knowledge of Kafka.

Key Skills

Education

Any Graduate