SUMMARY

• Over 7 years combined IT experience in analysis, design, development, coding, testing, implementation, support of various projects using Data Warehousing tool like Informatica, Programming in Unix Shell Scripting, PL/SQL and Databases like Oracle, MS SQL Server.
• Very Strong experience in Extraction, Transformation, Loading (ETL) data from various sources (flat files, Oracle, SQL Server, and Teradata) into Data Warehouses and Data Marts using Informatica Power Center.
• Experience in working with Informatica Power Center 9.x/8.x
• Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, Task View, Mapplets, Mappings, Workflows, Sessions, Re - usable Transformations, Shortcuts, Import and Export utilities
• Over four years of extensive experience in developing several PL/SQL procedures, queries, and UNIX Shell Scripts.
• Experience in the areas of Financial, Insurance and Retail domains.
• Strong skills including the ability to work through the entire development life (SDLC) cycle from gathering requirements through implementation, development, production, support and documentation of the complete project.
• Have Good understanding of ETL/Informatica standards and best practices, Slowly Changing Dimensions (SCD1,SCD2,SCD3)
• Expertise in Database Programming (Stored procedures, Triggers, Packages, PL/SQL, TSQL) using SQL Server 2008/2005, Oracle 10g/9.x
• Expertise in migration process across different environments Dev/QA/UAT/Prod and developing several shell scripts to run/stop/monitor workflows/trap errors.
• Very Good Programming skills using UNIX/Shell Scripts and PL/SQL for Automation and several ETL process.
• Very good Experience in Troubleshooting, Identifying Bottlenecks and performance tuning.
• Worked with ODS (Operational Data Source), Data validation and cleansing process.
• Experienced in various data systems like Oracle, SQL Server, Fixed Width and Delimited Flat Files, SQL Server, Informix, Sybase into ODS.
• Extensive experience in production support - involving in extensive data analysis, d implementation, troubleshoot and maintenance of different systems.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

TECHNICAL SKILLS

Data Warehousing Tool: ETL/ Informatica 9.0/8.6.1/8.5.1/8.1.1/7.1.4/6.2/5.1 (Power Center/Power Mart)

Databases: SQL Server 2005/2008, Oracle 10g/9i/8.x, MS Access 00/03/07, MySQL 5.1, Power Exchange

GUI: Toad, SQL*Loader, SSMS

Programming: UNIX Shell Scripting, PL/SQL, T- SQL, Windows Batch Scripts

Operating System: SUNOS, Solaris 6/7/8/9/10, Red Hat Linux 9, Windows 2000/XP, WinNT4.0, Windows Server 2003/2008.

Utilities: AutoSys, Remedy, Jira

PROFESSIONAL EXPERIENCE

Confidential, Detroit MI

Informatica Developer

Responsibilities:

• Responsible for full life cycle development including gathering requirements.
• Analyzing, coding, testing, and assisting with user acceptance testing, production implementation and system support for the IMS Data Warehouse Application.
• Will be a part of interviewing, gathering, documenting requirements and determining project scope from our Users; analyzing user requirements to create system designs, either coding all or sharing in the coding and development, unit testing, system testing, final implementation and post implementation monitoring.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, SQL, Union, Lookup, Joiner, XML Source Qualifier, Unconnected lookup transformations.
• Involved in Debugging and Troubleshooting Informatica mappings.
• Populated error tables as part of the ETL process to capture the records that failed the migration.
• Used Informatica Power Center 9.1/9.01/8.6.1 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Implemented various Data Transformations for Slowly Changing Dimensions.
• Hands on experience as an Administrator involving Maintaining the Repository Manager for creating Repositories, user groups, folders and migrating code from Dev to Test, Test to Prod environments
• Working on the changes in the Informatica Mappings and testing them for Analyze and Fix gaps in Daily Jobs related to IMS project.
• Respond and resolve ad hoc requests from application and business users. Extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Environment: Informatica Power Center 8.6.1/9/1, SQL Server 2005/2008, TSQL, MS Excel, Windows XP/2003/2008, CA Scheduler change data capture.

Confidential, Chicago, IL

ETL/Informatica Developer

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouses.
• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.
• Identified all the dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Assisted in designing Logical/Physical Data Models, forward/reverse engineering using Erwin 4.0.
• Developed mappings to extract data from SQL Server, Oracle, Teradata, Flat files, and load into Data warehouse using the PowerCenter, power exchange.
• Developed common routine mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Made use of mapping variables, mapping parameters and variable functions.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD
• Export/Import data from different data bases, flat files using DTS package and BCP by defining source and target.
• Written SQL Queries, Triggers, PL/SQL Procedures, Packages and UNIX Shell Scripts to apply and maintain the Business Rules.
• Checked performance tunning/debugging at different levels like workflows, mappings, database etc,.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Created testing metrics using MS-Excel
• 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.
• Performed Configuration Management to Migrate Informatica mappings/sessions /workflows from Development to Test to production environment.
• Performed System Testing, Regression Testing, Acceptance Testing, Functional Testing and Stress Testing.
• Created reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports

Environment: Informatica PowerCenter 7.1, Informatica Power Exchange, SQL Server 2000, Teradata 6, Oracle 9i,SQL, PL/SQL, UNIX Shell Scripts, Autosys, Remedy.

Confidential, Hoffman Estates,IL

Informatica Developer

Responsibilities:

• Involved in system study, analyze the requirements by meeting the client and designing the complete system.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center 8.6.1.
• Created reusable transformations and mapplets and used them in mappings.
• Used Informatica Power Center 8.6.1 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Implemented the slowly changing dimensions (SCD) type1 and type2 to maintain current information and history information in the dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, SQL, Union, Lookup, Joiner, XML Source Qualifier, Unconnected lookup transformations.
• Created E-mail notifications tasks using post-session scripts.
• Designed and developed unit test cases for system integration testing.
• Involved with the users in the creation of test scripts for the user acceptance testing
• Developed some scripts to take weekly backups of certain tables using import/export utilities.
• Worked on tuning some individual mappings and oracle queries that causing performance bottlenecks.
• Written documentation to describe program development, logic, coding, testing and changes made.
• Working on data request tickets and assisting business users (non technical) to understand the quality of the data.

Environment: Informatica Power Center 8.6.1/8.5, Oracle 10g/9i, DB2, SQL Server 2005/2000, PL/SQL, Toad, MS Access, Windows 2003, Shell Scripting, Sun Solaris 9.0, Windows 2003/2008, AutoSys.

Confidential

Informatica Developer

Responsibilities:

• Analyzed user requirements for the system.
• Responsible for verification of functional specifications and review of deliverables.
• Designed and Created data cleansing, validation and loading scripts for Oracle data warehouse using Informatica PowerCenter 7.1.
• Extensively used Informatica Client Tools - Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, Mapplet Designer, and Informatica Repository.
• Created reusable transformations and mapplets to use in multiple mappings.
• Used debugger to test the data flow and fix the mappings.
• Created and monitored workflows and tasks using Informatica PowerCenter Work flow Manager. Analyzed newly converted data to establish a baseline measurement for data quality in data warehouse.
• Imported Relational metadata extract and load relational data.
• Setting up batches and sessions to schedule the loads at required frequency using PowerCenter server manager.
• Involved in Version control of the jobs to keep track of the changes in the Development Environment.
• Developed Shell scripts to setup runtime environment, and to run stored procedures, packages to populate the data in staging tables.
• Documented the purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.
• Developed Unit test cases for the jobs.
• Provided assistance during user testing (interaction with the users).

Environment: Informatica Power Center 7.1(Designer, Workflow Manager, Workflow Monitor, Repository Manager), Informatica Power Connect, Oracle 8i, UNIX Shell Scripting, TOAD (Tool for Oracle Application Developer), Oracle Designer.

Confidential

Informatica Developer

Responsibilities:

• Reviewing the ETL solutions in Informatica Power Center 6.x
• Developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Validation of Data using SQL queries.
• Designed and developed table structures, stored procedures and functions to implement business rules.
• Extensively involved in migration of ETL environment, Informatica, Database objects.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment.

Environment: Informatica PowerCenter 6.1, SQL Server 2005/2000, OracleTeradata, SQL, PL/SQL,, UNIX Shell Scripts, Windows 2000.