Dheeraj Yadav — Data Engineer

● Implemented multiple ETL pipeline using Informatica PowerCenter and loaded the data in Amazon Redshift for analytical purpose. ● Implemented Data ingestion ETL flow using Informatica IICS. ● Copy the data from data policy to Amazon S3 using unload Query in Informatica PowerCenter. ● Performed the Data Validation and UAT Testing in QA. ● Copy data from SharePoint to local and local to Amazon S3 and loaded in Amazon redshift from Amazon S3. ● Prepared the CAB documents and presented in CAB meeting for PROD Development. ● Need to create Informatica BDM mapping and workflow as per the requirement provided by Business. ● Created secured view to store PII data in Hive. ● Creating Job definitions for workflow jobs scheduling in CA Workload Automation. ● Performed the UAT testing, created test case, test steps and attached UAT results in same using Rally. ● Implemented changes in Production independently, Created and Maintained proper documentations as per PSO Team. ● Providing the implementation estimate of new business requirements includes development, Unit testing, UAT Deployment, UAT testing and production release. ● Implemented Python utility to find workflow name, mapping name, sources and targets from the Informatica BDM App XML file and reduced 95% of manual work. ● Implementation of data warehouse projects specially using Informatica BDM, and Informatica PowerCentre. ● Build the Mappings, Workflows and Applications in Informatica BDM and Mappings, Workflows, Sessions in Informatica Powercenter. ● Implemented Python script to automate the status mail for Various module. ● Ensuring completion of unit testing before deploying code to Higher Environment. ● Deploying the components from lower region to Higher region using Jenkins and GIT. ● Creating Jobs, building up the Job Streams, setting up the dependencies and scheduling the job streams in TWS Work scheduler. ● Proficient in using defect tracking tool JIRA. ● Familiar with SFTP protocols and secure data transmission. ● Involved in run hand over activity, Created and Maintained proper documentations.

Stackforce AI infers this person is a Data Engineer specializing in ETL processes and cloud data solutions.

Location: Gurugram, Haryana, India

Experience: 6 yrs 11 mos