Description

You will design, develop, and modify ETL load plans to move data into Oracle Autonomous Data Warehouse (ADW).

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, and SSIS packages.
• Perform performance tuning for SQL, ODI, Weblogic, and JVM.
• Validate and monitor ETL feeds to ensure data integrity.
• Maintain and optimize the local data environment across multiple SQL servers.

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