Professional 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
• Have 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 OBIEE Concepts.
• 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 ObjectsXIR2/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

Sr. ETL Informatica Developer

Responsibilities:

• Created Pentaho Jobs and transformations to load data from CSV, Excel files to MYSQL database
• Involved in design and development of complex ETL coding in an optimized manner.
• Extensively used Informatica Power Center 9.6/9.1 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Understood the Business point of view to implement coding using Informatica Power Center 9.6/9.1
• Have 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
• Have 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
• Defects were tracked, reviewed and analysed.
• Written Queries, procedures, created Indexes, primary keys and data bases testing.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD.
• 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.
• 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.
• Optimized performance by tuning the Informatica ETL code as well as SQL
• Redesigned some of the existing mappings in the system to meet new functionality.
• 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.
• Actively participated in data base testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc
• 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.
• Created Perl Scripts and called in Pre session and Post session commands.
• Created parameter files to Dev, Test and Prod environments.
• Created and scheduled sessions, jobs based on demand, run on time and run only once using Workflow Manager.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command and Decision.
• 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

Informatica Developer

Responsibilities:

• Involved in analyzing source systems and designing the processes for Extracting Transforming and Loading the data.
• Worked closely with Business Analysts and SME's to understand Business requirements and change requests of clients and implement with my team.
• Used various transformations such as Source Qualifier, Expression, Lookup, Sequence Generator, aggregator, Update Strategy, and Joiner while migrating data from various heterogeneous sources like Oracle, SQL Server, and Flat files to Oracle.
• Developed mappings to bring in data from various sources across Staging, ODS to Reporting.
• Created mapping variables and parameters for incremental loading.
• Used all Transformations such as Expressions, Filters, Joiners, Aggregators, Lookups, Update strategy, Sequence Generator, Routers to load consistent data into database.
• Involved in performance tuning by optimizing the sources, targets, mappings and sessions and eliminating bottlenecks.
• Created and Monitored sessions and workflows for daily extract jobs using Informatica Power Center, Workflow Manager and Workflow Monitor.
• Deployed objects across various environments from various developer folders in development, Test and Production productions.
• Created Workflows, re-usable Sessions using Workflow Monitor.
• Performed Performance tuning and also have 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

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 that 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

ETL Developer

Responsibilities:

• Created multiple PowerCenter Mappings 20 and PowerCenter Workflows to accomplish data transformation and load process..
• Used various complex PowerCenter Transformations like Lookup, Joiner, Expression, Router, Update Strategy, Source Qualifier, Aggregator, SQL, Filter, Sequence Generator, Normalizer to accomplish the mapping design.
• Re-designed multiple existing Power Center mappings to implement change requests CR representing the updated business logic.
• Created User Defined Functions UDFs and reusable Mapplets and Transformations to simplify maintenance process and improve the productivity.
• Performed Unit Testing and Integration Testing of Mappings and Workflows.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Mapplets and Transformation objects.
• Validated and fine-tuned the ETL logic coded into existing PowerCenter Mappings, leading to improved performance.
• Maintained technical documentation
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files Fixed Width , and Excel files to staging database and from staging to the target Oracle Data Warehouse database
• Designed and developed the logic for handling slowly changing dimension tables load by flagging the record using update strategy for populating the desired
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis
• Used Debugger in troubleshooting the existing mappings

Environment: Informatica Power Center 8.6.1, Oracle 10g, Business Objects xi, TOAD 8.6.1, SQL server 2005, Windows XP Professional/2002, TOAD, UNIX AIX4.2, Windows XP/2000.

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.

Environments: Informatica 8.6.0, Windows 7, Oracle 10g