Description

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

Responsibilities

• Develop expert-level PL/SQL scripts, functions, and complex SQL queries to support model development.
• 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 to perform thorough unit testing.
• Coordinate with distributed teams and provide regular task status updates to management.

Required Skills

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

Preferred Skills

• Python programming and Tableau reporting experience.
• Experience with MuleSoft, API technologies, and SVN/BitBucket.
• Familiarity with Jenkins, Ansible, or IBM UBuild/UDeploy.

Key Skills

Education

Any Graduate