Description

You will design and maintain ETL pipelines and database objects as an Oracle Subject Matter Expert.

This role is on-site.

Responsibilities

• Analyze data feeds from Oracle, SQL Server, and flat files to design development schemas.
• Develop, unit test, and debug PL/SQL objects including stored procedures, triggers, and packages.
• Performance tune ETL jobs and Oracle objects using query plan analysis and partitioning strategies.
• Provide break-fix support for ETL pipelines and database infrastructure.

Required Skills

• 3+ years of experience with Informatica PowerCenter.
• 3+ years of experience with Oracle 10g or higher.
• Expertise in Oracle SQL, PL/SQL, SQL*Plus, and data modeling.
• Proficiency in performance tuning and query plan analysis.
• Experience integrating heterogeneous sources (Oracle, MS SQL Server, flat files).
• Familiarity with version control tools like Subversion (SVN).
• Bachelor's Degree in IT or Technical Diploma with equivalent experience.

Preferred Skills

• Experience with TIDAL enterprise scheduler.
• Proficiency with MS Visio, Toad, or ER/Studio.

Key Skills

Education

Any Graduate