Sign in

Manager Data

Midlothian, Virginia, United States
August 28, 2017

Contact this candidate


Divya Bharathi Chittipothu


Professional Summary:

Over 5 + years of ETL and data integration experience in developing ETL mappings and scripts using Informatica Power Center 8.x/9.x.

Experience in working with business analysts to identify study and understand requirements and translated them into ETL code in Requirement Analysis phase.

Strong knowledge of Entity-Relationship concept, Facts and Dimensions tables, slowly Changing Dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).

Experience in integration of various data sources like Oracle, SQL server and non-relational sources like flat files into staging area.

Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.

Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).

Experienced in UNIX work environment, file transfers, job scheduling and error handling.

Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.

Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.

Worked exclusively on implementing the types of Slowly changing dimensions (SCDs)- Type I II and III indifferent mappings as per the requirements.

Used the techniques like Incremental aggregation, Incremental load and Constraint based loading for better performance.

Worked with the flat files in both the direct and indirect methods and also worked with XML files.

Documenting the mapping process and methodology used to facilitate future development.

Resolving queries and ensures delivery on-time.

Excellent analytical and problem solving skills.


Bachelor of Technology in Information Technology, Jawaharlal Nehru Technological University, Hyderabad, India

Technical Skills:


Oracle 10g/11g, Teradata.

ETL Tools

Informatica Power Center 9.x/8.x.

Operating Systems

UNIX, Windows.

Scheduling Tools

Maestro, ESP, Control-M.


Agile, Waterfall.


PL/SQL, C, C++.

Other Tools

Teradata SQL Assistant, TOAD, SQL Developer.

Professional Experience:

Client: Nationwide Insurance, Columbus, OH 03/16 – Till Date

Role: ETL Developer

Project Description: The Direct Reporting Program will deliver a comprehensive Business Intelligence solution that is built upon a trusted, extensible and distinct data platform enabling timely and accurate data analytics capabilities across direct business units and channels. Immediate delivery of business intelligence will support proactive and quick decisions in an increasingly competitive marketplace.


Gather and analyze information on existing business processes in order to make recommendations that seek to improve business systems and processes.

Created Mapplets, reusable transformations and used them in different mappings

Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.

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

Improved the performance of the mappings by moving the filter transformations early into the transformation pipeline, performing the filtering at Source Qualifier for relational databases and selecting the table with fewer rows as master table in joiner transformations.

Identified and tracked the slowly changing dimensions/mini dimensions, heterogeneous Sources and determined the hierarchies in dimensions.

Used Debugger in Identifying Bugs in Existing Mappings by Analyzing Data Flow, Evaluating Transformations.

Weekly meeting with the Project Management team and share the Status Report on the weekly basis.

Environment: Informatica PowerCenter 9.6.1, UNIX, Toad, Putty, Teradata, Oracle.

Client: Level3 Communication, India / USA 06/14 - 02/16

Role: ETL Developer

Project Description: Level 3 Communications is a premier global communications provider headquartered in Broomfield, Colorado, that provides communications services to enterprise, government and carrier customers. Level 3’s global network reliably and securely provides enhanced, scalable network capabilities to address the increasingly complex operating environment of today’s technology landscape. Level 3 take end-to-end responsibility for monitoring and maintaining the network. Level 3 provides full set of data, security, video, voice and unified communications.


Analyzing the BRD and HLD and preparing low level design document (Low Technical Specification).

Extracted source data from Oracle and loaded into Oracle.

Developing Informatica Mappings and Sessions based on user requirements and ETL rules to load data from source tables to target tables and loading the data using the transformations like Aggregator, Expression, Lookup, Filter, Router, Joiner, Update and Union.

Developing workflows using sessions, command and Email tasks.

Pre and post session assignment variables were used to pass the variable values from one session to other.

Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.

Monitoring the ETL flow and troubleshooting the issues.

Developed Re-Usable Transformations and Mapplets.

Taking Care of Pre-Production Activities.

Environment: Informatica PowerCenter 9.5, Oracle, Toad, Putty, Telnet, Winscp, FTP, UNIX, ESP.

Client: EMC2, India 04/13 - 05/14

Role: ETL Developer

Project Description: EMC2 Corporation is American Multinational Corporation headquartered in Hopinkton, United states. EMC2 offers data storage, information security, virtualization, analytics, cloud computing and other products and services that enable businesses to storage, manage protect and analyze data. The presales related activities are triggered here where it includes creation of Opportunities and deals, distributing percentages among sales representatives and sales hierarchy.


Interacted with business analysts and translate business requirements into technical specifications.

Designed and developed end-to- end ETL process from various source systems to staging area, from staging to DataMart.

Worked on Informatica to extract data from Flat files, Excel files, and MS Access database to load the data into the target database.

Implemented the Incremental loading of Dimension and Fact tables.

Created Stored Procedures for data transformation purpose.

Extensively used Informatica client tools such as Informatica PowerCenter, Workflow Manager, and Workflow Monitor to develop and test ETL processes.

Created Tasks, Workflows, and Sessions to move the data at specific intervals on demand using Workflow Manager.

Developed the control files to load various sales data into the system via SQL*Loader.

Developed Unix Shell scripts for maintaining files.

Designed and created an Autosys job plan to schedule our processes.

Created PL/SQL Stored procedures and implemented them through the Stored Procedure transformation.

Developed, tested and implemented break/fix change tickets for maintenance.

Developed the document of the complete ETL process.

Environment: Informatica PowerCenter 9.1, Oracle 8i (SQL/PLSQL), UNIX, Toad, Service Now, UNIX, Autosys.

Client: News Corporation (Star India) 11/11 - 03/13

Role: Associate Developer

Project Description: Star India has defined the Indian media landscape for over two decades and today is one of the country’s leading media conglomerates, reaching approximately 650 million viewers a month across India and more than 100 other countries. This project is to incorporate multiple portfolios of the Company.


Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.

Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.

Designed and developed Informatica mappings for data loads and data cleansing.

Created complex mappings using Aggregator, Expression, Joiner transformations including complex lookups, Stored

Procedures, Update Strategy and others.

Involved in testing of stored procedures and functions, unit and integrating testing of Informatica sessions, batches

and the target data.

Designed and developed table structures, stored procedures, and functions to implement business rules.

Extensively involved in migration of ETL environment, database objects and EDW.

Tested data integrity among various sources, targets and various performance related issues.

Environment: Informatica PowerCenter 8.6.1, UNIX, Toad, Putty, Harvest Version Control, Maestro Scheduling Tool.

Contact this candidate