Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic
Venu Madhavi Gunti

Venu Madhavi Gunti

Hyderabad

Summary

Having 6+ years of total experience, including 3+ years of technical expertise in Analysis, Design, Development, and Implementation of Client-Server Applications and Data Warehousing ETL (Extract, Transform, Load) using Ab Initio GDE, along with 2+ years of experience in Informatica PowerCenter 9.x/10.x. Extensive experience in Extraction, Transformation and Loading of data directly from heterogeneous source systems like flat files, Oracle by using Informatica power center.

Overview

7
7
years of professional experience

Work History

Ab-initio Developer

Citi Bank
01.2023 - Current
  • Developed and maintained Ab-initio graphs for data extraction, transformation and loading processes for financial data system
  • Implementing complex data transformations, cleansing and validation to produce high quality data delivery to downstream applications
  • Optimized Ab-initio graphs for performance. Collaborated with cross-functional teams, including data analyst and business clients to gather requirements and deliver tailored ETL solutions
  • Managing data in oracle database and creating configuration tables and maintaining them for new INTF_IDs generation.
  • Managing the flat files and multi-files in Unix operating system on dedicated client servers.
  • Scheduling and creating and modifying jobs as per the requirement on autosys scheduling tool and monitoring jobs on daily basis
  • Conducting unit testing and preparing unit test document to assist the SIT team.
  • Migrating the code to SIT environment and assist them in testing if they face any difficulties

ETL Developer

BlackRock
11.2021 - 11.2022
  • Interaction with the Customer business user to understand business requirements.
  • Understanding existing business model and customer requirements.
  • Understanding the mapping specifications and requirements.
  • Used Source Analyzer and Warehouse Designer to import the source and target database schemas, and the mapping designer to map source to the target.
  • Extraction of data from various sources using Informatica.
  • Designed various mappings for extracting data from various sources involving flat files and relational tables.
  • Development of the Informatica mappings to load the data from files/oracle to target Oracle database.
  • Created Mappings using various transformations like Filter, Router, Sorter, Joiner, Aggregator, Expression, Update Strategy, Lookup and Union.
  • Used Transformation Developer to create the filters, joiner, update strategy, lookups and Aggregation transformations, which are used in mappings.
  • Created various tasks like sessions, worklets, and workflows in the workflow manager during development.
  • To keep track of historical data slowly changing dimensions are implemented.
  • Developed mapping to load the data in slowly changing dimensions SCD Type -1 and Type-2.
  • Created Mapplets and Re-usable Transformations for applying few logics.
  • Created Connected, Un-Connected & Dynamic lookups (Cache)
  • Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance
  • Created and Monitored Batches and Sessions using Informatica Power Centre.
  • Worked with Mapping Variables and Mapping Parameters.
  • Developed all the mappings according to the design document and mapping specs provided and performed unit testing.
  • Checked the output according to the specifications.
  • Configured and ran the Debugger from within the Mapping Designer to troubleshoot the mapping before the normal run of the workflow.
  • Tuned several mappings for the better performance and involved in Performance Testing.
  • Documenting Unit test cases and Informatica mappings
  • Prepared documentation for business data flow from source to target and also for the changes made to the mappings/sessions existing to eliminate the errors.
  • Provide weekly status report to the Project Manager and discuss issues related to quality and deadlines.
  • Performed Unit testing and Integration testing of Informatica mappings.
  • Implemented various Performance Tuning techniques.

ETL Developer

BT Group
09.2020 - 10.2021
  • Extracted Data from Oracle data base by using Source Analyzer.
  • Analysis of the specifications provided by the clients.
  • Used Various Transform components such as Filter, router, Sorter, Expression, Aggregator, Union, Seq Gen, Lookup and Joiner.
  • Have created ETL mapping, sessions and workflows as per the requirement.
  • Working on the aggregator for calculating the aggregate values.
  • Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
  • Created the Staging Area and loading raw data to cleanse it over there.
  • Running the Jobs/Workflow for ETL process.
  • Verify the both runs and records on daily basis.
  • Verifying the data in target database after ETL process.
  • Performed column data mapping between source & target database.
  • Prepared SQL Queries
  • Verified column mapping between source and target tables.
  • Ability to interface and communicate effectively with team members and provide the guidance in the development activity.
  • Worked closely with the onsite team to understand the business requirements and applying the business rules to make them up to the DW.

SQL Developer

BSNL
01.2019 - 08.2020
  • Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
  • Analyzed and debugging the existing SQL queries to identify opportunities for improvements and delivered application support.
  • Communicated with the clients effectively in the development, maintenance and support of custom applications using reports and trackers.
  • Handling Production Support Issues through an established ticketing process.
  • Developed custom Microsoft Power BI dashboards, visualizations, and interfaces to deliver meaningful and actionable insights.
  • Received 'Star of the Month award' for on time completion of multiple number of complex tasks
  • Received 'On-the-Spot award' for timely delivery with minimal defects.
  • Received 'Service and Commitment award' for my commitment and service towards the company.
  • Received 'Raising Star award' for showing positive attitude and commitment towards delivery.

Education

B. Tech -

Gayatri vidya Parishad college of engineering(A), JNTUK
Visakhapatnam, Andhra Pradesh
01.2018

Diploma - Electrical and Electronics engineering

A.A.N.M & V.V.R.S.R Polytechnic
Gudlavalleru, Krishna district, Andhra Pradesh
01.2015

Skills

  • Ab-initio GDE
  • Informatica Power Center 9x/10x
  • ETL
  • Data Warehousing
  • SQL
  • Auto-sys
  • Informatica Scheduler
  • Unix
  • Jenkins
  • Oracle 11g
  • Oracle 12c
  • Secure CRT
  • WinSCP
  • PUTTY
  • Windows XP
  • Windows 7
  • Windows 8
  • Microsoft Excel

Accomplishments

  • Received the “Star of the Month Award” for on-time completion of multiple complex tasks
  • Received 'On-the-Spot Award' for timely delivery with minimal defects
  • Received the Service and Commitment Award for my commitment and service toward the company
  • Received the 'Raising Star Award' for showing a positive attitude and commitment toward delivery

Timeline

Ab-initio Developer

Citi Bank
01.2023 - Current

ETL Developer

BlackRock
11.2021 - 11.2022

ETL Developer

BT Group
09.2020 - 10.2021

SQL Developer

BSNL
01.2019 - 08.2020

B. Tech -

Gayatri vidya Parishad college of engineering(A), JNTUK

Diploma - Electrical and Electronics engineering

A.A.N.M & V.V.R.S.R Polytechnic

Similar Profiles

CREATE PROFILE
Venu Madhavi Gunti