Hemanth Kumar Email & Phone Number

Fort Lauderdale, FL, US

• Led enterprise level ETL architecture design initiatives & Developed Informatica mappings, sessions, and workflows to load transformed data into EDW from various source systems such as SQL Server, and Flat Files.
• Extracted data from heterogeneous sources and performed complex business logic on data using Informatica transformations (e.g. Router, Normalizer, Lookup, Rank, Aggregator, Union, etc.) and\or SQL Scripts (e.g. BTEQ.
• Designed Batch Audit Process in batch\shell script to monitor each ETL job along with reporting status which includes table name, start and finish time, number of rows loaded, status, etc and Developed a.
• Collaborated with business intelligence and functional teams to gather information regarding the source and target mappings.
• Data Profiling included the understanding of Data Lineage of Data flow from various feeds to various in stream tables and the columns.
• Resolved high and critical defect fixes in the development of ETL processes generated by System Test & business rules change

Long Beach, California, US

• Built a mechanism for automatically moving the existing proprietary binary format data files to HDFS using a service called Ingestion service.
• Performed Data transformations in HIVE and used partitions, buckets for performance improvements.
• Ingestion of data into Hadoop using Sqoop and apply data transformations and using Pig and HIVE.
• Used Git, GitHub, and used extracted data for analysis and carried out various mathematical operations for calculation purpose using python library - NumPy, SciPy.
• Developed various Python scripts to find vulnerabilities with SQL Queries by doing SQL injection, permission checks and performance analysis
• Performed troubleshooting, fixed and deployed many Python bug fixes of the two main applications that were a main source of data for both customers and internal customer service team.

Bentonville, Arkansas, US

• Implemented reporting Data Warehouse with online transaction system data.
• Managed user account, groups and workspace creation for different users in Powercenter.
• Worked with PL/SQL procedures and used them in Stored Procedure Transformations.
• Extensively worked on oracle and SQL server. Wrote complex SQL queries to query ERP system for data analysis purpose
• Worked on most critical Finance project and had been the go-to person for any data related issues for team members.
• Migrated ETL code from Talend to Informatica. Involved in development, testing and post-production for the entire migration project.

Atlanta, GA, US

• Designing and developing of mappings, mapplets, sessions and workflow to load the data for Ultimatix projects from source to target database using Informatica PowerCenter.
• Designing of Informatica jobs in SCD Type 1, 2 and 3 jobs. Moving the mappings and workflows from Dev to QA and QA to Production environment and unit testing the process.
• Involved in the smooth transition from Informatica 9.0 to Informatica 9.6 to migrate the mappings, sessions, workflows, repositories into the new environment.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.

Hyderabad, Telangana, IN

• Involved in designing physical and logical data model using ERwin Data modeling tool.
• Designed the relational data model for operational data store and staging areas, Designed Dimension & Fact tables fordata marts.
• Extensively used ERwin data modeler to design Logical/Physical Data Models, relational database design.
• Created Stored Procedures, Database Triggers, Functions and Packages to manipulate the database and to apply the business logic according to the user's specifications.
• Created Triggers, Views, Synonyms and Roles to maintain integrity plan and database security.
• Creation of database links to connect to the other server and Access the required info.

Bachelor'S Degree, Electrical, Electronics And Communications Engineering

Education record