Description

You will implement ETL tools as an Oracle Subject Matter Expert, providing technical support and consulting. You will design development schemas, review dimensional data modeling, and ensure performance through tuning and debugging.

Responsibilities

• Analyze data feeds and interfaces from Oracle, SQL Server, and flat files.
• Design development schemas for ETL feeds and dimensional data models.
• Test, debug, and performance tune ETL and Oracle objects.
• Write technical designs, develop, and unit test PL/SQL objects.
• Provide break-fix support for ETL pipelines and database objects.

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, stored procedures, triggers, and packages.
• Proficiency in performance tuning, query plan analysis, and partitioning.
• Experience with heterogeneous sources including Oracle, MS SQL Server, and flat files.
• Familiarity with version control tools like Subversion (SVN).
• Ability to diagnose technical challenges by reading code and documentation.
• 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