SUMMARY:

• 8+ years of IT experience with extensive Data Warehousing implementations and Data Integration in developing ETL mappings using Informatica PowerCenter 9.6.
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing and Deployment.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, Requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Extensively worked on developing Informatica mappings, mapplets, sessions and workflows.
• Extensively used Informatica Workflow manager and Workflow monitor for creating and monitoring workflows, worklets and sessions.
• Extensively worked on Informatica PowerCenter Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier .
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER - Studio.
• Worked extensively with Slowly Changing Dimensions (SCD Type1/Type2/Type3)
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Extensive testing ETL experience using Informatica 9.6/9.1/8.6.1/8.5/8.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0 and Teradata.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g/10g/9i, MS SQL Server, DB2, Teradata and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in database programming in PL/SQL (Stored Procedures, Triggers and Packages).
• Skills in creating Test Plan from Functional Specification and Detailed Design Documents.
• Experience in writing Test plans, Test cases, Unit testing, System testing, Integration testing and Functional testing.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Strong experience in tuning the SQL, PL/SQL code for optimum performance.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Identified and debugged the errors before deploying and worked on migration of the mappings and workflows from development to testing, testing to QA and from QA to production.
• Experience in using Automation Scheduling tools like Autosys and Control-M.
• Experience in Onsite-Offshore model.
• Exposure to full project life cycle development for implementation and integration.
• Hands on experience in Production Support and Maintenance by resolving issues to meet all Data Warehouse service Level agreements (SLAs).

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.1/9.6/9.1/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server), Informatica PowerMart 6.2/ 5.1.2/5.1.1/5.0/4.7.2, Informatica PowerExchange 8.x/7.x, IDQ 8.6.1/8.6.0

Database and related tools: Oracle 11g/10g/9i/8i/8/7.x, MS SQL Server 2008/2005/2000/7.0/6.5, DB2 v8.1, Teradata, TOAD 10.5/9.5/8.5.1/7.5/6.2, SQL Developer 4.0

OLAP Tools: Cognos 8.4/8.2/8.1/8.0/7.0, Business Objects XI r2/6.x/5.x, OBIEE 10.1.3.4/ 10.1.3.3, Tableau

Languages: SQL, PL/SQL, UNIX, Shell scripts, C, C++

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Operating Systems: Microsoft XP/NT/2000/98/95, UNIX, Sun Solaris 5

Web Technologies: XML, HTML and XHTML

Scheduling Tools: Autosys, Control-M

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr. Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Power Center Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Extracted data from the flat files and other RDBMS databases like Oracle into staging area and populated onto Data warehouse.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement and Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager and Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs and Used Shell Scripts which compares the incoming file with the existing file and creates a log file with differences and the changed values are loaded into the target.
• Created detailed Unit Test Document with all possible Test cases/Scripts and involved in Unit, Integration, System and Performance testing levels .
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created Mapplets and Worklets to re-use them in different Informatica mappings and workflows.
• Used Debugger to test the mappings and fixed the bugs and Tuned the Informatica mappings for optimal load performance.
• Logical and Physical Warehouse Designing using Erwin Tool.
• Worked on Query Optimization and ETL performance tuning for improving the performance of the data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in writing procedures, functions in PL/SQL.
• Conducted code reviews developed by my teammates before moving the code into QA and Prepared migration document and deployment checklist to move the mappings from development to testing and then to production repositories.

Environment: Informatica PowerCenter 10.1, Erwin 9, Oracle 11g, SQL Server 2008, Tableau, UNIX, SQL, IDQ 8.6.0, IDE 8.6.0, PL/SQL, Autosys, Flat files, Extjs and XML.

Confidential, Bloomington, IL

Informatica Developer

Responsibilities:

• Analyzed business process and gathered core business requirements. Interacted with Business Analysts and end users.
• Involved in requirement definition and analysis in support of Data Warehouse
• Coordinated with Data Architect in designing and developing re-usable components for ETL processes.
• Data Warehouse Data modeling based on the client requirement using Erwin(Conceptual, Logical and Physical Data Modeling)
• Designed the database tables and constraints using Data modeling techniques using Erwin.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Implemented SOA (Service oriented Architecture) using Informatica as ETL tool.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Created various Oracle database objects like Indexes, stored procedures, Materialized views, synonyms and functions for Data Import/Export.
• Extracted data from excel files, high volume of data sets from data files, Oracle , DB2 using Informatica ETL mappings/SQL PLSQL scripts and loaded to Data Store Area .
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, sequence generator etc.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL tool.
• Defined and worked with mapping parameters and variables.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Developed mapping parameters and variables to support SQL override.
• Created shortcuts for reusable source/target definitions, Reusable Transformations, mapplets in Shared folder.
• Performed the performance evaluation of the ETL for full load cycle.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Responsible for Data Import/Export, Data Conversions and Data Cleansing.
• Did performance tuning to improve Data Extraction, Data process and Load time.
• Responsible for various discussions with end user to analyze Metadata.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex.
• Worked on Parameterize of all variables, connections at all levels in UNIX.
• Created test cases for unit testing and functional testing.
• Identified problems in existing production data and developed one time scripts to correct them.
• Responsible for the Folder Migration and Folder Creation and creating user accounts in the Repository Manger and management of passwords and permissions.
• Extensively involved in writing ETL Specifications for Development and conversion projects.

Environment: Informatica Power center 8.6.1, Oracle 10g, DB2 , Windows XP, Teradata , Erwin 7.2, Unix Shell Scripts, SQL, PL/SQL, Flat files, XML.

Confidential, NJ

ETL Developer

Responsibilities:

• Worked with ETL Data Architect in installing and testing mappings using Informatica Debugger, provided technical assistance for migration of code for system testing.
• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.
• Worked on Informatica Utilities like Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.
• Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process.
• Created reusable transformations to load data from operational data source to Data Warehouse and involved in capacity planning and storage of data.
• Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer.
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• Worked with Data Architect in preparing and maintaining mappings with filters, joiner and transformations.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Developed and used Unix Shell Scripts to automate pre-session and post-session processes.
• Did performance tuning to improve Data Extraction, Data process and Load time.
• Wrote complex SQL Queries involving multiple tables with joins.
• Involved in creating Detail design documentation to describe program development, logic, coding, testing, changes and corrections.
• Implemented best practices as per the standards while designing technical documents and developing Informatica ETL process.
• Effective use of advanced reporting and formatting functions in Business Objects reporting.
• Developed Single and multiple dashboards and scorecards using Business Objects.

Environment: Informatica PowerCenter 8.6.1/8.1.1 , Oracle 10g, Business Objexts XI R2, SQL, PL/SQL, Flat files, XML, UNIX Scripting KSH Windows 2000, Power Exchange 8.6.1, IDQ 8.6.0, IDE 8.6.0

Confidential

Informatica Developer

Responsibilities:

• Worked on Informatica Power Center 7.2 tool - Source Analyzer, Data warehousing designer, Mapping Designer, Mapplets and Transformations.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Transformations used are: Remote Procedure, Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregators, Filters and Sequence Generator etc.
• Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy and others.
• Installed and configured Informatica Server and Power Center 7.2.
• Used shell scripting to check if the flat files have come in on the correct path and triggering the informatica jobs from UNIX server.
• Evaluating the Consistency and integrity of the model and repository.
• Identified the Facts and Dimensions using Erwin Data modeling tool to represent the Star Schema Data Marts.
• Designed and Developed the ETL mappings, load strategy documents, Workflows and Worklets and built Data Marts for home and business divisions.
• Extensively worked with Oracle Analytical Functions.
• Metadata changes to the Informatica repository.
• Responsible for Data Import/Export, Data Conversions and Data Cleansing.
• Used Transformations for data joins, complex aggregations & external procedure calls.
• Various kinds of the transformations were used to implement simple and complex business logic.
• Integrated sources from different databases and flat files.
• Designed mappings with multiple sources using Informatica Designer tool.
• Implemented various performance tuning concepts to enhance the jobs performance.
• Logical and Physical Warehouse Designing using Erwin Tool.
• Extensively used Star schema for designing the data warehouse.
• Responsible for various discussions with end user to analyze Meta data.
• Coordinating offshore team, planning and review of deliverables.
• Worked on OBIEE reports to do enhancements.
• Designed the ETL Mapping Documents for development team members for their implementations.

Environment: Informatica PowerCenter 7.2, Oracle 10g/9i, Power Exchange 8.6.1, IDE8.6.0, IDQ8.6.0, TOAD 8.6.1.0, Windows NT, Erwin 4.0/3.5.2, OBIEE

Confidential

ETL Developer

Responsibilities:

• Understood ETL process and business rules that need to be implemented
• Worked on Informatica Power Center 7.1.3 tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplets and Transformations.
• Developed mappings in Informatica to load the data from various data sources into the Data Marts, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter and Source Qualifier.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Created and configured Workflows, Worklets and Sessions to transport the data to target using Informatica Workflow Manager.
• Involved in extraction, cleansing and loading of data into Oracle database from flat files and DB2 tables.
• Extensively involved in performance tuning at source, target, mapping, session and system levels by analyzing the reject data.
• Performed Unit testing and Functional Testing of Informatica mappings and Workflows.
• Performed ETL & database code migrations across environments.
• Designed tables, indexes and constraints using TOAD and loaded data into the database using SQL*Loader.
• Documentation of technical specification, business requirements, functional specifications for the development of Informatica mappings to load data into various tables and defining ETL standards.

Environment: Informatica Power Center 7.1.3, Oracle 8.1.7.4, SQL*Plus, PL/SQL, TOAD 7.1, UNIX, Windows XP