Description

You will develop complex integration code within a data warehousing environment.

Responsibilities

• Develop complex integration code for warehouse and transactional applications.
• Design and test dimensional data models (Star & Snowflake schemas; Kimball/Inmon).
• Troubleshoot and performance tune complex integrations and reporting.
• Partner with business teams to define reporting and dashboard requirements.
• Maintain documentation and Run Books per SDM standards.

Required Skills

• 10+ years in Data Warehousing and Informatica products.
• Expert proficiency in Oracle 19c+ PL/SQL (functions, procedures, packages, triggers).
• Hands-on experience with Informatica PowerCenter 9.x (Workflow Manager, Monitor, Designer, etc.).
• Experience with Oracle databases and tools like SQL Navigator/TOAD.
• Proficiency with BI tools including Hyperion, SAS, Tableau, and Power BI.
• Exposure to Agile and Waterfall methodologies.
• Knowledge of Data Privacy requirements (GDPR, CCPA).
• Ability to mentor junior team members.

Key Skills

Education

Any Graduate