Provide hands-on technical direction and design strategy for development of the Informatica based Data Warehouse platform in GWBT.
Architect, design, prototype, and deliver innovative solutions to migrate legacy Data Warehouse platforms to Informatica.
Engage with senior stakeholders including other group architects to drive architectural directions
Plan, track, manage, and report on large programs comprising multi-faceted teams of offshore/onsite associates and vendors.
Define, setup, and implement BI standards incorporating the industry-wide best practices so as to come up a robust, scalable, and high performing Data Warehouse platform on Informatica 9.1 that meets or exceeds performance & availability SLAs, and business needs.
Periodically collect and report project metrics, analyze and review the same with QA and other PMO teams.
Work with Operations Excellence teams to come up with innovative solutions to improve quality, efficiency and effectiveness of deliverables.
Performance improvement & SQL tuning of Informatica mappings, SQL & PL/SQL scripts
o Overall experience of 10+ years
o Minimum 6 years strong experience in the architecture, design and development of large, high performance Data Warehouse solutions using Netezza, Oracle, and Informatica 9.1 platforms.
o Experience of 5+ years in the BFSI domains
o 2+ years experience in planning, tracking, management, and reporting of large programs comprising multi-faceted teams of offshore/onsite associates and vendors