Description

You will design, build, and maintain complex data warehousing integrations and dimensional data models. This role is on-site.

Responsibilities

• Develop complex integration code for warehouse and transactional applications using Informatica and PL/SQL.
• Design, implement, and test dimensional data models including Star and Snowflake schemas.
• Troubleshoot, debug, and performance-tune complex integrations and reporting queries.
• Partner with business teams to define and implement reporting and dashboard requirements.
• Maintain accurate documentation and Run Books per SDM standards.

Required Skills

• 10+ years of experience in Data Warehousing and Informatica products.
• Expert proficiency in Oracle 19c+ PL/SQL, including functions, procedures, packages, and triggers.
• Hands-on experience with Informatica PowerCenter 9.x (Workflow Manager, Monitor, Designer).
• Strong experience with Oracle databases and tools like SQL Navigator or TOAD.
• Proficiency with BI tools including Hyperion, SAS, Tableau, and Power BI.
• Experience with Unix Shell Scripting.
• Knowledge of Agile and Waterfall methodologies.
• Understanding of Data Privacy requirements such as GDPR and CCPA.

Preferred Skills

• Ability to mentor junior team members and guide technical decisions.

Key Skills

Education

Any Graduate