Description

You will develop and maintain ETL processes for a large data warehouse and multiple data marts within an Oracle environment.

Responsibilities

• Collaborate with users and SMEs to collect requirements and create technical design and mapping documents.
• Develop, test, and maintain Oracle SQL and PL/SQL code.
• Validate data accuracy and quality through direct user involvement.
• Manage source control, release processes, and production support.
• Investigate production issues, identify root causes, and implement solutions.

Required Skills

• BS in Computer Science.
• 4+ years of SQL development, including tuning and analytic functions.
• 4+ years of Oracle PL/SQL development, including stored procedures, packages, functions, and dynamic SQL.
• Advanced PL/SQL experience with table partition management automation, table functions, and calling external programs.
• 4+ years of data modeling.
• 4+ years of ETL development.
• 4+ years of experience using Oracle DB client tools such as Toad or SQL Plus.
• 2+ years of Unix/Windows shell scripting.
• Strong analytical and problem-solving skills for troubleshooting production issues.

Key Skills

Education

BS Computer Science