Professional Summary

• 8 years of experience in the Information Technology industry and wide range of progressive experience in providing product specifications, design, analysis, development and documentation.
• Over 7.5 years of Extensive Data Warehouse experience using Informatica Power Center / Power Mart Source Analyzer, Repository Manager, Mapping Designer, Mapplet Designer, Transformation Designer as ETL tool
• Expertise in implementing in Change Data Capture CDC using Mapping Parameters and Mapping Variables
• knowledge in B2B Data Transformations studio, XML Parser Transformation
• Technical and analytical skills with clear understanding of design goals of ER Modeling and Dimension Modeling
• Working knowledge in dealing with Oracle Golden Gate source files
• Expertise in Data Warehousing Concepts like OLAP, ROLAP, MOLAP, HOLAP, EDW, Data marts, Ralph Kimball Methodology, Bill Inmon Methodology, Star Schema, Snow Flake Schema, Normalization, Dimensions, Facts.
• Experience in integration of various data sources like Oracle, DB2, MS SQL Server, Flat Files, and XML files.
• Experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, mappings and sessions. Hands on experience in optimizing SQL scripts and improving performance loading warehouse
• Developed Slowly Changing Dimension mappings of Type1, Type2 and Type3 version, flag and time .
• Very strong in writing SQL Joins, Nested Queries, Unions, Multi-table joins.
• Expertise in using SQL LOADER to load Data from external files to Oracle Database.
• Performance tuning of Informatica Sources, Targets, Mappings and Sessions.
• Working Knowledge in Data Analyzer tools like Informatica Power Exchange.
• Experience in various Teradata loading utilities viz. Fast Load F Load , Multi Load M Load , T Pump, TPT Teradata Parallel Transporter wizard.
• Experience in Software life cycle development using agile methodology.
• Proficient in processing tasks, scheduling sessions, import/export repositories, manage users, groups, associated privileges and folders.
• Experience in coding using SQL, PL/SQL Procedures/Functions, Triggers and Packages
• Excellent problem solving skills with a strong technical background and good communication skills.
• Ability to work in teams as well as individually, quick learner and able to meet deadlines.
• Experienced in Batch Processing and Autosys.
• Implemented performance tuning techniques at Informatica objects and Database level.
• Expertise in understanding design of Fact Tables, Dimension Tables, Summary Tables.

Professional Experience

Confidential

Sr. Informatica Developer

Technology: Data warehouse, oracle, Teradata, sql, UNIX.

Tools: Informatica 9.1, Teradata V13, Teradata SQL Assistant, PUTTY, TOAD, HP Quality Center, Oracle Golden Gate,TIDAL.

Responsibilities:

• Involved in complete understanding of business requirement and involved in analyzing the sources to load in Teradata warehouse using multiple utilities.
• Designed Sources to Targets mappings from Oracle, Excel/Flat files, Xml Files to Teradata using Informatica Power Center Data cleansing, integrating, and matching using Informatica mapplets.
• Responsible for working with DBA and Data Modelers for project coordination.
• Responsible for creating Technical Design document TDD and Rapid Impact document RIA to capture the requirement and transform business requirement into technical requirement.
• Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Data.
• Implemented Slowly Changing Dimension SCD Type 1 and Type 2 for Change data capture.
• Responsible for Error Handling in Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Used Informatica Developer Tool to perform data profiling on source data to figure out the quality of data in terms of Uniqueness, Null data, Min-Max Data range.
• Wrote test plans and executed it at UNIT testing and also supported for system testing, volume testing and User testing.
• Doing Change Requirement for complex Informatica Mappings with transformations like lookup, router, aggregator, expression, update strategy, joiner and etc.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Created sessions, worklets, workflows for the mapping to run daily, biweekly based on the business requirements.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Worked on handling performance issues of Informatica Mappings, evaluating current logic for tuning possibilities.
• Involved in triggering the various Teradata loading utilities viz. Fast Load, M Load, T Pump, TPT.
• Involved in unit testing and fixing the bugs identified, provided data to the reporting team for their daily, weekly, monthly and quarterly reports.

Confidential

Sr. Informatica Developer

Technology: Data warehouse, oracle, PL-SQL, SQL, UNIX.

Tools: Informatica 9.1, Oracle 11i, TOAD, PUTTY, Control-M.

Responsibilities

• Extracted data from various sources like Oracle and flat files using Informatica
• Responsibilities included source system analysis, data transformation, loading, validation for data marts and data warehouse.
• Performed tuning of SQL queries for speedy extraction of data.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, joiner, aggregate transformation and expression.
• Employed highly complex data transformations including Slowly Changing Dimensions.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Worked on the Workflow Manager to run several sessions and worklet concurrently and sequentially.
• Scheduled the sessions and worklet to run at specified intervals.
• Mappings were designed to the utmost performance by optimizing expressions in expression editor of transformation, filtering source data at the source qualifier, and applying transformation logic.
• Implemented various Dimensions that are tied to central fact table

Confidential

Sr. Informatica Developer

Technology : Data warehouse, oracle, PL-SQL, SQL, UNIX.

Tools : Informatica 8.6.1, Oracle 10g, TOAD, PUTTY, Autosys.

Responsibilities

• Responsible for requirement gathering, Business Analysis, user meetings, discussing the issues to be resolved and translated the user inputs into ETL design documents.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Sybase and Flat files.
• Designed and built various data marts/fact tables/dimension tables using Kimball Dimensional Modeling approach along with data architecture design and modifications as per requirement.
• Responsible for reconciliation of the loaded data to see whether it is according to the business needs.
• Worked with power center tools like Designer, Workflow Manager, Task Developer, Workflow Monitor, and Repository Manager
• Extensively used Source Qualifier Transformation and used most of its features like filter, sorter and SQL override
• Extensively used various Active and Passive transformations like Filter, Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, Lookup Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation and Aggregator Transformation
• Extensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer join in the Joiner transformation.
• Worked with Index cache and Data cache in transformations like Rank, Lookup, Joiner and Aggregator Transformations.
• Expertise in using TOAD and SQL developer for accessing the Oracle database.
• Responsible for Creating Users, Groups, Roles and Privileges by acting as an Informatica Administrator
• Responsible for Unit Testing of Mappings and Workflows.

Confidential

Informatica Developer

Technology : Data warehouse, oracle, PL-SQL, SQL, UNIX.

Tools : Informatica 9.1, Oracle 11i, TOAD, PUTTY, Control-M.

Responsibilities

• Involved in Requirement Analysis, ETL Design and Development for extracting the data which is stored in different sources like Oracle, SQL Server, and Sybase.
• Analyzed, designed and developed an environment that would facilitate the use of Informatica to transform data coming from OLTP into datamarts and used IDQ for cleansing and matching.
• Developed complex Informatica Mappings with transformations like lookup, router, aggregator, expression, update strategy, joiner and etc.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Created Sessions, Worklets, Workflows for the mapping to run daily, biweekly based on the business requirements.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Worked on handling performance issues of Informatica Mappings, evaluating current logic for tuning possibilities.
• Created and executed unit test cases for various scenarios for all the mappings, workflows and scripts.
• Involved in unit testing and fixing the bugs identified, provided data to the reporting team for their daily, weekly and monthly reports.
• Worked on modification of UNIX shell scripts.
• Involved in weekly team status meetings from the offshore-onsite team members.

Confidential

Informatica Developer

Technology : Data warehouse, Oracle, SQL Server, UNIX Shell Scripting.

Tools : Informatica 7.1.3, Oracle 9i, SQL, TOAD, PUTTY.

Responsibilities

• Configured Informatica Repository Manager to manage all the repositories of various applications.
• Created users, user groups, security access controls.
• Planned and designed the flow process of the data stored in the repository, in the form of metadata.
• Designed and constructed the Star Schema.
• Wrote procedures, functions in PL/SQL.
• Designed and created mappings using Mapping Designer.
• Worked extensively on performance tuning by making changes to SQL in Source Analyzer.
• Used various Informatica transformations like expressions, filters, joiners, aggregators, routers and lookups to load better and consistent data into the targets.
• Used Mapping Designer to join tables from various databases like Oracle, SQL Server, and DB2.
• Designed and developed catalogs by creating links between the Fact table and the Dimension table to form a Star Schema.
• Used TOAD to FTP file moving processes to and from source systems.
• Created scheduling of jobs in Workflow Manager to trigger tasks on a daily, weekly and monthly basis.
• Wrote shell scripts to join or concat target files, to delete or remove one or more such files if not needed after joining, and etc.
• Monitored the production loads and fixed them, when necessary.
• Involved in the Performance Tuning of Informatica servers and other legacy databases.