Kumpatla Durga Govinda Gananji Kumar

Client: HSBC, Project: Retail Data Model Development

• Developed SQL scripts using Spark for handling different data sets and verified the performance over Map Reduce jobs
• Developed various ETL transformation scripts using Hive to create refined datasets analytics use cases.
• Automated workflows using shell scripts and Control-M jobs to pull data from various databases into Hadoop.
• Effectively composed technical and non-technical documents such as design specifications, operation guides, process flows, and other technical schematics.
• Worked closely with Cloudera platform team to understand performance bottle necks in the existing system and improved the code performance
• Created Hive tables, partitions, and implemented incremental imports to perform ad-hoc queries on structured data.

Client: Dell, Project: Make The Right Commitment

• Responsible for Analysis and developing Extraction, Transformation and loading process using ETL tool Informatica Powercenter, StreamSets Control Hub.
• Automated the Generation of Teradata & GreenPlum table DDL’s, Views, Macros, TPT Scripts, & Greenplum Insert & Delete logics using Mapping Document with Python.
• Involved in Pre deployment and post deployment activities and code transition activities to support team once we get business signoff.
• Building SQL queries for data analysis & production data validations.
• Developed control M jobs for scheduling & interdependency.
• Using GIT Hub & Harvest for CICD process & Migration of code from one environment to another.
• Worked in Agile methodology and involved in Sprint planning and review meetings.

Client: Mount Sinai, Project: Patient360

• Created analysis of source systems, business requirements and identification of business rules.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) Processes using Pentaho & Oracle.
• Created Re-Usable transformations using Meta Data Injection and automated the ETL Process.
• Prepared documents for Unit Test Plan and the Test Cases for the developed mappings.
• Working on SQL scripts and queries for analysis, extraction, transformation & load in Oracle data base.
• Worked in creating Data Lake with Big Data Technologies like Hadoop, HDFS, Hive & Sqoop.