PROFESSIONAL SUMMARY:

• 7+ of experience in System Analysis, Design and Development in the fields of database, data warehouse, client server technologies.
• Five years of extensive experience in Data warehousing tools including Informatica, Oracle - 9i-10g, TeraData, SQL, PL/SQL databases.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modelling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modelling.
• Involved in the full life cycle of the data warehouse building process including dimensional modelling, ETL and Migration primarily using Informatica Power Center 8.6.x.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner Update Strategy and more.
• Extensive experiences in using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer and Warehouse Designer.
• Experience in performance tuning of sources, mappings, targets and sessions.
• Extensive experience in Relational Database Systems like Oracle, SQL Server, TeraData, design and database development experience with SQL, PL/SQL, SQL PLUS, Stored procedures, triggers.
• Knowledge of developing business mix reports, variance reports and exception reports using COGNOS.
• Good in UNIX, shell scripting.
• Highly motivated, result oriented professional with a short learning curve and excellent communication skills.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Centre 7.X/8.X/9.X (Source Analyzer, DWH Designer, Mapping Designer, Mapplets, Transformations, Workflow Monitor, Workflow Manager), Designer, ETL.

Data Modelling: Star-Schema Modelling, Snowflakes Modelling, FACT and dimension tables

Databases: Oracle 10g,9i/8.x, Microsoft SQL Server 2000/2005/2008, DB2, MS-Access, Teradata V2R5

Operating Systems: Windows 98, MS Windows NT/2000/2003, NT 4.0, XP, Vista, 7.x, Red Hat Linux, Sun Solaris, UNIX

Languages: PL/ SQL, T-SQL, SQL

Tools & Utilities: SQL* Plus, Erwin 4, SQL Navigator, TOAD

PROFESSIONAL EXPERIENCE:

Confidential, Mooresville, NC

Sr. Informatica Developer

Responsibilities:

• Responsible for gathering the requirements both functional and technical and documentation.
• Extensively used the Power Center client tools Designer, Workflow Manager, and Workflow Monitor
• Extensively worked with various Active transformation like Filter, Sorter, Aggregator, Router, and Joiner transformations
• Extensively worked with various Passive transformations like Expression, Lookup, Sequence Generator, Mapplet Input, and Mapplet Output transformations
• Worked with the Joiner transformation using Normal Join, Master outer join, Detail Outer Join, and Full Outer Join
• Worked with Connected look up and un connected lookup and configured the same for implementing complex logic
• Experienced in various look up cache like Dynamic Cache, Static Cache, Persistent Cache, Re Cache from database, and Shared Cache
• Used transformations like Router, Sorter, Connected Lookup, update strategy, Expression, Aggregator and Joiners.
• Created re-usable transformations and mapplets
• Have experience in debugging and performance tuning of mappings
• Responsible for gathering functional specifications and converting it into mapping documents.
• Used SQL overrides, and Lookup overrides.
• Involved in creating Unix shell scripts
• Used various data cleansing functions in Informatica and data conversion functions.
• Worked along with QA team to fix the defects

Environment: Informatica Power Center 9.0.1 (Designer, Work Flow Manager, Work Flow Monitor, Repository Manager), DB2, SQL Scripting, UNIX Shell Scripting, SQL Server, TOAD, Windows XP

Confidential, Pasadena, CA

Informatica Developer

Roles and Responsibilities:

• Designed the ETL processes using Informatica Power center 9, 8.6.1 to load data from MS SQL Server, MS Access and Excel spreadsheet into the target Oracle database
• Extensively worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications.
• Prepare detailed design documentation by adhering to CMMI standards.
• Load monthly load, track issues and resolve them based on the priority.
• Extracted the data from the flat files and other RDBMS databases like DB2 into staging area and populated onto Data warehouse.
• Used Informatica Power Connect for SAP to pull data from SAP R/3.
• Developed number of complex Informatica mappings, Mapplets, reusable transformations to implement the business logic and to load the data incrementally.
• Developed Informatica mappings by usage of Aggregator, SQL Overrides in Lookups, Source filter in Source Qualifier, and data flow management into multiple targets using Router transformations.
• Worked with Informatica MDM to Resolve Inconsistent and Duplicate Data to Support Strategic Goals.
• Worked with Informatica power exchange tools to give on demand access to the business users.
• Designing and creating data quality plans as per the requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Designed and built Relational Databases.
• Used Control-M to automate Job scheduling.
• Used Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.
• Monitor and troubleshoot batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Developed UNIX shell scripts to move source files to archive directory.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Involved in Unit, Integration, system, and performance testing levels.
• Created documentation for all the mappings and uploaded documentation in company’s web portal

Environment: Informatica Power Center 9,8.6.1, IDQ, IDE, Power Exchange, Ms SQL Server, Oracle 10G, SQL Server 2000, ADVANCED SQL, PL/SQL, SQL* Loader, Control - M, Erwin 4.5, TOAD 7.0, Star Schema, UNIX Shell Scripts, Flat files, Windows server 2003, and MS-Office tools.

Confidential, Princeton, NJ

Sr. Informatica Developer

Roles and Responsibilities:

• Worked with the business analysts in requirement analysis and technical specification preparation to implement the ETL workflow procedures and process.
• Extensively used all standard ACTIVE, PASSIVE, Re-Usable and non-reusable transformations, session, Workflows and all other critical components involved in a typical ETL project development
• Responsible for scheduling, interfacing with SAP system, interfacing with Business Objects Reporting platform by hand-shaking the ETL Informatica batch with BORP platform
• Involved in setting up a automatic restart production support mechanisms where some of the most common batch failures are handled by the TWS OPC scheduler itself (in other words without manual intervention)
• Stream lined, structured and effectively optimized the monthly data warehouse process which involves delivering 60+ reports to 16 countries on last day of the month
• Extensively worked with performance tuning at mappings level like implementing active transformation like filter as early as possible in the mappings.
• Involved in support of 500+ Informatica objects
• Worked extensively with update strategy transformation for implementing inserts and updates
• Worked with connected lookup and un-connected lookup.
• Extensively used all common Informatica 8.6 transformations, mapplet’s with standard process and procedures

Environment: Informatica Power Center 8.6 (Designer, Work Flow Manager, Work Flow Monitor, Repository Manager), IBM Z/OS, DB2, SQL Scripting, UNIX Shell Scripting, Microsoft Visio, SQL Server, TOAD

Confidential, Seattle, Washington

Informatica Developer

Roles and Responsibilities:

• Developed ETL mappings, Transformations and Loading using Informatica Power Centre 8.1.0.
• Developed mappings and workflows as per business logic, quality and coding standards prescribed for the module using Informatica Power Center8.1.0.
• Conducted performance tuning to increase performance of the mappings, sessions & workflows.
• Used PL/SQL with Informatica Power Centre 8.1.0 for Oracle 9i database.
• Developed mapping document indicating the source tables, columns, data types, transformation required, bulk loading routines, business rules, target tables, columns and data types.
• Performed project management duties including analysis, design, and implementation of Extraction, Transformation and Loading methodologies.
• Additional project management duties included preparing Low Level Design (LLD) documents as per the business requirements and Unit Test Plan (UTP) documents for all test cases for developed mappings.
• Developed, implemented and enforced ETL best practices standards.
• Created and Implemented Reusable Sessions like E-mail.
• Involved in Data modelling team for developing Star Schema
• Developed application using UNIX operating system including scripting.

Environment: Informatica power centre 8.1.0, TERADATA warehouse 8.1, Oracle10g, TOAD, SOLARIS UNIX, ERWIN.

Confidential, Woonsocket, RI

Informatica Developer

Roles and Responsibilities:

• Analyzed the requirements to identify the necessary tables dat need to be populated into the staging database.
• Developed ETL mappings, Transformations and Loading using Informatica Power Centre 7.1.2.
• Developed mappings and workflows as per business logic, quality and coding standards prescribed for the module using Informatica Power Centre 7.1.2.
• Developed, implemented and enforced ETL best practices standards.
• Performance tuning and bottleneck resolution.
• Created mappings using transformations like Source Qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, Union, and Stored procedure, and XML transformations.
• Worked on Informatica Power Centre tools - Source Analyzer, Warehouse Designer, Mapping & Mapplet Designer, and Transformation Developer.
• Converted existing PL/SQL Packages to ETL Mappings using Informatica Power Centre.
• Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
• Wrote Unix Shell scripts to automate workflows.
• BTEQ, Multiload, Fast Load and Fast Export scripts were created as needed for data migration and ongoing data load.
• Designed Multiload scripts to load data into multiple tables based on Multiload Layout Labels.
• Schedule and Run Extraction and Load process, monitor task and workflow using the Workflow Manager and Workflow monitor.
• Used Workflow Manager for creating workflows, work lets, email and command tasks.
• Implemented Type I, II changes in slowly changing dimension tables.
• Used FTP connection objects to retrieve Flat Files from the external sources.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Worked on Migration Strategies between Development, Test and Production Repositories.
• Developed mapping document indicating the source tables, columns, data types, transformation required, bulk loading routines, business rules, target tables, columns and data types.
• Resolved issues and bugs raised by QA team.
• Involved in Data modelling team for developing Star Schema

Environment: Informatica power centre 7.1.2, Sybase, Flat files, Oracle9i, DB2, TOAD, Windows XP, and UNIX & MS Visio.

Confidential, Auburn Hills, MI

ETL/Informatica Developer

Roles and Responsibilities:

• Interacted with business user in the analysis and development phase and was involved in requirement gathering, prepared various documents like Technical design documents, Integration test plan, unit test plan and resolved business related issues.
• Worked closely with System Analyst to identify various tables and the layout of data, understanding the complex business rules, identify appropriate sources for Data warehouse, document business needs and implementing the data transformation methodology.
• Extracted data from variety of sources like mainframe tables, flat files, SQL Server and loaded to the data warehouse.
• Developed reusable mappings, mapplets, sessions and work lets.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
• Creating Test cases for Unit Test, System Integration Test, check the data quality issues, removing defects and to ensure the successful execution of data loading process.
• Responsible for monitoring all the sessions dat are scheduled, running completed and failed. Involved in debugging the Mappings dat failed and fixing.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Worked on databases implementing complex table joins, aliases, views, aggregate conditions to implement business logic.

Environment: Informatica 7.x (Power Mart/ Power Center), Power Connect, Db2, Oracle 9i, PL/SQL, Teradata, SQL*Plus, SQL Server 2000, Windows NT 4.0A

Confidential, Alpharetta, GA

Informatica Developer

Roles and Responsibilities:

• Performed data analysis of the source data coming from point of sales systems (POS) and legacy systems.
• Developed mappings using Informatica 7.x designer to extract data from the source databases and flat files into oracle staging area.
• Developed transformation logic to cleanse the source data of inconsistencies during the source to stage loading.
• Implemented the business rules and logic by using Expression, Look up, Sequence Generator, Aggregator, Joiner, Router and Update Strategy transformations.
• Created session task work let sets and workflows to execute the mappings.
• Involved in the migration of the project from development to production.
• Involved in monitoring the workflows and in optimizing the load times.
• Extensively used Informatica debugger to validate mappings and to gain troubleshooting information about data and error conditions.
• Performed Performance tuning to ensure optimal session performance.
• Documenting the entire process. The documents included the mapping document, unit testing document and system testing document among others.

Environment: Informatica Power Centre 7.x, Oracle 8i, PL/SQL, MS Access, Windows XP, Flat files