PROFESSIONAL SUMMARY

Around * years of experience in Information Technology with a strong background in Data Warehousing, Business Intelligence and ETL process using Informatica Power Center 9.1/8.x/7.x and Informatica Data Quality and Informatica Data Analyst tools and expertise skills in reporting using the Business Objects.

2+ years’ data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).

Extensive work experience in the areas of Banking, Finance, Insurance and Manufacturing Industries.

Extensively used ETL methodology for supporting of Extract, Transform, and Load environment using Informatica Power Center 8.x/7.1 (Designer, Repository manager, Repository Server Administrator console, Server Manager, Work flow manager, workflow monitor).

Extensive experience in using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer, Schedulers and Warehouse/Target Designer.

Expertise in Extracting and Transforming data using DTS in SQL Server 2000, SSIS in SQL Server 2005, SQL Server Import Export, Bulk Insert and BCP.

Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, Normalizer, Union, and XML Source Qualifier.

Highly experienced in developing, designing, reviewing and documenting Informatica work products like Mappings, Mapplets, Reusable transformations, Sessions, Workflows, Worklets, Schedulers and experienced in using Mapping parameters, Mapping variables, Session parameter files.

Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable transformations and Partitioning Sessions.

Analyzed and designed the database. Involved in database normalization process.

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

Proficiency in using Informatica Power Center tool to design data conversions from wide variety of sources

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

Extensively worked with SQL loader for bulk loading into the oracle database.

Strong in Data warehousing concepts, dimensional Star Schema and Snowflake Schema methodologies, fact and dimension tables and Dimensional modeling, OLAP and OLTP process.

Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.

Experience with SQL Plus and TOAD as an interface to databases, to analyze, view and alter data.

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

Highly adept at creation, execution, testing and debugging of Informatica mappings, mapplets, sessions, tasks, worklets and workflows in UNIX and Windows environment.

Excellent overall software Development life cycle (SDLC) experience, Conceptual and Logical thinking, Goal oriented, self-motivated and able to work independently and as a member of a team.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center/Power Mart 9.x/8.x/7.x, Power Exchange 8.x/9.x,Pentaho,Cognos

Business Intelligence: Business Objects 6.5/5.1.7, OBIEE 10.1.3.2/ 10.1.3.3/ 10.1.3.4

Databases: Oracle 11g/10g/9i/8i, SQL Server,

MS SQL Server 2000/2005/2008

Languages: UNIX, Shell scripting, SQL, PL/SQL, C

Web Technologies: HTML, DHTML, Joomla 1.6

Tools: MS Office Suite 2003, TOAD, SQL Plus, Autosys r11.x, SQL Developer Data Modeler

Operating Systems: UNIX, Windows 9x/2000/XP/VISTA, DOS

EDUCATION: Master's in Computers Applications from Osmania University, Hyderabad, India.

PROFESSIONAL EXPERIENCE

Sr. Informatica Developer, Maximus, Austin, TX Aug 16 – till date

Responsibilities:

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

Worked with the DBA for requirements gathering, business analysis and designing of the data warehouse.

Created Logical and Physical models for Staging, Transition and Production Warehouses using Erwin 4.0.

Used Repository manager to create user groups and users, and managed users by setting up their privileges and profile.

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

Created Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in efficient manner.

Converted Stored Procedures into Informatica, having knowledge in understanding views, indexes, parameters, variables and Synonyms.

Communicated with management, business resources, client resources, and staff to ensure effective development and deployment of requested changes, on time and delivered.

Used sorter transformation and newly changed dynamic lookup.

Developed Informatica mappings and also tuned them for better performance

with PL/SQL Procedures/Functions to build business rules to load data.

Worked with oracle CDC with Power Exchange and Oracle, SQL Server, CSV files as source system.

Worked extensively on Power Center Designer, Workflow Manager, and Workflow Monitor creating mapplets, mappings, tasks, reusable tasks, and workflows.

Have got good experience in Creation of parameter files, mapping variables, parameters and Scheduling jobs and implemented High Availability.

Having good knowledge in understanding UNIX work environment, file transfers, job scheduling and error handling.

Involved in Unit, Integration, System, and Performance testing levels.

Used PL/SQL with Informatica Power Center 9.6 for Oracle databases.

Developed mapping using Informatica Power Center Designer to normal load data from Oracle and Flat file source system to target database.

Configuring domains, adding repositories, communicating with Informatica environment team and DataMart team.

Setting ODBC Connection for different environments and databases.

Understanding the existing environment to start up ETL, developing the transformations in Pentaho (PDI) Kettle.

Monitoring the workflows in workflow Monitor and there performances in different environments.

Debugging the errors in session log, testing the code, fixing the Production issues and involved in Data migration, data Integration and deployments.

Testing the code in PL/SQl, involved in Performance tuning in oracle and in Informatica.

Environment: Informatica Power Center 9.6.1, Workflow Manager, Workflow Monitor, Informatica Power Connect /Power Exchange, Informatica B2B Data Exchange, Pentaho, Data Analyzer 8.1, PL/SQL, Oracle 11g/9i,SQL Server, SQL developer, Unix.

Sr. Informatica Developer, Veteran Affairs, Hines, IL Oct 14 – Mar 16

Responsibilities:

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

Profiled the data using Informatica Data Explorer (IDE) and performed Proof of Concept for Informatica Data Quality (IDQ).

Parsed high-level design specification to simple ETL coding and mapping standards.

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.

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

Designing and developing the ETL frame work and processes using Informatica 8.6.0, to run on the Domain, Integration Services and Nodes, on a Highly Available Grid ETL Infrastructure.

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

Designed Mappings using B2B Data Transformation Studio.

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

Developed mapping parameters and variables to support SQL override.

Experienced in scheduling Sequence and parallel jobs on Autosys Production and Lower environments using UNIX Perl scripts.

Understanding web application based on J2EE Struts framework.

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

Used existing ETL standards to develop these mappings.

Worked on Informatica B2B Data Exchange that allows supporting the expanding diversity of customers and partners.

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

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

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

Two years’ experience in configuring and testing Hadoop ecosystem components.

Environment: Informatica Power Center 8.6.1, OBIEE 11g, Workflow Manager, Workflow Monitor, Informatica Power Connect /Power Exchange, Informatica B2B Data Exchange, Business Objects Data Services 4.0, Data Analyzer 8.1, PL/SQL, Oracle 10g/9i, Erwin, Autosys, SQL Server 2005, Teradata.

ETL Consultant, XL Global Services Inc, Stamford, CT May 13 - Sep 14

Responsibilities:

Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA

Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.

Using Informatica Power Center created mappings and mapplets to transform the data according to the business rules.

Developed strategic planning, mapping and staging of a very large data conversion project.

Used various transformations like Source Qualifier, Joiner, Lookup, SQl, and router, Filter, Expression and Update Strategy.

Involved in writing stored procedures to check the conversion errors.

Extracted data from Oracle and migrated into SQL Server 2005 using SSIS.

Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools.

Documented Informatica mappings in Excel spread sheet.

Tuned the Informatica mappings for optimal load performance.

Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.

This role carries primary responsibility for problem determination and resolution for each SAP application system database server and application server.

Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.

Constantly interacted with business users to discuss requirements.

Environment: Informatica Power Center Designer 8.6/8.1, Business Objects Data Services 4.0, Informatica Repository Manager, Oracle10g/9i, DB2 6.1, Erwin, TOAD, SAP Version: 3.1.H, Unix- SunOS, PL/SQL, SQL Developer.

Sr. ETL/Informatica Developer, U.P.M.C, Pittsburgh, PA Jan 12 – Mar 13

Responsibilities:

Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.

Designed ETL specification documents for all the projects.

Created Tables, Keys (Unique and Primary) and Indexes in the SQL server.

Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.

Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.

Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.

Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.

Extensively used the Add Currently Processed Flat File Name port to load the flat file name and to load contract number coming from flat file name into Target.

Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.

Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.

Extensively used workflow variables, mapping parameters and mapping variables.

Created sessions, batches for incremental load into staging tables and scheduled them to run daily.

Implemented Informatica recommendations, methodologies and best practices.

Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.

Involved in Unit, Integration, System, and Performance testing levels.

Written documentation to describe program development, logic, coding, testing, changes and corrections.

Migrated the code into QA (Testing) and supported QA team and UAT (User).

Created detailed Unit Test Document with all possible Test cases/Scripts.

Conducted code reviews developed by my team mates before moving the code into QA.

Provided support to develop the entire warehouse architecture and plan the ETL process.

Modified existing mappings for enhancements of new business requirements.

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

Worked on production support.

Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.

Environment: Informatica Power Center 9.1.0, Oracle 11g, SQLServer2008, IBM I Series (DB2), MS Access, Windows XP, Toad, Tidal, SQL developer.

ETL Developer, TNS Global Market Research Company, Hyderabad, India Aug 09 - Oct 11

Responsibilities:

Developed mappings in Informatica Power Center 6.1that catered to the Extraction, Transformation, and Loading from various source systems to target systems.

Used Informatica tool to handle complex Mappings and extensively used the various Transformations like Source Qualifier, Aggregators, Lookups, Filters, Update Strategy, Expression, Sequence generator and Sorter etc.

Used Informatica Power Center 6.1for mapping and workflow design including the use of mapplets, reusable transformations and worklets.

Extensively used workflow manager to create tasks and workflows.

Used PL/SQL with Informatica Power Center 6.1for Oracle 8i database.

Developed mapping using Informatica Power Center Designer to bulk load data from Oracle and Flat file source system to target database.

Used Informatica tool to handle complex mappings and extensively used various Transformations including Source Qualifier, Aggregators, Lookups, Filters, Update Strategy, Expression, Sequence generator and Sorter.

Developed, implemented and enforced ETL best practices standards.

Environment: Informatica Power Center 6.1, Flat files, Oracle 8i, BO 5, Windows 2000

Contact this candidate