Description

You will manage the full lifecycle of data warehouse development and BI application support.

Responsibilities

• Design and develop ETL mappings, mapplets, workflows, and sessions using Informatica PowerCenter.
• Review technical requirements and design ETL process flows, including data profiling of source systems.
• Build complex SQL queries and implement error handling and performance improvements.
• Mentor junior team members and conduct design and code walkthroughs.
• Collaborate with business and IT stakeholders during requirements gathering to identify needs.

Required Skills

• 6+ years of experience in ETL development.
• 3+ years of experience specifically with Informatica.
• Proficiency in Informatica PowerCenter 9.x (Designer, Repository Manager, Workflow Manager).
• Hands-on experience with Informatica Cloud (IICS) for data and application integration.
• Experience with Informatica Data Quality, including profiling, scorecard creation, and analyst tools.
• Strong knowledge of Data Warehouse fundamentals and relational database design concepts.
• Extensive experience in Data Modelling and Architecture.
• Ability to work in shifts.
• Experience in BI App Support.

Key Skills

Education

ANY GRADUATE