Summary:

Highly motivated and goal-oriented professional committed to pursuing a responsible career opportunity in which I can successfully utilize my technical as well as my managerial skills towards the set objective with exceptional organizational ability and communication skills.Around 9 Years of IT experience in analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehousing/Data mart design, ETL, OLAP client /server applications.

• Experience in using Informatica Client tools: Power Center Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Experienced with all phases of Software Development Life Cycle SDLC such as developing, testing, migrating, administrating, and production supporting on various platforms like UNIX, Window XP/7.
• Experience in gathering, analyzing and documenting business requirements, functional requirements, designing and developing the mapping based on the requirements.
• Experienced in implementing the business rules by creating transformations Expression, Aggregate, Unconnected and Connected Lookup, Router, Update Strategy, Filter, Joiner, Union , and developing Mappings.
• Strong knowledge on Data warehousing concept, Data mart, Star Schema and Snow Flake Schema modeling, Fact tables and Dimensional tables.
• Implemented Slowly Changing Dimension methodology for accessing the full history of accounts and transaction information.
• Experience in the concepts of building Fact Tables, Dimensional Tables, handling Slowly Changing Dimensions and Surrogate Keys.
• Experience using Teradata utilities SQL,FastLoad, MultiLoad, FastLoad, Tpump .
• Experience in Migration of objects between environments, from Local DEV to Test QA .
• Experience in writing complex SQL queries, simple stored procedures and Unix Shell Scripting.
• Good experience in developing complex reports using Crystal Reports from different Data Sources.
• Excellent experience in Performance tuning in Informatica Power Center and query optimization.
• Experienced in data extraction, transformation and loading data using Informatica Power Center 9.1.
• Strong knowledge on Relation databases like Oracle 9i/10g/11g, SQL SERVER, TERADATA on different platforms like Windows/Unix Linux using GUI tools like TOAD, SQL DEVELOPER, SQL PLUS, SQL PLUS, MICROSOFT VISUAL.
• Analytical and Technical aptitude with the ability to solve complex problems.
• Experience in OLAP tools such as Business Objects, Crystal Reports Designer and Reporter
• Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter in Windows.
• Experience in installation and configuration of core Informatica MDM Hub components such as Hub Console.
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Used Teradata utilities like MultiLoad, Tpump, and Fast Load to load data into Teradata data warehouse from Oracle and DB2 databases.
• Created BTEQ scripts to extract data from warehouse for downstream applications.
• Worked in data Extraction, Transformation and loading from source to target system using Bteq, FastLoad, and MultiLoad.
• Designed the ETL processes to extract, transform and load data from multiple input sources like Oracle, flat files, DB2 to target Teradata database.
• Strong interpersonal skills with ability to interact with end-users, managers and technical personnel.
• Trained and assisted End Users in developing Ad Hoc reports.
• Involved in Unit Testing, Integration testing and QA Validation
• Have experience in using Informatica Workflow Manager to create Sessions, Batches and schedule workflows and Worklets.
• Extensive experience in Database Performance Tuning, Imports and Exports.
• Experience in gathering business requirements, establishing functional specifications and translating them to design specifications.
• Hands on experience in Optimizing Database querying, data manipulation and population using SQL and PL/SQL in Oracle, Teradata V2R6.2, DB2, SQL Server and Sybase databases.
• Efficient in writing SQL scripts, PL/SQL, Stored Procedures, Functions, Triggers and Shell Scripting.

Technical Skills:

• ETL/DWH Tools: Informatica Power Center 9.1/8.6/8.x/7.x
• Databases: Oracle: 11g, 10g, 9i, 8i
• Microsoft: MS Access, SQL Server 2005/2008,DB2,Teradata 14
• DBMS/Query Tools: TOAD, Rapid SQL, SQL Developer, WinSQL, SQL Assistant, SQL Navigator, PL/SQL Developer. PMON.
• Operating Systems: Microsoft Windows - Vista, XP, 2000, NT 4.0, OS/2 UNIX - Sun Solaris, HP-UX
• Programming Lang: SQL, PL/SQL, UNIX Shell Scripting, T-SQL, VB Script, Java, C, C .
• BI/Reporting Tools: Business Objects 5.1/4.x, Cognos, Crystal Reports 8.5
• Defect Tracking: Rational Clear Quest CQ , HP Quality Center,Jira
• Data Analysis: Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Other Tools: Compare IT, Putty, WinSCP

Professional Experience:

Confidential

Sr Informatica Developer

The goal of the project is to provide an enhanced data load process and adhoc reporting capabilities. Extensively worked to implement CSP Common Securitization Platform and worked on bringing Legacy data from Different source systems like Flat files and Mainframe data.Accumulated and documented functional requirements as part of updating functional specifications. Success in achieving these goals will provide a sound and flexible operating environment in the shorter term and help provide policy makers with the means to design a mortgage finance system unfettered by legacy process and systems and capable of working well with or without various degree of government involvement.

Responsibilities:

• Extensively worked with Source Qualifier Transformation to join the homogeneous sources
• Extensively worked with Joiner Transformation to join the heterogeneous sources
• Worked with various Databases for extracting the files and loading them into different databases
• Designing the ETLs and conducting review meets.
• Loaded the data into the XML and Flat files
• Used stored procedures to call Webservices.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Responsible for migrate the workflows from development to production environment
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.
• Modified Unix Shell Scripts for executing the Informatica workflows.
• Extensively worked on Informatica Designer components Source Analyzer, Target Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Developed various mappings to load data from various sources using different Transformations including Router, Aggregator, Joiner, Lookup, Update Strategy, Stored Procedure, Sorter, Filter, Source Qualifier, Expression, Union and Sequence Generator to store the data in target tables.
• Developed mapping based on the mapping specification document that indicates the source tables, columns, data types, transformation required, business rules, target tables, target columns and data types.
• Extensively worked with Slowly Changing Dimensions Type1, Type2, for Data Load
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level, and the Target Level
• Involved in writing Stored Procedures in SQL and extensively used this transformation in writing many scenarios as per the requirement
• Involved in Unit Testing, Integration Testing and End-End Testing

Environment: Informatica PowerCenter 9.1, SQL Server Integration Services SSIS , Oracle 11g, MS Access 2010, SQL Loader, Unix, Winscp, Putty, Erwin, DB2, SQL, PL/SQL

Confidential

Sr Informatica Developer

The goal of the project is to provide an enhanced data load process and for the selected Business Users for the Provider Data group repository. It also includes a redesign in the existing schema for the new business requirement.

Responsibilities

• Worked with various Databases for extracting the files and loading them into different databases
• Designing the ETLs and conducting review meets.
• Played a lead role in managing the offshore team.
• Worked mainly on troubleshooting the errors which were occurred during the loading process
• Used Teradata utilities like MultiLoad, Tpump, and Fast Load to load data into Teradata data warehouse from Oracle and DB2 databases.
• Loaded the data into the Teradata database using Load utilities like Fast Load, MultiLoad, and Tpump .
• Extensively worked on creating mapping parameters and variables which are used in various workflows for reusability
• Worked with various active transformations in Informatica Power Center like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation
• Extensively worked with various Passive transformations in Informatica Power Center like Expression Transformation, and Sequence Generator
• Extensively used MS View for creating many tables and altering them in SQL database
• Extensively worked with Source Qualifier Transformation to join the homogeneous sources
• Extensively worked with Joiner Transformation to join the heterogeneous sources
• Extensively worked with both Connected and Un-Connected Lookups
• Extensively worked with Look up Caches like Shared Cache, Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations
• Worked with re-usable objects like Re-Usable Transformation and Mapplets
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last in the Aggregator Transformation
• Extensively used SQL Override function in Source Qualifier Transformation
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Responsible for migrate the workflows from development to production environment
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.
• Written Queries, procedures, created Indexes, primary keys and data bases testing.
• Defects were tracked, reviewed and analyzed.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.

Environment: Informatica PowerCenter 9.1, SQL Server Integration Services SSIS , Oracle 11g,Teradata 14, MS

Access 2010, SQL Loader, Unix, Winscp, Putty, Erwin, SQL, PL/SQL

Confidential

Sr Informatica Developer

The goal of the project was to develop an enterprise data warehouse to implement a centralized database that collects, organizes and stores data from different operational data sources to provide a single source of integrated and historical data for the purpose of reporting, analysis and decision support and also to improve the client services. Business users can see five years of historical monthly snapshot data on every account. The data is integrated from sources like flat files and loaded into a central data warehouse, which is DB2 Database using transformation.

Responsibilities:

• Worked closely with the business analyst and Data warehouse architect to understand the source data and need of the Warehouse.
• Involved in designing of star schema based data model with dimensions and facts.
• Created mappings with heterogeneous sources like flat files, MS Access, Oracle databases and created targets in Oracle data warehouse using Informatica PowerCenter 8.6.2.
• Created Source to Target mapping from design and requirement documents.
• Built reusable transformations for recurring business logics using mapplets and used them in multiple mappings.
• Designed and developed mappings using Source qualifier, Aggregator, Joiner, Lookup, Router, Sequence generator, Expression, Filter and Rank transformations.
• Designed and developed test cases for unit and system testing.
• Modified Unix Shell Scripts for executing the Informatica workflows.
• Created a global schema with common source and target table to be used across different data marts and implemented shortcuts to the objects within each mart folder so that it is easy to maintain and control the changes to the source and targets.
• Created parameters and variables for incremental data loading effectively using Informatica workflow manager.
• Created event raise, event-wait tasks for maintaining dependencies between workflows.
• Efficiently interacted with UAT team and supported system testing and fixed bugs in mappings during QA phase.
• Optimized or tuned mapping/ sessions during load testing in QA environment.
• Designed, developed, and tested various enhancements.

Environment: Informatica Power Center 8.x, Oracle 9i, Autosys 4.5, XML, SQL Plus, PL/SQL, SQL, Shell Scripts

Confidential

Informatica Developer

Confidential one of four biggest wireless service providers in Confidential. Company's agenda was to get reporting for TPR Locations in the markets. T-Mobile wanted its partner retailers to be up-to date with their performance including sales, promotions, inventory, and employee commissions being paid to them.

Responsibilities:

• Involved in interacting with Business Analyst in analyzing the requirements
• Involved in documenting the Technical and Functional Documents like High Level Design, Low Level Design and System Specification Document.
• Developed ETL mappings, Transformations and Loading using Informatica Power Center 8.6.2/9.1
• Extensively Performed the data validations and profiling using IDQ
• Extensively worked on Informatica Designer components Source Analyzer, Target Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Developed various mappings to load data from various sources using different Transformations including Router, Aggregator, Joiner, Lookup, Update Strategy, Stored Procedure, Sorter, Filter, Source Qualifier, Expression, Union and Sequence Generator to store the data in target tables.
• Developed mapping based on the mapping specification document that indicates the source tables, columns, data types, transformation required, business rules, target tables, target columns and data types.
• Involved in Unit Testing, Integration Testing and End-End Testing
• Captured the Unit Test Results and documented the test results.
• Used workflow manager to create workflows, sessions, and also used various tasks like command, email.
• Created Workflows, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Developed Stored Procedures and modified some of the procedures based on the requirement
• Modified existing Unix Shell Scripts as per the requirements.
• Utilized SQL-Loader to import data.
• Designed and implemented Oracle 10g database object to support interface Table, views, materialized views .
• Writing PL/SQL packages, stored procedures and functions using new PL/SQL features like Collections, Objects, Object Tables, Nested Tables, External Tables, REF Cursors, MERGE, INTERSECT, MINUS, BULK INTO and Dynamic SQL commands.
• Defined Target Load Order Plan for loading data into different Target Tables.
• Involved in database level optimization by creating Indexes, Hints and Query Optimization.
• Involved in fixing the defects that are issued in JIRA and then Unit Tested the defects once fixed.
• Used debugger extensively to identify the bottlenecks in the mappings.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Worked on performance tuning and optimization of the Sessions, Mappings, Sources and Targets.
• Used Informatica Power Center 9.1 for mapping and workflow design including the use of mapplets, reusable transformations and worklets.
• Developed mapping using different source systems like Database, Flat File.
• Migrated Objects, mappings, workflows from Dev environment to QA environment.
• Created Informatica supported source definition for IMS log files using cobalt copy book in Informatica Power Exchange tool.
• Replicated operational tables into staging tables, to transform and load data into one single database using Informatica.

Environment: Informatica PowerCenter 8.6 Repository Manager, PowerCenter Designer, Workflow Manager, Workflow Monitor ,Informatica, Oracle 10g, Unix, Window 7/XP, JIRA, AUTOSYS, SQL Developer 3.0, Flat Files, SQL, PL/SQL, Informatica Power Exchanger, IMS logfiles, Microsoft tools, Putty, Winsc

Confidential

Informatica Developer

Financial Accounting system was developed for the Confidential. The overall system involves designing and standardizing the main and sub account heads for the 3 main divisions of the university i.e. education, research and extension and all the sub heads with in the main account heads.

Responsibilities:

Provided a data model for each of the different products that are offered by the Bank such as ATM Cards, Visa Charge Cards, Credit Cards, Internet Banking, Personal Loans

• Defined and captured metadata and rules associated with ETL process
• Participated in the detailed requirement analysis and designed data marts and star schemas
• Designed data extract layouts i.e. data fields that will be loaded from these sources to the staging area in the data warehouse environment
• Created mapping routines, which will map data from Bank data source to Data warehouse
• Worked on ETL specification, design and implementation using Informatica and PL/SQL
• Designed number of mappings with complex transformations using Informatica
• Involved in performance tuning and monitoring both SQL and Informatica considering the mapping and session performance issues
• Performed job scheduling using Informatica

Environment: Oracle 8i, SQL, PL/SQL, SQL Plus and SQL Loader.