Job Description :
The Senior ETL Architect is responsible for architecting and developing solutions and successful project delivery & process engagements. –
Overall 10 years of experience implementing large scale ETL processes using Informatica PowerCenter. In the pharma domain. Design high level ETL process and data flow from source system to target databases. - MDM/ODS architect and knowledge, best practices.
Extensive Data Warehouse experience using Informatica Power Center as ETL tool.
Experience in MSBI (SSIS, SSRS and SSAS Experience in creating architecture of Data warehouse, Business Intelligence and Veeva and ODS system.
Architect and guide the project teams during full lifecycle project phases, going through requirements gathering, end user interaction, data analysis, data profiling, extraction and transformations, data modeling, Reporting/ Dash boarding - leveraging the appropriate data Integration, modeling and Visualization tools
Experience in loading data to Salesforce.com cloud using Informatica Cloud.
Experience in creating architecture of Data warehouse, Business Intelligence and Veeva and ODS system.
Experience in understanding customer requirement and create Business Process Model as per the Requirements
Good understanding of project life cycle, especially tasks within the ETL phase. - Ability to work independently and multi-task to meet critical deadlines in a rapidly changing environment. - Must be a team player and be able to lead and mentor other developers onsite and offshore. - Good communication and presentation skills.
Experience in creating reports using SSRS.
Experience in Creating ETL packages using SSIS.