Description

You will develop and optimize PL/SQL scripts and Unix processes to support data warehouse operations and model development.

Since is_remote, hybrid, and on_site are all 0, no work mode line is added.

Responsibilities

• Develop expert-level PL/SQL scripts, functions, and complex SQL queries.
• Create and expose views and materialized views within the database.
• Write Unix scripts to automate and support process and model runs.
• Design and execute test cases for thorough unit testing.
• Coordinate with distributed teams and provide regular status updates.

Required Skills

• 5+ years of experience in PL/SQL programming and database design.
• Strong proficiency in Informatica PowerCenter for ETL processes.
• Performance tuning for targets, sources, mappings, and SQL queries.
• Advanced knowledge of Unix commands and shell scripting.
• Experience with Autosys for job scheduling.
• Strong data analysis and data modeling skills.
• Bachelor's degree or equivalent graduate qualification.

Preferred Skills

• Python programming and Tableau reporting experience.
• Experience with MuleSoft, API technologies, and SVN/BitBucket.

Key Skills

Education

Any Graduate