Ganesh Varma Dandu

CLIENT : PEPSICO

•Interacted with the business analyst in gathering the requirements and created functional documents.

• Developed complex ETL jobs based on the business requirement.

• Error Handling – Used tLogcatcher and tStatcatcher components for capturing every error and logging details into the status table.

• Creating jobs using components tAggregateRow, tMap, tJoin, tUnite, tReplicate, tRunjob, tDBInput and tDBOutput,FileDelimited Components and SFTP components.

• Effectively implemented the SCD Type1 & Type2 mapping.

• Effectively worked with the delta load mappings.

• Used TsendMail Component to send success/failure notifications to the business team.

• Involved in unit testing for the developed jobs.

• Worked on Context variables and defined contexts for database connections, file paths for easily migrating to different environments in a project.

• Creating run books for the support team.

• Involved in PROD Deployment with the support team.