Akhila Reddy Informatica Developer

Phone: 732-***-****

: abo1t6@r.postjobfree.com

Resumes ID: 48981

Location: Eagan, Minnesota

Posted: 04.13.2012

Resume Details:

Professional Profile

More than 7 years of experience in Information Technology with a strong background in Analysis, Design, Development, Implementation of Data warehousing in ETL process using Informatica Power Center 8.x/7.x/6.x/5.x., Power Mart, Repository Admin Console, Repository Manager, Designer, Datamart, OLAP, OLTP.

Experienced in all phases of Software Development Life Cycle (SDLC).

Good knowledge of Data warehouse concepts and principles of Ralph-Kimball and Bill-Inmon methodologies – Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization, Facts and Dimensions tables, Physical and Logical data Using Erwin for Data Marts and Staging Database.

Extensive development experience for the Extraction, Transformation and Loading of data from multiple disparate sources such as Oracle, MS SQL Server, DB2, Teradata, Flat Files, XML Files into ODS (Operational Data Store) and EDW (Enterprise Data Warehouse) systems.

Solid Expertise in Creating Migration Document and expertise in creating Functional and Technical Documentation for ETL.

Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.

Well acquainted with Informatica Designer Components - SourceAnalyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.

Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.

Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.

Expertise in implementing complex business rules by creating re-usable transformations, Mapplets and Mappings.

Extensive knowledge in handling slowly changing dimensions type.

Extensively used Informatica Repository Manager and Workflow Monitor.

Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.

Hands on experience in Performance Tuning of sources, targets, transformations and sessions.

Good experience in data profiling, data integration services and data cleansing activities and documenting the ETL process flow for better maintenance and analyzing the process flow.

Solid Expertise in Oracle Stored Procedures,Triggers, Cursors, Indexes, Functions, Table Partitions and experienced in working with Oracle using SQL, PL/SQL, SQL Plus, SQL Loader, TOAD.

Strong Knowledge in optimizing database performance.

Well Experienced in Doing Error Handling and Troubleshooting using various log files.

Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.

Experience in UNIX, shell scripting, CRON, FTP and file management in various UNIX environments.

Expertise in creating Test Plans and writing Test Cases.

Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.

Highly Motivated to take independent responsibility as well as ability to contribute and be a productive team member.

Education Qualification: Bachelor’s from Computer Science Engineering, JNTU, India.

Technical Skills:

ETL Tools

Informatica 8.x/7.x/6.x/5.x (Power Center/Power Mart/Power Exchange) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect)

Data Modeling

Erwin 4.0/3.5, Star Schema Modelling, Snow Flake Modelling

Databases

Oracle 10g/9i/8i, MS SQL Server 2005/2000, DB2, Teradata v2r6/v2r5

OLAP Tools

Cognos 8.0/7.0/6.0

Languages

SQL, PL/SQL, T-SQL, Unix Shell Script, Visual Basic, HTML, XML

Tools

Toad, SQL* Loader, SQL Navigator

Operating Systems

Windows 2003/2000/NT, AIX, Sun Solaris, Linux

Thomson Reuters, Eagan, MN Dec 10 – Sep 11 Senior ETL Developer

Responsibilities:

Created/modified Informatica ETL mappings that map the source data from the various sources to the target database and the datawarehouse based on requirement.

Migration of Informatica mappings from DB2 to Oracle.

Worked on various sources ranging from Flat files, DB2 and SQL Server.

Rewriting the code from DB2 to PL/SQL.

Used SQL tools like TOAD,Winsqlto run SQL queries and validate the data.

Testing the Informatica Mappings after migrating to the Oracle database against the DB2 Production Datawarehouse.

Implemented Join, Expression, Aggregate, Lookup, Update Strategy, Filter and Router Informatica Transformations.

Involved in creating non-reusable/reusable sessions and workflows in Workflow designer and Taskdeveloper and defined schedules for sessions.

Involved in Performance Tuning of mappings and sessions.

Involved in extensive Performance tuning by determining bottlenecks at various points like targets, sources and systems and eliminated them. This led to better session performance.

Prepared ETL mapping documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment and to transfer knowledge to production support and other team members.

Environment: Informatica Power Center 8.6, Oracle 11g, SQL Server 2008, DB2, Flat files, PL/SQL, SQL, T-Sql, Winsql, TOAD, Windows XP Professional, UNIX.

The Toro Company, Bloomington, MN Sep 10 – Nov 10 ETL Developer

The Toro Company is involved in making landscapes green, healthy and safe with superior, innovative and environmentally sound products, services andsystems to help customers beautify and preserve the outdoor environments. Project involves migration of Datawarehouse from Oracle to SQL Server.

Responsibilities:

Created/modified Informatica ETL mappings that map the source data from the various sources to the target database and the data warehouse based on requirement.

Involved in Migration of Informatica mappings from Oracle to SQL Server.

Worked on various sources ranging from Flat files, SAP, Oracle and SQL Server.

Rewriting the code from PL/SQL to T-Sql.

Gained good experience working with SAP source tables.

Testing the Informatica Mappings after migrating to the SQL Server database against the Oracle Production Datawarehouse.

Worked on various transformations such as expression, Look Up, Joiner, Filter, Router and Update Strategy Transformations.

Improved the performance of Mappings by replacing the Oracle sequences with Informatica sequences.

Extensively working on the performance tuning of the programs, ETL Procedures and processes.

Prepared ETL mapping documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.

Environment: Informatica Power Center 8.1.1, Hotfix 4, Oracle 10g, SQL Server 2008, Flat files, PL/SQL, SQL, T-Sql, SQL*Plus, TOAD, SAP R/3, Windows XP Professional.

Ameriprise Insurance, Minneapolis, MN Feb 09 – Aug 10 Informatica Developer

Ameriprise offers a full range of high-quality insurance products such as Annuities, Auto & Home Insurance, Life Insurance, Long term Care Insurance. Project involved in developing Enterprise Subject Data warehouse to implement a centralized database that collects and organizes and stores data from different operational data sources to provide a single source of integrated and historical data.

Responsibilities:

Translated the business requirements into technical specifications to build the Enterprise data warehouse.

Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.

Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes usingInformatica powercenter8.6.1/8.1.1

Extensively used Informatica Client tools – Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.

Worked on multiple disparate Data sources ranging from flat files, XML Files, Oracle, SQL server databases to load the data into ODS.

Created and modified Oracle Database tables and SQL Server tables as per the design requirements and applying constraints to maintain complete Referential Integrity and creating indexes for performance and loading the data into Oracle database tables.

Designed and developed Mappings using Mapping Designer to load the data from various sources using different transformations like Aggregator, Lookup (connected and unconnected), Filter, Router, Rank, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter, Sequence Generator and Update Strategy transformations.

Developed mappings with transformations (reusable) and mapplets confirming to the business rules. Developed and wrote procedures for getting the data from the Source systems to the Staging and to the Data Warehouse and Data Mart.

Integrated various sources in to the Staging area in Data warehouse for Integrating and Cleansing data.

Created Sessions, Workflows and Worklets for data loads using Workflow Manager.

Created events and tasks in the work flows using workflow manager.

Monitored Workflows and Sessions using Workflow Monitor.

Executed sessions, sequential and concurrent batches for proper execution of mappings.

Executed Pre and Post session commands on Source and Target database using Shell Scripting.

Used mapping parameters and variables at mapping and session levels to tune the performance of Mappings.

Implemented performance tuning by using lookup caches, using tables with fewer rows as the master table in joiner transformations, dropped indexes and re-created them after loading data to targets and increased the commit interval.

Worked on Performance Tuning of various sources, targets, mappings and sessions to identify and remove Bottle Necks.

Improved workflow performance by shifting filters as close as possible to the source and selecting tables with fewer rows as the master during joins.

Involved in Unit testing, User Acceptance Testing and System Testing to verify accuracy and completeness of ETL process.

Used control – M for Job scheduling.

Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and databases.

Worked with cognos team in creating and generating various reports.

Environment: Informatica Power Center 8.6.1/8.1.1, Oracle 9i/10g, SQLServer 2005, Flat files, PL/SQL, SQL, XML, SQL*Plus, TOAD, SQL navigator, Windows XP Professional, Cognos, UNIX, Erwin 4

Provident Bank, Cincinnati, OH Nov 07 – Dec 08 ETL Developer

The project involved developing an integrated Data Warehouse system, to meet the demands of detailed, targeted customer data and sales analysis. The Data Warehouse was designed with expansion in mind, as the final stage of this project was to incorporate atomic level detail data.

Role & Responsibilities:

Created/modified Informatica ETL mappings that map the source data from the mainframe system to the target Oracle database and the data warehouse based on requirement.

Efficiently gathered the heterogeneous sources, developed the mappings to transform data to Data Mart using Informatica to synchronize with specification.

Used aggregator, lookup, expression, stored procedure, filters in the mappings.

Used Sequence Generator Transformation to create surrogate keys for dimension tables.

Scheduled workflows from backend using PMCMD command.

Used ETL to extract and load data from Oracle and flat files to Oracle.

Created various transformations such as Update Strategy, Look Up, Joiner, Filter and Router Transformations.

Developed mapping to load and Maintain data in slowly changing dimensions.

Facilitated performance tuning of Sessions and Mappings.

Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation.

Created and Monitored Workflows using Workflow Manager and Workflow Monitor.

Involved in Post Production support and resolved production issues.

Actively Involved in Unit testing, integration testing of the mappings.

Creating Tables, Indexes, Triggers in Different Environments.

Created re-usable Sessions, non re-usable sessions, email tasks, Control tasks, and Link tasks and integrated the above in workflows.

Used TOAD to develop oracle PL/SQL, DDL’s, and Stored Procedures.

Used Union, Intersection, minus and Master/Detail in the source qualifier sequel overrides.

Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.

Written SQL overrides in source Qualifier according to business requirements.

Written pre session and post session scripts in mappings.

Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time with required frequency.

Extensively worked in the performance tuning of the programs, ETL Procedures and processes.

Developed PL/SQL procedures for processing business logic in the database.

Environment : Informatica 8.1/7.1, Oracle 9i, PL/SQL, SQL, Windows 2000, UNIX (sun Solaris)

Pfizer Inc. Kalamazoo, MI Jan 06 – Oct 07

Informatica Developer

Pfizer is one of the world’s leading providers of highest-quality pharmaceuticals and health care products. The project deals with building a data warehouse which will contain all the necessary information regarding customers, products and sales of the products. This information will be used for analysis and to improve the sales of the products.

Responsibilities:

Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.

Installed and configured Informatica 7.1

Migrated repository and mappings from Informatica 6.2 to 7.1

Extensively used ETL to load data from source systems like Flat Files, DB2, Oracle, COBOL, ODBC, Excel Files and CSV Files into staging tables and load the data into the target database Oracle.

Developed Informatica mappings, reusable transformations. Developed and wrote procedures for getting the data from the Source systems to the Staging and to Data Warehouse system.

Extensively used transformations to implement the business logic such as Sequence Generator, Normalizer, Expression, Filter, Router, Rank, Aggregator, LOOK UP (Target as well as Source), Update Strategy, Source Qualifier and Joiner.

Created New mappings or modified the existing mappings according to the requirement.

Created shortcuts to the required repository objects which are in development shared folder and used in mappings.

Designed complex mappings involving target load order and constraint based loading.

Create/build and run/schedule workflows and worklets using the Workflow Manager.

Optimizing/Tuning mappings for better performance and efficiency.

Optimized SQL and TSQL queries for better performance.

Creating and Running Batches and Sessions using the Workflow Manager.

Extensively used UNIX Shell scripts for conditional execution of the workflows.

Designed the daily, weekly, monthly, quarterly batches with complex dependencies and scheduled them.

Optimized the performance of Mappings, Workflows and Sessions by identifying and eliminating bottlenecks.

Performed Unit Testing at development level, Source code migration and documentation.

Worked with various DB objects like Materialized views, Stored Procedures, Functions, Sequence Generators and Partitions of Oracle, SQL Server, Sybase, DB2.

Performance Tuning of the Informatica Mappings and database by adopting Explain plans, cutting down query costs using Oracle hints, changing the mapping designs.

Creating Pre-session and Post-session shell scripts to disable and enable Indices.

Environment: Informatica Power Center 7.1.4, Power Exchange, Oracle 9i, DB2, SQL, PL/SQL, XML, ER Win4.5, TOAD, Solaris 5.8, Windpws XP professional.

Cardinal Health, Dublin, OH Aug 04 – Dec 05

Datawarehouse/Informatica Developer

Cardinal Health is the leading provider of products, services and technologies supporting the health care industry.The primary responsibility of my role in this project was to design and develop the ETL procedures to support the extraction, manipulation and insertion of data into a new Information System, which also included ensuring that all the data extractions from a number of key source systems conform to the local standards.

Responsibilities:

Involved in design and development of data warehouse environment, liaison to business users and/or technical teams gathering requirement specification documents and presenting and identifying data sources, targets and report generation.

Consolidate data from various departments into the data warehouse by identify the common data and solve the discrepancy on data values and created various data marts.

Worked on Informatica Power Center 6.2 tool - Source Analyzer, warehouse designer, MappingDesigner, Mapplet Designer, WorkflowManager, Repository Manager and Transformation Developer.

Using Informatica Designer designed Mappings, which populated the Data into the Target Star Schema on Oracle 8i Instance.

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

Created, launched & scheduled Workflows/sessions. Involved in the Performance Tuning of Mappings and Sessions.

OptimizedQueryPerformance, Session Performance and Reliability.

Extensively used Normalizer (for COBOL source files from S-390 Mainframe system), Router, Lookup, Filter, Union, Expression, Aggregator, Update Strategy Transformations.

Setup the data mart on Oracle database by running the SQL scripts from ERWIN designer.

Translation of Business processes into Informatica mappings for building Data marts.

Involved in the Migration process from Development, Test and Production Environments.

Automation of job processing, establish automatic email notification to the concerned persons.

Involved in Design, Development and Implementation of Enterprise Wide Reporting system using Cognos Suite.

Used SQL tools like TOAD to run SQL queries and validate the data.

Wrote stored procedures and triggers in Oracle 8i for managing consistency and referential integrity across data mart.

Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.

Worked with Informatica Best Practices guidelines to minimize performance issues.

Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.

Scheduled the batches to be run using the Workflow Manager.

Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.

Implemented Reporting solution using Cognos.

Created Catalogs using Cognos Impromptu, selecting/joining tables in Catalog, creating Folders, Subfolders and Calculations etc.

Created the reports of type crosstab, Drill down, Sub reports, Chart template, Summary reports etc.

Environment: Informatica Power Center 6.2/5.1, Sun Solaris 7, Oracle 8.i, SQL Server 2000, PL/SQL, T-SQL, SQL*Loader, Cognos, Erwin 3.5, Windows NT 4.0, Perl 5.x, Microsoft Excel 2000.

Contact this candidate