Sign in

Having 5 years of experience in informatica,oracle,sqlserver, unix.

Manchester, Connecticut, United States
November 28, 2017

Contact this candidate

Chaitanya Pentela



5+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial, and Telecom Sectors.

Strong Data Warehousing ETL experience of using Informatica 9.5/8.6PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools – Informatica Server, Repository Server manager.

Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP.

Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.

Experience in designing and developing complex mappings from various transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Sorter, Rank, Normalizer etc.

Strong experience in Dimensional Modeling using Star and Snow Flake Schema.

Expertise in working with relational databases such as Oracle 11g/10g/9i, SQL Server 2008/2005 and MS Access.

Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, Mainframes and SQL Server Databases.

Extensive experience in developing Stored Procedures,Views, Complex SQL queries using SQL Server and Oracle PL/SQL.

Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.

Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documentation.

Extensive experience in writing UNIX commands.

Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, Mainframes and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.

Worked extensively with SCD1 and SCD2.

Experience in optimizing the Mappings and implementing the complex businessrules by creating re-usable transformations and Mapplets.

Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines

Skill Summary:

ETL/ELT Tools : Informatica (Power Center 9.x/8.x, Power Exchange 8.x)

Dimensional Data Modeling : Dimensional Data Modeling, Star and Snowflake Modeling,

FACT and Dimensions Tables, Physical and Logical Data Modeling

Oracle Technologies:SQL, PL/SQL

RDBMS : Oracle 11g/10g/ 9.i, DB2.

Tools : PL/SQL-Developer

Languages : UNIX/LINUX

Client: BradyCorp Aug 2016 – Till Date

Project: Marketing Data Store (MDS)

The goal of the MDS project is to help marketing team to better understand the current marketing strategy and the customer behavior by integrating the data from multiple sources including customer, sales, google analytics, marketing channels and products to enable business insights.


Perform requirement analysis through coordination with business analysts and define business and functional specifications.

Provide documentation of ETL design and technical specifications, high level and low level design specifications.

Create test cases for Unit testing, Integration testing and User acceptance testing.

Create mappings using different Transformations like Source Qualifier, filter, Router, Aggregator, Lookup, Expression, Sequence Generator, and update strategy etc.

Create mappings, sessions, workflows and run those using workflow manger and monitor jobs using workflow monitor.

Perform Customer Data Profiling analysis using Informatica Data Profiling.

Profile source data to determine the characteristics.

Develop and report a Data Quality Audit/Assessment.

Design and execute the data quality mappings that will cleanse project data

Implement data quality processes including parsing, analysis, standardization and enrichment at point of entry and batch modes.

Involved in upgrading Informatica 9.6 to 10.1

Connecting and loading data from SAP and AZURE source systems.

Made use of Post-Session success and Post-Session failure batch scripts in the Session task to execute scripts needed for cleanup and update purposes.

Assist with task identification and effort estimates for ETL development as per Agile Development methodology.

Work with offshore team to develop and deliver the ETL tasks.

Create Control M jobs to schedule the dependencies.

Using Debugger to test the data flow and fix the mappings.

Prepare and use test data/cases to verify accuracy and completeness of ETL process.

Involve in Production Support and troubleshooting data quality and integrity issues.

Code migrations, resolving production issues, managing tickets in support system.

Environment: Informatica Power Center 9.6.1, SQL Server, Oracle, Windows, Control M

Client: Verizon Product Factory(VPF), Oct 2013 – Nov 2015

Verizon Wireless is a wholly owned subsidiary of Verizon Communications offering wireless telecommunications products and services. With 142.8 million subscribers as of July 2016, Verizon Wireless is the largest wireless telecommunications provider in the United States. The company is headquartered in Basking Ridge, New Jersey.

Verizon Fios service landed in 2005, Provides Internet, Television and Phone service using Fiber optic cable instead of copper wire over 5 Million people in 13 States. Verizon was one of the 1st major US carriers to offer Fiber to Home.

Verizon Product Factory is a Product catalog Used to maintain Product information like high-speed Internet,3G,4G,Wireless,Wireline,Video, TV, Bundle Products(Combination of Video, TV-like TATA SKY) and moved data to different down streams like SSP,I2O,PCAT,Bill Media,RIBS,RETAIN,DTV,RBI.


•Responsible for Business Analysis and Requirements Collection.

•Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

•Designed and customized data models for Data warehouse supporting data from multiple sources on real time.

•Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

•Created mapping documents to outline data flow from sources to targets.

•Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.

•Maintained source definitions, transformation rules and targets definitions using Informatica repository Manager.

•Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner and Union to develop robust mappings in the Informatica Designer.

•Developed mapping parameters and variables to support SQL override.

•Created mapplets to use them in different mappings.

•Developed mappings to load into staging tables and then to Dimensions and Facts.

•Used existing ETL standards to develop these mappings.

•Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.

•Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.

•Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

•Extensively used SQL* loader to load data from flat files to the database tables in Oracle.

•Modified existing mappings for enhancements of new business requirements.

•Used Debugger to test the mappings and fixed the bugs.

•Involved in Performance tuning at source, target, mappings, sessions, and system levels.

•Prepared migration document to move the mappings from development to testing and then to production repositories.

•Documented the complete project details like Best Practices, development standards, promotion and demotion policies and migration standards.

Environment: Informatica 9.5, Sqlserver, UNIX

Client:Pfizer Pharmaceutical LTD Aug 2011 – Sep 2013

Project Summary:

Pfizer is a Pharmaceutical company. Pharmaceutical information system plays a key role in any pharmacy-oriented organization. It deals with different product types used in developing products under various Batches, maintaining unit level details, stocks for Purchase and Sales, taking care of transactions like purchase order, Sales order along with their Vendor and customer information. The application frees the users from hard manual entries and gives the ease of use of transformation regarding Vendors, Customers, Products, units, and Stocks with transactions.


•Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.

•Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data.

•Consolidation, standardization for the unstructured flat file data.

•Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.

•Experience in integration of heterogeneous data sources like Oracle, SQL Server and Flat Files (Fixed & delimited) into Staging Area.

•Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.

•Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, Joiner and Rank transformations.

•Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.

•Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets.

•Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.

•Improved session Performance by enabling property incremental aggregation to load incremental data into target table.

•Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.

•Copied/Exported/Imported the mappings/sessions/ worklets /workflows from development to Test Repository and promoted to Production.

•Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.

•Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.

Environment: Informatica 8.6, Oracle10g, UNIX, SQL Developer

Contact this candidate