PROFESSIONAL PROFILE:

• Over 7 years of IT experience in Business Requirements Analysis, Designing, coding and testing of Data Warehousing implementations.
• 6+ years of ETL experience with Informatica PowerCenter (9.1/8.5/8.1.1 ) and Strong experience in performing ETL operations like Data Extraction, Data Transformation and Data Loading with Informatica PowerCenter Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Diversified Domain expertise implementing solutions to Data Warehousing Projects. Work experience in Insurance, Banking, Healthcare and Manufacturing domains.
• Experience in designing and developing mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Experience in creating and maintaining schemas, table spaces, partitions, indexes, roles and privileges. Enforced and maintained database constraints to ensure integrity of the database.
• Used SQL Loader for bulk loads, experience in export/import features. Knowledge of fine - tuning of the SQL statements and database performance related issues.
• Strong experience in Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional data modeling (Star Schema, Snow Flake Schema, FACT & Dimension Tables), OLTP and OLAP.
• Experience in data mart life cycle development, performed ETL procedure to load data from different sources into Data marts, Data warehouse using Informatica Power Center.
• Working knowledge of enhancing performance for Informatica sessions by using physical pipeline partitions and Parameter Files.
• Strong knowledge of software development life cycle (SDLC) including Requirements gathering and Analysis, Database Design, Development, Testing, Implementation and Support
• Worked on automating the Informatica jobs, Informatica Scheduler, Autosys, and UNIX scripts for automation.
• Experienced in integrating from various data sources like Flat Files, XML files, databases (Oracle, SQL
• Server, and MS Access) and handling large volumes of data.
• Good Experience in writing, testing and implementation of the triggers, stored procedures, functions, packages at database level using SQL, PL/SQL.
• Experience in translating business requests into Informatica DQ solutions
• Creating technical design documents for ETL jobs which include detailed specifications for developing mapplets, mappings and workflows
• Experienced in preparing Technical design document, mapping documents, data definition documents and Detail design document for the Source/Target mapping.
• Replacing& Modifying database entity models, Object Oriented Concepts candidate with excellent experience in interacting with users, design, development, coding, bug fixing, creating specifications, maintenance, integration, implementation, testing & enhancements.
• Expertise in Oracle 10g and migration of Oracle Reports from 4.x/6i/9i to Oracle 10g.
• Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment.
• Excellent problem solving skills with a strong technical background and exemplary communication skills
• I have been recognized by top management for my accomplishments, and awarded Value in Action Award by Allied Group technical skills

TECHNICAL SKILLS:

Operating Systems: Windows 7/ XP/ NT/95/98/2000, DOS, UNIX, and LINUX

Database: Oracle 11g/10g/9i/8i, MySQL, MS SQL Server 2005, MS Access.

Programming languages: SQL, PL/SQL, UNIX Shell Script, ANSI C, C++, XML, HTML.

Tools: & Utilities: Toad, Oracle SQL Developer, PLSQL,SQL, Informatica PowerCenter9.0/8.X/7X, Informatica Power Exchange 8.X

Reporting: Oracle reports 10g/9i/6i, MS Access, Crystal Reports, Actuate Reports.

Others: OOAD Methodology,Data Structures,RDBMS Concepts

PROFESSIONAL EXPERIENCE:

Confidential, CA

Sr. Informatica Developer

Responsibilities:

• Interacted with Business Analysts for Requirement gathering, understanding the Requirements, Explanation of technical probabilities and Application flow.
• Developed ETL mappings, transformations using Informatica Power Center 8.6
• Extracted data from flat files (provided by disparate ERP systems) and loaded the data into Oracle staging using Informatica Power Center.
• Analyzed Source Data to resolve post-production issues. Used MS Access to analyze source data from flat files.
• Designed and created complex source to target mapping using various transformations inclusive of but not limited to Sorter, Aggregator, Joiner, Filter, Source Qualifier, Expression and Router Transformations.
• Extensively used Lookup Transformation and Update Strategy Transformation while working with Slowly Changing Dimensions.
• Used Mapping Parameters and Mapping Variables based on business rules provided.
• Scheduled workflow on a daily basis for incremental data loading
• Wrote PL/SQL Procedures for data extractions, transformation and loading.
• Assisted in Data Modeling and Dimensional Data Modeling.
• Involved in Performance Tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the data load processes to target.
• Scheduling jobs using TWS to automate the Informatica Sessions.
• Used TOAD to FTP file moving processes to and from source systems.
• Performed Unit testing for all the interfaces.
• Used Test Director to log and keep a track of the defects.
• Provided Production Support at the end of every release.

Environment: Informatica Power center Designer 8.6.1, Workflow Manager, workflow monitor, Repository manager, Oracle 10g/9i,Sql Server2000,BO XI R2, UNIX, COBOL,ERWIN 3.5, Shell script, Rapid-SQL, Toad, SQL *Loader, SQL, PL/SQL, Visio, TWS.

Confidential, NC

Sr. Informatica Developer

Responsibilities:

• Involved in the Informatica server installation and set up the environment.
• Worked on developing Unix scripts for data cleansing and data archiving
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, Union, Rank, Normalizer, Update strategy and Router transformations for populating target table in efficient manner.
• Implemented slowly changing dimension Type 1 and Type 2 for Change data capture using Version control.
• Involved in Creation of SQL, Packages, Functions, Procedures, Views, and Database Triggers.
• Developed database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Created DTS packages for data migration from Excel Sheets and Flat files into the SQL Server Database using SSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS).
• Expertise in configuration, performance tuning, installation of Informatica, & in integration of various data sources like Oracle, MS SQL Server, XML, Flat files into the staging area and Design ETL processes that span multiple projects
• Involved in writing the SQL procedures used SQL Server DTS to improve the warehouse loading.
• Designed and Developed ODS to Data Mart Mappings/Sessions/Workflows.
• Created various Oracle database objects like Indexes, stored procedures, Materialized views, synonyms and functions for Data Import/Export.
• Created reusable worklets and workflows.
• Used Transformation Language functions in the mappings to produce the desired results.
• Used TOAD to run SQL queries and validate the data in warehouse and mart.
• Involved in Debugging and Troubleshooting Informatica mappings.
• Populated error tables as part of the ETL process to capture the records that failed the migration.
• Involved with Scheduling team in creating and scheduling jobs in Tivoli Workload Scheduler.
• Used CDC for moving data from Source to Target.
• Re-writing PL/SQL routines using Netezza nzsql and nzload utilities
• Designed the ETL processes using Informatica tool to load data from Oracle, flat files into Netezza (Staging, Warehouse).
• Designed ETL process using Informatica Tool to load from Sources to Targets through data Transformations
• Writing stored procedures and DTS packages for maintenance tasks in Production environment.
• Implemented various Data Transformations using Slowly Changing Dimensions
• Developed test cases for Unit, Integration and system testing
• Used Custom logger can run a Serializer that reports detailed event information
• Involved in Maintaining the Repository Manager for creating Repositories, user groups, folders and migrating code from Dev to Test, Test to Prod environments.
• Partitioned the Sessions for better performance.
• Designed of ETL mappings for the CDC change data capture
• Trained end users in using full client BO for analysis and reporting.
• Wrote SQL Scripts and PL/SQL Scripts to extract data from Databases
• Extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Environment: Informatica Power Center 9.1, Oracle 11g/10g, SQL Server 2008, PL/SQL, DB2, Windows XP, UNIX.

Confidential, TX

Sr. ETL Developer

Responsibilities:

• Analyzed business process and gathered core business requirements. Interacted with business analysts and end users.
• Prepared a handbook of standards for Informatica code development.
• Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all application and systems.
• Developed Custom metadata repository.
• Used Informatica designer for designing mappings and mapplets to extract data from SQL Server, Sybase and Oracle sources.
• Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Used Debugger to test the data flow and fix the mappings.
• Created and monitored workflows and task using Informatica PowerCenter Workflow Manager.
• Partitioned Sessions for concurrent loading of data into the target tables.
• Tuned the workflows and mappings.
• Involved in identifying the bottle necks and tuning to improve the Performance.
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Executed Workflows and Sessions using Workflow Monitor.
• Dealt with data issues in the staging flat files and after it was cleaned up it is sent to the targets.
• Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.
• Executed the workflow using pmcmd command in UNIX.

Environment: Informatica PowerCenter 8.0/7.1.3, Oracle 10g/9i/8i, SQL Server 2000, PL/SQL, Erwin, TOAD, SQL*Plus, SQL*Loader, UDB, Sybase, XML, Windows, Linux and HP-UNIX.

Confidential, Chatsworth CA

Informatica Developer

Responsibilities:

• Gathered user Requirements and designed Source to Target data load specifications based on Business rules.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Developed slowly changing dimension Type 2 mappings to maintain the history of the data.
• Developed several mappings in Informatica, a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables and Parameter files in Mapping Designer.
• Created reusable transformations and mapplets and used them in mappings.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors that occur while loading.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Implemented performance tuning logic on Sources, Targets, mappings, and sessions to provide maximum efficiency.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings and workflows and to keep track of the changes in the development, testing and production environments.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
• Created Workflows with worklets, event wait, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g/11g, Teradata 13, SQL, PL/SQL, UNIX, Flat files, XML, MS Access, Web services, DB2, SQL Server 2008, Business Objects.

Confidential, Northridge, CA

Informatica/ETL Developer

Responsibilities:

• Involved in the Informatica server installation and set up the environment.
• Worked on developing Unix scripts for data cleansing and data archiving
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, Union, Rank, Normalizer, Update strategy and Router transformations for populating target table in efficient manner.
• Implemented slowly changing dimension Type 1 and Type 2 for Change data capture using Version control.
• Involved in Creation of SQL, Packages, Functions, Procedures, Views, and Database Triggers.
• Developed database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Created DTS packages for data migration from Excel Sheets and Flat files into the SQL Server Database using SSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS).
• Expertise in configuration, performance tuning, installation of Informatica, & in integration of various data sources like Oracle, MS SQL Server, XML, Flat files into the staging area and Design ETL processes that span multiple projects
• Involved in writing the SQL procedures using SQL Server DTS to improve the warehouse loading.
• Designed and Developed ODS to Data Mart Mappings/Sessions/Workflows.
• Created various Oracle database objects like Indexes, stored procedures, Materialized views, synonyms and functions for Data Import/Export.
• Created reusable worklets and workflows.
• Used Transformation Language functions in the mappings to produce the desired results.
• Used TOAD to run SQL queries and validate the data in warehouse and mart.
• Involved in Debugging and Troubleshooting Informatica mappings.
• Populated error tables as part of the ETL process to capture the records that failed the migration.
• Designed the ETL processes using Informatica tool to load data from Oracle, flat files into Netezza (Staging, Warehouse).
• Writing stored procedures and DTS packages for maintenance tasks in Production environment.
• Implemented various Data Transformations using Slowly Changing Dimensions
• Developed test cases for Unit, Integration and system testing
• Involved in Maintaining the Repository Manager for creating Repositories, user groups, folders and migrating code from Development to Test, and Test to Production environments.
• Partitioned the Sessions for better performance.
• Designed ETL mappings for the CDC change data capture
• Trained end users in using full client BO for analysis and reporting.
• Wrote SQL Scripts and PL/SQL Scripts to extract data from Databases
• Extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Environment: Informatica Power Center 8.6.0/8.1.1 , DB2, Erwin 4.0, UNIX Shell Scripting, Oracle 9i/10g/11g, PL/SQL, Business Objects XI R2,SQL Server 2005/2008, Teradata SQL,Korn Shell Scripting, Teradata Utilities(BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD), Netezza Database, Tivoli Workload Scheduler 8.4, TOAD 9.7.2, Tibco.

Confidential, Chicago, IL

Database programmer

Responsibilities:

• Worked as a technical support for a team that involved technical & quality reviews of program codes and PL/SQL blocks for optimization and maintaining standards & guidelines
• Developed Database Triggers in order to enforce complicated business logic and integrity constraints, and to enhance data security at database level
• Involved in Business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications.
• Designed and developed the ETL Mappings for the source systems data extractions, data transformations, data staging, movement and aggregation.
• Worked on Informatica Power Center 6.1. 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, Mapplets and Transformation Developer.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Promoted the new code to production through unit and system testing

Environment: Informatica Power Center 6.1, SQL Server, Oracle 8i, DB2, SQL/PLUS, ERWIN, Windows XP, UNIX.