Dhananjay Dayate

Coordinate with project team and client to get the business requirements.

Worked on agile methodology and delivered sprint deliverables as per the system.

Created dims and fact tables in Amazon Redshift using DDL scripts.

Experience in Creating Input, update and insert queries i.e pipeline scripts for collecting, inserting and updating data into redshift tables.

Created pipeline queries for complex tables like Type1,2,3 SCD and Type7 SCD tables.

Ingested data from S3 bucket to redshift table through running Airflow jobs.

Writing unit test cases for validating the Initial Load and Incremental Load for created Pipeline.

Used GitHub as centralized repository while doing the code migration to UAT, PFIX & PROD.

Prepared high level design, low level design and other project related documents.

Worked on the data analysis and fixing if we have the data mismatch while validating data in production.

Developed reports, excel sheets.

Developed and maintained reports and product quality checksheets.