Kesava Reddy Mekala

Associate Engineer @Nice Software Solutions Pvt. Ltd.

Pune, IN

Experienced in Analysis, Development, and Implementation of business applications including Development and Design of ETL methodologies using Informatica Power Center in various domains.Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)Experience in preparing Test Strategy, developing Test Plan, documentig Test Cases, and writing Automated Test Scripts.Designed and developed Complex mappings from various Transformations like re-usable transformations, and Mappings/Mapplets, Unconnected / Connected look-ups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more, mappings using Stored Procedure’s, Normalizer.Preparing the low-level Design Specifications for ETL Coding and mapping standards.Experience in Performance tuning of targets, sources, mappings and sessions.Experience in integration of various data sources like Flat files, Oracle.Experience in Star Schema, FACT tables, Dimension tablesStrong expertise in Relational data base systems like Oracle design and database development using SQL.Develop, execute ETL test plans, Document ETL processing and generate required meta data.

Acharya Nagarjuna University

Bachelor's degree