INFORMATICA DWH – SENIOR ASSOCIATE/PROJECT LEAD
Job Location : Gurugram/Noida, India
Required Skills and Experience : Minimum of 3 years of relevant experience in DWH/ETL Tools with exposure to Pharma domain.
Technical:
- Must have expertise in Data Warehousing, Facts and Dimensional modelling, Change Data Capture and ETL concepts.
- Should have 3-6 years of working experience in at least 2 of the following technologies: AWS Redshift, Informatica, SSIS, Matillion, Talend.
- Must have expertise with advanced SQL and data analysis
- Must be aware of techniques such as: ETL Mapping design, SQL Performance tuning, UNIX Shell scripting and regression testing
- Good to have experience and additional know-how of Big Data technologies like Hadoop, Python, PySpark etc
Functional:
- Good to have experience in following Pharma specific functional areas:
- Pharma data sources like IMS, Veeva, Symphony, Cegedim etc.
- Business processes like Alignment, Market definition, segmentation, sales crediting, activity metrics calculation.
- Calculation of all sales, activity and managed care KPIs.