SUMMARY

• Over (7+) years of total IT experience and Technical proficiency in the Data Warehousing teamed with Business Requirements Analysis, Application Design, Data Modeling and Data Quality, Data Profiling, Development, testing and documentation.
• 8 years of extensive experience in Information Technology with special emphasis on Design and Development of Data Warehousing using Informatica Power Center 9.1/9.0.1/8.6 / 8.5 / 8.1.1 / 7.1.1 / 7.1.2 / 7.0 / 6.1.2 / 5.1.1
• Over 5 years of Extensive experience in developing ETL solutions using Informatica Power Center
• Strong expertise in Relational data base systems like Oracle, SQL Server, MS Access, DB2
• Designed and developed various mappings and mapplets in Mapping designer and sessions and workflows in Workflow manager to extract data and load to Oracle database.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and worked on integrating data from flat files like fixed width and delimited
• Has extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center
• Performed various kinds of testing like Integration, Unit and User Acceptance testing.
• In - depth understanding of Star Schema, Snow Flake Schema, Normalization, 1st NF, 2nd NF, 3rd NF, Fact tables, Dimension tables.
• Experience in SQL Plus and TOAD as an interface to databases, to analyze, view and alter data.
• Extensively used SQL statements while performing ETL process and applied Query.
• Experience in working with scheduling tools like Autosys.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups, Aggregators, and Re-usable transformations
• Strong Experience in developing Sessions/Tasks, Worklets, Workflows using Workflow Manager tools - Task Developer, Workflow & Worklet Designer
• Experience in using the Informatica command line utilities like pmcmd to execute Workflows in non-windows environment
• Extensively used Informatica Repository Manager and Workflow Monitor
• Experience in debugging mappings; Identified bugs in existing mappings by analyzing the data flow and evaluating transformations
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow
• Strong knowledge in optimizing database performance
• Experience in UNIX shell scripting, FTP and file management in various UNIX environments
• Exposure to OBIEEConcepts.
• Highly Motivated to take independent responsibility as well as ability to contribute and be a productive team member with excellent Verbal and Communication Skills and clear understanding of Business procedures

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.6/7.x Informatica Power Exchange 5.1/4.7/1.7, Power Analyzer 3.5, Informatica Power Connect and Metadata Manager.

Databases: Oracle 11g/10g/9i/8i/8.0/7.x, Teradata, DB2 9.7, MS SQL Server 7.0/2000/2005 Netezaa 4.0 and Sybase ASE 12.5.3/15.

Operating Systems: UNIX (Sun-Solaris, HP-UX), Windows NT/XP/Vista, MSDOS

Programming: SQL, SQL-Plus, PL/SQL, UNIX Shell Scripting (Korn, C), COBOL, C++, Java

Reporting Tools: Business ObjectsXIR 2/6.5/5.0/5.1, Cognos Impromptu 7.0/6.0/5.0, Informatica Analytics Delivery Platform, MicroStrategy.

Modeling Tools: Erwin 4.1 and MS Visio

Other Tools: SQL Navigator, Rapid SQL for DB2, Quest Toad for Oracle, SQL Developer 1.5.1, Autosys, Telnet, Serena Dimensions Version Manager, MS SharePoint, Mercury Quality center, Team Track.

Methodologies: Ralph Kimball

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

Sr. ETL Informatica Developer

Responsibilities:

• Understood the Business point of view to implement coding using Informatica Power Center 9.6/9.1
• Extensively used Informatica Power Center 9.6/9.1 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Involved in design and development of complex ETL coding in an optimized manner.
• Created Pentaho Jobs and transformations to load data from CSV, Excel files to MYSQL database
• Has created / developed different types of profiles like Column level profiling, Summary profiles, drill down profiles, Score cards, reports etc using IDE.
• Designed and developed Pentaho jobs and transformations to load data into dimensions and facts
• Has created Match, and Merge rules, developed address validations etc and developed address validations to countries like US, and also developed reusable error handling rules using IDQ
• Redesigned some of the existing mappings in the system to meet new functionality.
• Optimized performance by tuning the Informatica ETL code as well as SQL
• Based on the requirements, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update Strategy, Sorter, XML, Lookup, Aggregator, Joiner and Stored Procedure transformations in the mapping.
• Used Informatica Designer to create complex 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.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD.
• 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.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Implemented Error Rejection process to load bad/invalid records into a separate reject table.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command and Decision.
• Created and scheduled sessions, jobs based on demand, run on time and run only once using Workflow Manager.
• Created parameter files to Dev, Test and Prod environments.
• Created Perl Scripts and called in Pre session and Post session commands.
• Involved in various testing activities like database testing, unit testing, system testing, performance testing and was also responsible for maintaining of testing metrics, defect tracking.
• Actively participated in data base testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc
• Identified and debugged the errors before deploying and worked on migration of the maps and workflows from development to UAT and from UAT to Production.

Environment: Informatica Power Center 9.6/9.1, Oracle 11g,, Flat Files, TOAD, Teradata, Autosys, Perl Scripting, Windows XP, UNIX, Sales Force, Web Services

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

• Analyzed Business/ functional Specifications and worked with Business Analyst team and identified the source data and transformation logic needs and review of final mapping documents. Also, participated in the review meetings/ project check in and user requirement gathering meetings.
• Participated in developing logical and physical data models dat capture current state/future state data elements and data flows.
• Created complex reusable transformations and mapplets in Transformation Developer, and Mapplet Designer, respectively.
• Involved in Performance Tuning of Sessions and Mappings.
• Handled slowly changing dimensions of Type I, Type II to populate current and historical data to Dimensions tables in the data warehouse.
• Worked extensively on different types of transformations like normalizer, lookup, rank, expression, union, filter, aggregator, update strategy, lookup, stored procedure, sequence generator and joiner.
• Designed and developed Complex mappings like Slowly Changing Dimensions Type 2 (Time Stamping) to maintain full history of transactions.
• Created Workflows, re-usable Sessions using Workflow Monitor.
• Performed Performance tuning and also has used debugger to troubleshoot errors.
• Loaded data to and from Flat files and databases like Oracle, SQL Server and DB2.
• Developed PL/SQL stored procedures/functions and Unix Shell Scripts as a part of the project.
• Widely used Parameter file to override mapping Variables, Workflow Variables, Session Parameters, FTP Session Parameters and Source-Target Application Connection parameters.
• Performed Developer testing, Functional testing, and Unit testing for the Informatica mappings.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Environment: Informatica Power Center 9.1/8.6, Workflow Manager, Windows Server 2003,Erwin4.0, Oracle 11g/10g, SQL server, XML,SQL,PLSQL, Unix Shell Scripts,Flat Files, Windows NT

Confidential, Concord, CA

Informatica Developer

Responsibilities:

• Involved in understanding requirements, analyze new and current systems to quickly identify required Sources and Targets
• Analyzed business requirements to build a Data Mart for various business processes conformed to the business rules
• Analyzed the Functional Specs provided by the Data Architect
• Designed Technical specification document based on the FSD
• Created Mapping Design document based on FSD
• Extensively used Informatica for extracting, transforming, loading databases from Oracle, flat files and DB2
• Created PL/SQL Procedures and Functions for scrubbing the data
• Developed Transformation logic and designed various complex Mappings in the Designer
• Designed and developed various mappings in Mapping Designer, sessions & workflows in Workflow Manager to extract data from flat files, Oracle and DB2 sources and load to Oracle.
• Created, launched & scheduled sessions. Configured email notification
• Implemented the best practices for the creation of Mappings, sessions, Workflows and performance optimization.
• Implemented Pipeline partitioning to improve session performance.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data
• Wrote Queries, Procedures and Functions dat are used as part of different application modules
• Performed Data Quality Analysis to determine cleansing requirements
• Created scripts to update the parameter files to establish delta extraction
• Wrote various shell scripts for pre-processing of data and scheduling of jobs
• Wrote Unix Shell Scripts for Informatica Pre-Session, Post-Session to schedule the Infa jobs (work flows)
• Prepared Test Data and loaded it for Testing, Error handling and Analysis
• Involved in preparing ETL design documents and Unit Test Plans for Mappings.
• Prepared the code migration document and worked with release team in Migrating the code (Informatica Objects, Unix Scripts) from Development to Test and Production environments
• Interacted with Users for analyzing various Reports.
• Involved in answering the change request as part of the interaction testing
• Deployed ETL components code into multiple environments as per the approval received
• Provided Production Support by executing the sessions, diagnose problems and fix the mappings for changes in business logic.

Environment: Informatica PowerCenter 8.1, Windows XP, Oracle 9i, DB2 SQL, PL/SQL, TOAD, Delimited Flat Files, Unix Shell Scripting.

Confidential, Louisville, KY

ETL Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Created mappings using the Transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator, and Update Strategy.
• Created Mapplets, reusable transformations and used them in different mappings.
• Successfully Loaded Data into different targets from various source systems like Oracle Database, Flat files, SQL Server...etc into the Staging table and tan to the target database Oracle.
• Trouble shooting of long running sessions and fixing the issues.
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
• Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for clean up and update purposes.
• Involved in Version control of code from development to test and Production environments.
• Migrated repository objects and scripts from development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.

Environment: Informatica Power Center 7.1.3, UNIX, Windows NT, Oracle9i, XML, SQL, PL/SQL.

Confidential

Oracle/Informatica Developer

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Understanding the requirements specification and use case documents.
• Creation of test plan, test strategy and test approach.
• Created Test scripts, Traceability Matrix and mapped the requirements to the test cases.
• Done Peer review of test scripts and prepare the QA measurement forms.
• Attended the QA Audit meetings and test artifacts review.
• Participated in the Integration testing and Unit Testing along with the Development team.
• Conducted System, GUI, Smoke and Regression testing identified application errors and interacted with developers to resolve technical issues.
• Developed mappings/Transformations/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center.
• Analyzed, designed, constructed and implemented the ETL jobs using Informatica.
• Extensively used SQL scripts/queries for data verification at the backend.
• Executed SQL queries, stored procedures and performed data validation as a part of backend testing.
• Used SQL to test various reports and ETL Jobs load in development, testing and production
• Performed negative testing to test the application for invalid data, verified and validated for the error messages generated.
• Responsible for Generating Progress Reports and Updates to Project Lead Weekly including with test Scenarios Status, Concerns and Functionality outstanding.
• Involved in Daily and Weekly Status meetings.
• Creation of Test Summary report, traceability Matrix, Test Script Index.
• Monitor the testing project in Quality Center and ensuring defects are being entered, tested, and closed.
• Analyzed, documented and maintained Test Results and Test Logs.

Environment: s: Informatica 8.6.0, Windows 7, Oracle 10g