Sandeep Dev Email & Phone Number

Pune, Maharashtra, India

Gurugram

Gurgaon, India

Core competencies include design and development of ETL (Informatica) mappings and workflow as per business requirements.Proficient in ETL processes of creating Source/Target definitions, building Mappings using various Transformations, creating and monitoring Sessions/Workflows.Expertise in different stages of handling data viz. requirement gathering, identifying data sources/targets, data cleansing, data loading.Supporting Data warehousing and business intelligence projects.Responsible for understanding Veeva, a CRM built on Salesforce.com, it's Data Model and relationship between various objects and their data.Strong business understanding of Pharmaceuticals commercial business model.Strong Knowledge in Salesforce Administration and Customization, Data Validation, Sales Customer service and support development team.Hands on working experience in Role Hierarchy, Custom Profile and Public Groups creation and user management.

Noida Area, India

Responsible for smooth error-free configuration of DWH-ETL solution.Developing codes (Informatica mappings/scripts) according to Business Requirements and develop workflows.Extracted the data from various Sources like SQL Server, Oracle & Flat Files into the staging area for the Data Warehouse.Tuning the performance at sources, targets, mapping and session levels.Reviews and unit testing of every code before delivery, thereby maintaining quality.Involved in maintenance and enhancements for the existing ETLs and related processes.Developed Unix Shell Scripts to Automate the daily runs of ETLs and used Crontab to schedule the scripts.Ability to teach, facilitate and communicate effectively including training and mentoring the team members towards successful completion of projects within timelines.