SUMMARY

• Over (9) 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 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

Data Warehousing/ ETL: Informatica PowerCenter 9.x/8.x/7.x/6.x/5.x, Oracle Warehouse Builder 10G

Databases & Tools: Oracle 11g/10g/9i/8i/8.x, SQL*Server, SQL*Plus, SQL*Loader, TOAD, MS SQL Server 2000/2005, MS Access

Languages: C,C++,SQL, PL/SQL, Unix Shell Script

Operating Systems: Solaris/Linux/ Windows

PROFESSIONAL EXPERIENCE

Confidential, South San Francisco,CA

ETL (Informatica)/DWH/Oracle (SQL, PL/SQL) Developer

Responsibilities:

• Worked with heterogeneous sources including relational sources and flat files.
• Work with Data Modeler and Data Architect to understand the Architecture of Data warehouse and the mapping Documents.
• Design mappings based upon the complex business logic provided by data modeler, which includes Dimensions and Fact Tables.
• Designed complex mapping logic to implement SCD1 and SCD2 dimensions.
• Interacting with the Front end users to present the proof of concept and to gather the deliverables of the team.
• Doing research work to resolve production issues and data discard during workflow runs.
• Extract the data from relational source VCMG (Oracle), flat files and perform mappings based on company requirements and load into Oracle tables.
• Used lookup transformation (Static as well as Dynamic), aggregator transformations, Update Strategy, Filter and Router Transformations.
• Extensively used Informatica functions LTRIM, RTRIM, IIF, DECODE, ISNULL, TO DATE, DATE COMPARE inTransformations.
• Also used Used-defined Function, which declared once globally and used in various mappings.
• Working extensively on Informatica Designer, workflow manager to create, sessions, workflows and monitor the results and validate them according to the requirement.
• Extensively involved in monitoring the jobs in order to detect and fix unknown bugs and track performance.
• Used Informatica Workflow to create, schedule, monitor and send the messages in case of process failures.
• Involved in Performance Tuning of sources, targets, mappings, sessions and data loads by increasing data cache size, sequence buffer length and target based commit interval.
• Tested the target data against the source system tables by writing the SQL queries and documented the results In the excel sheet.
• Create Mapping that Generate Parameter file and load log.
• Migrate mappings and workflows from development to QA, QA to UAT and from UAT to production.
• Unit tested Informatica Objects to check the errors and made appropriate changes in the objects to generate therequired results.
• Prepared ETL low level and high level design documents.
• Documenting the ETL mapping strategies and transformations involved in the extraction, transformation and loading process
• Interact with various business users of VCMG in order to understand concept and Business Logic.

Environment: Informatica Power Center 9.1, Oracle 10g, Toad 10, SQL/PLSQL, WinSCP, Putty, UNIX, Windows NT.

Confidential, Englewood, CO

ETL (Informatica)/DWH/Oracle (SQL, PL/SQL) Developer

Responsibilities:

• Interacted with Business Analyst to understand requirements and translated them into the appropriate technical solution.
• Designing and developing complex Informatica mappings including Type-II slowly changing dimensions.
• Extensively used ETL to load data from wide range of sources such as flat files and legacy systems.
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager. Version 8.6.
• Performance tuning has been done to increase the through put for both mapping and session level.
• Use debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data
• Created various shell scripting using UNIX.
• Provide off-hours on-call support every 3 weeks, or on as needed basis.
• Developed various mappings using Lookup, Normalizer, Router, Expression, update strategy etc to load the required data
• Created Technical design specification documents based on the functional design documents and the physical data model
• Developed mappings to extract data from Oracle, Flat files and load into Data warehouse using the Mapping Designer
• 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
• 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
• Involved in design and development of data warehouse environment, liaison to business users and/or technical teams gathering requirement specification documents and presenting and identifying data sources, targets and report generation
• Involved in the Migration process from Development, Test and Production Environments
• Used SQL tools like TOAD to run SQL queries and validate the data
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data
• Developed shell scripts, for creating/dropping of table and indexes of performance for pre and post session management
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows
• Identified sources, targets, mappings and sessions and tuned them to improve performance

Environment: Informatica PowerCenter 8.6.1/9.1, Oracle 10g, Flat Files, Erwin, SQL, PL/SQL, Oracle Linux 5, Windows XP, SQL Loader.

Confidential, Columbia, SC

ETL (Informatica)/DWH/Oracle (SQL, PL/SQL) Developer

Responsibilities:

• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer.
• Developing workflows with Worklets, event waits, conditional flows, email, and command tasks using Workflow manager and monitored them in Workflow monitor.
• Reusing the single workflow for loading data from various regions’ files with similar file structure using indirect loading as source type in session properties.
• Expertise in Performance Tuning by identifying the bottlenecks at sources, targets, PowerCenter transformations and sessions using techniques like Explain plans, Oracle hints re-designing the mappings. Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Creating and scheduling the PL/SQL Reconciliation Scripts of Oracle for checking validity of the data in the DWH.
• Used Mapplets, Reusable transformations, Parameters and Variables to facilitate the reusability of Code.
• Used Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Developed processes for automation of loading data using parameter driven sessions for various workflows, verification and re-conciliation of data stored in several different source systems.
• Configured and scheduled Pre and Post Session commands with Shell Scripts and called them using command task.
• Used TOAD to run SQL queries and validate the data in warehouse.
• Extensively used command, event-wait, event-raise and control tasks for keeping track of events in the ETL process.
• Created UNIX shell script to FTP flat files from different ordering systems to the ETL server.
• Fine tuned the performance of ETL processes.
• Involved in the upgrade from Informatica Power center 8.6.1 to Informatica Power center 9.1.
• Wrote stored procedures for generating the data warehouse cycle dates and to drop, re-create the indexes.
• Developed Test Cases according to Business and Technical Requirements and prepared SQL scripts to test data.
• Performed unit test for Informatica mappings and workflows in both development and test environments.
• Used Incremental aggregation to capture new source data and in scenarios where the incremental changes do not significantly change the target so that the PowerCenter server updates the target incrementally.

Environment: Informatica PowerCenter 8.6.1/9.1, Oracle 10g, Flat Files, Erwin, SQL, PL/SQL, Oracle Linux 5, Windows XP, SQL Loader.

Confidential, Sacramento, CA

ETL (Informatica)/DWH/Oracle (SQL, PL/SQL) Developer

Responsibilities:

• Preparing the high-level technical mapping documents laying out the application logic, and designed the ETL process for data loads.
• Designing the update strategy to be implemented across all mappings.
• Developing mappings for loading all the dimension and fact tables using different transformations.
• During Implementation phase, tuned Informatica Mappings and Sessions for optimum performance.
• Solely responsible for the daily loads and handling of the reject data.
• Testing of data warehouse using SQL statements.
• Designed the Universes required to generate reports for the CalWIN that meet County-specific needs not addressed by the existing CalWIN Management Reports System.
• Created the CalWIN management and adhoc reports for the areas of support benefit issuance and recovery, program expenditures, program management, workload management.

Environment: Oracle Warehouse Builder, Informatica 6.2, UNIX, Windows 2000, Oracle 9i, TOAD, SQL * Loader.

Confidential, Mahwah, NJ

Informatica Developer (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, SQLserver 2005, Windows XP Professional/2002, TOAD, UNIX AIX4.2, Windows XP/2000.

Confidential, Parsippany, NJ

ETL Developer

Responsibilities:

• Participated in complete SDLC - requirements gathering, feasibility analysis, physical and logical data modeling, mapping design, unit and integration testing, production support and related documentation. Classified requests as either New Data or Changed Data requests.
• Utilized the Aggregate, Join, Router, Look up and Update transformations to model various standardized business processes.
• Developed Shell Scripts and SQL Queries.
• Used SQL * Loader for bulk loading.
• Worked on Physical modeling phase in designing the Relational Database.
• Developed Unit test plans and integration test plans for verification and validations of procedure developed as well as to help validate the impact of changes.
• Involved in creating Technical Specification Document (TSD) for the project
• Worked on Informatica Power Center tools-Source analyzer, Warehouse Designer, Mapping Designer and Transformation developer.
• Used update strategy and Lookup transformation to insert, delete, update or reject the records based on business requirements.
• Created and documented Test Plans.
• Performed Unit and Integration testing for PowerCenter Mappings and Workflows, and documented the findings.
• Designed Reusable Transformations, Mapplets, Tasks and Worklets during Mapping and Workflow design process. Used most of the PowerCenter Transformations like Source Qualifier, Joiner, Router, Update Strategy, Lookup, Rank, Expression, Aggregator, Filter and Sequence Generator for loading the data into Oracle database.
• Performed Mapping, Workflow, SQL and Database tuning to improve system performance.
• Created and maintained Mapping Design and Testing documentation.

Environment: Informatica Power Center 6.x, Oracle, Flat file, XML files, SQL Server 2000, SQL* Loader, PL/SQL, UNIX, Windows 2000 .