PROFESSIONAL SUMMARY:

• 7+ years Data Warehousing experience using Informatica Power Center 9.x/8.x/7.x (Source and Target Analyzer, Mapplet Designer, Transformation Developer), Informatica PowerMart 6.x, Power Exchange, PowerConnect for Siebel/DB2.
• Excellent knowledge and experience in data warehouse development life cycle, requirements analysis, dimensional modeling, Repository management and administration, Documentation, implementation of STAR, Snowflake schemas, fact and dimension table modeling of data, Incremental loads/Change Data Capture and slowly changing dimensions across Banking, Financial and Manufacturing sectors.
• Thorough understanding of ETL Architecture and Business Intelligence, Data Warehousing Concepts with emphasis on ETL.
• Ability to write complex SQLs needed for ETL jobs and Data Analysis, and is proficient and worked with databases like Oracle 11x/10g/9i, SQL Server 2008/2005, DB2, MSSQL, Excel sheets, Flat Files, Sybase, COBOL,XML files.
• Experience in creating complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism by using Informatica.
• Managing Users and User Accounts on day to day basis so dat Users would give same privilege when repository is created.
• Hands on experience in working with Informatica Performance tuning involving source level, Target level and Map level Bottlenecks and involved in many Data Integration Projects.
• Proficient in using Informatica workflow manager, workflow monitor, server manager, pmcmd (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
• Developed complex mappings using various transformation logics like Aggregator, connected/unconnected Lookup, filter, joiner, union, update strategy and more.
• Experience in writing complex sub queries, PL/SQL programs (functions, procedures, packages), and shell scripting to run pre session and post session commands.
• Worked on very large databases and with heterogeneous data sources like Oracle, SQL Server, flat files, XML files, DB2 UDB, Main Frames and COBOL files.
• Experience in UNIX shell scripting, Perl scripting and automation of ETL processes using Tivoli, CTRL - M, CA workload automation Autosys.
• Proficient in Troubleshooting and doing Error handling using Log files.
• Experience in various features of Erwin like Forward Engineering and Reverse Engineering and ability to follow both Agile and Waterfall methodologies in Software Development Life Cycle (SDLC).
• Professional hands-on experience in data warehouse design, Data Modeling, Data Profiling, Data Analysis and database administration activities.
• Good exposure in projects with teh Onsite - Offshore model.
• Used various Index techniques to improve teh query performance.
• Excellent communication skills, problem solving ability, team player, ability to work individually and meet tight deadlines.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.1/8.6/8.5/8.1/7.1/6.x, Power Exchange, Data stage 6.5/7.1,SSIS, ODI 11g

RDBMS: Oracle 11g/10g/9i, SQL Server 2008/2005, IBM DB2 UDB 7.0, Teradata

Data Modeling: Relational and Dimensional Modelling(Star schema, Snowflake Schema, Facts and Dimensions), Erwin 3.5/4, Toad

OLAP and Reporting Tools: Cognos 8 BI (Report Studio, Query Studio, Transformer), SSRS

Database Languages: Trans-SQL, MySQL, SQL*Plus, PL/SQL, SQL*Loader

Operating Systems: UNIX (Sun Solaris), Windows 7/ XP/2003/2008.

PROFESSIONAL EXPERIENCE:

Confidential, Moline, Illinois

Sr.ETL/ Informatica Developer

Responsibilities:

• Prepared User Requirements Documentation for mapping and additional Functionality.
• Analyzed teh functional specifications provided by teh data architect and created Technical specification documents and Detail design documents for all teh mappings.
• Created Process flow for mappings and sessions.
• Expertise in configuration, performance tuning, installation of Informatica, & in integration of various data sources like Oracle, MS SQL Server, XML, Flat files into teh staging area and Design ETL processes dat span multiple projects.
• Responsible for Data Extraction and Transformation from disparate sources like Oracle, DB2, SQL Server, flat files, XML files and Loading to Oracle using Informatica Power Center.
• Involved in designing of Informatica Mappings by translating teh business requirements.
• Created Informatica maps using various transformations like Web services consumer, XML, HTTP transformation, Source Qualifier, Expression, Look up, Stored Procedure, Aggregate, Update Strategy, Joiner, Union, Filter and Router.
• Implemented complex business rules by creating reusable transformations, and robust Mappings/Mapplets.
• Used Dynamic Lookup transformation for implementing Slowly Changing Dimensions.
• Created Workflows using Workflow manager for different tasks like sending email notifications, timer dat triggers when an event occurs and sessions to run a mapping.
• Created Pipeline partitioning to improve Session performance and synchronizing teh target load rows throughout teh session run.
• Developed Pre SQL and Post SQL scripts for Informatica jobs, PL/SQL stored procedures and functions.
• Used teh Debugger to validate teh transformations by creating break-points and analyzing teh debug monitor.
• Involved in Performance Tuning and optimization of Informatica mappings and session.
• Used Informatica scheduler to schedule teh tasks.
• Scripts were run through UNIX shell programs in Batch scheduling.
• Created Test data and Unit test cases to ensure successful data loading process.

Environment: Informatica Power Center 9.1, Oracle 11g, PL/SQL, Windows 7, SQL Server 2008, UNIX, Informatica Job Scheduler.

Confidential, MA

ETL/Informatica Developer

Responsibilities:

• Worked on a Sales migration project from Mainframes to SQL Server.
• Involved in teh project from very starting stage of project till teh end and acted as Onsite Co-Ordinator.
• Analyzed teh functional specifications provided by teh data architect and created Technical specification documents and Detail design documents for all teh mappings.
• Created Migration Documentation and Process flow for mappings and sessions.
• Responsible for converting Mainframes segments to tables and from these tables data is being loaded according to flatfiles to SQL Server using Informatica PowerCenter.
• Responsible to migrate scheduled jobs from Control-M job scheduling tool to Autosys automation tool.
• Approximately 25 jobs have been rewritten based on teh requirements.
• Involved in configuration, performance tuning and integration of data sources like web services, Oracle, MS SQL Server, XML, Flat files into teh staging area and Design ETL processes dat span multiple projects
• Implemented complex business rules by creating reusable transformations, and robust Mappings/Mapplets.
• Used Dynamic Lookup transformation for implementing Slowly Changing Dimensions and synchronizing teh target load rows throughout teh session run.
• Created Workflows using Workflow manager for different tasks like sending email notifications, timer dat triggers when an event occurs and sessions to run a mapping.
• Used Informatica Web Services to support teh Feeds. Created and Used WSDL.
• Developed Pre SQL and Post SQL scripts for Informatica jobs, PL/SQL stored procedures and functions.
• Used teh Debugger to validate teh transformations by creating break-points and analyzing teh debug monitor.
• Involved in Performance Tuning and optimization of Informatica mappings and session.
• Scripts were run through UNIX shell programs in Batch scheduling.
• Created Test data and Unit test cases to ensure successful data loading process.
• Involved in build and release activities and successfully implemented in production
• Performed end to end testing of load from source to target.
• Wrote Unix Shell Scripts to automate teh processes.

Environment: Informatica Power Center 9.1, Web Services, Oracle 11g, Mainframes, PL/SQL, Windows 7, SQL Server 2008, UNIX, Control M, CA workload Automation Autosys.

Confidential

ETL Developer

Responsibilities:

• Involved in Data analysis, requirements gathering, function/technical specifications, development, deploying and testing.
• Involved in Data Profiling Using Data Explorer.
• Involved in all teh phases of project (Client Interaction, Gathering requirements from Business users, Preparation of detail design, Development, Unit Testing and Production support).
• Cleansed teh source data, extracted and transformed data with business rules, and built reusable transformation logic, known as ‘Mapplets’ using Informatica Designer.
• Modified several of teh existing mappings and created several new mappings based on teh user requirement.
• Successfully Loaded Data into different targets from various source systems like Oracle Database, Flat files, ODS, SQL Server, etc., into teh Staging table and then to teh target database Oracle.
• Successfully Integrated Multiple XML sources and created a de-normalized, flat-structured file.
• Used teh Debugger in debugging some critical mappings to check teh data flow from instance to instance.
• Created various tasks like sessions, work lets, and workflows in teh workflow manager to test teh mapping during development.
• Involved in Performance tuning of various mappings and sessions to increase teh performance.
• Loaded data files into Oracle E-Business Suite interface using PowerExchange option in Informatica.
• Extensively worked on tuning and theirby improving teh load time.
• Involved in teh error checking and testing of ETL Procedures using Informatica Session log and workflow logs.
• Proficient in teh Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into teh staging area, ODS, Data Warehouse and Data Mart.
• Developed teh mapping to pull teh information from different tables and used SQL Override to join teh tables instead of Joiner transformation to improve teh performance.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL. Scheduled sessions to update teh target data using Workflow Manager of Informatica.
• Developed all teh mappings according to teh design document and mapping specs provided and performed unit testing.
• Reviewed teh ETL mappings and data samples loaded in teh test environment for data validation.
• Developed reports using BI Dashboard and Answers, views & charts, created filters to obtain weekly sales for each region & send alerts to upper management.

Environment: Informatica Power Center 8.6 (Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor) Power Exchange, Windows XP, SQL Server 2005, Oracle 10g, Toad.

Confidential, Richmond, VA

ETL Developer

Responsibilities:

• Analyzed business requirements by interacting with teh business users and application development teams and also acted as Data Quality Analyst.
• Designed and developed teh ETL architecture to build and populate teh data marts using Informatica.
• Designed and developed Informatica mappings for data loads dat included web services consumer,Source Qualifier, Aggregator, Joiner, Lookup, Filter, Router, Update Strategy, Expression and Sequence Generator transformations.
• Used XML Parsers and Generators to handle inbound and outbound XMLs in Informatica.
• Designed Parameter driven Informatica sessions and workflows for extracting, cleansing, transforming and loading teh data from teh heterogeneous sources into teh data warehouse by using parameter files.
• Worked with complex Cognos reports in Report Studio using master-detail relationship, drill through, drill up and drill down, burst options, and Prompts.
• Implemented SCD Type 2 strategy to update teh Slowly Changing Dimensions and maintain teh OLAP tables storing history in teh data mart star schema
• Developed Informatica mappings to cleanse and remove duplicate rows from source data
• Used Conversion process for VSAM to ASCII source files using Informatica Power Exchange.
• Programmed Oracle SQL, T-SQL Stored Procedures, Functions, Triggers and Packages as back-end processes to create and update staging tables, log and audit tables, creating primary keys
• Used workflow manager for session management, database connection management and scheduling of jobs
• Improved performance by identifying teh bottlenecks in Source, Target, Mapping and Session levels.
• Performed Unit Testing and assisted QA team in Quality Assurance Testing, Load Testing and UAT, Performance estimation testing.
• Ensured teh execution of UAT test cases and documentation of test results.
• Analyzing business and functional requirement to design SIT and UAT Test Cases
• Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling review sessions (Erwin) for different user groups, participated in requirement sessions to identify requirement feasibility.
• Prepared functional and technical specification documents for teh ETL standards and strategy
• Developed views necessary for structured and ad-hoc reporting
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in teh repository and added users to teh groups and granted privileges explicitly and through group inheritance.
• Handled Full load and refresh load via staging tables in teh ETL Layer.
• Involved in Designing ERD using Star schema.
• Involved in Design and Data Modeling using Star schema.
• Used DAC (Data Warehouse Administration Console) Client to manage, configure, customize, and monitor ETL process.

Environment: Informatica Power Center 8.1, Power Exchange 8.1.1, Oracle 9i, DB2, Oracle Data Warehouse builder, XML, Flat files, Erwin 3.2, Cognos, Windows 2003, Toad.

Confidential

Informatica Developer

Responsibilities:

• Involved in designing and development of data warehouse environment.
• Responsible for data modeling using Business Object.
• Designed and developed several ETL scripts using Informatica, UNIX shell scripts.
• Extensively used all teh features of Informatica 7.x including Designer, Workflow manager, Repository Manager and Workflow Monitor.
• Developed and modified UNIX shell scripts to reset and run Informatica workflows using Pmcmd on Unix Environment. Conversant with teh Informatica API calls.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of teh system.
• Worked with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations.
• Partitioned sources to improve session performance.
• Extensively worked on Unix Shell Scripting, using pmcmd to automate teh process by Autosys on UNIX environment.
• Created flexible mappings/sessions using parameters and variables and heavily using parameter files.
• Improved session run times by partitioning teh sessions. Was also involved heavily into database fine tuning (creating indexes, stored procedures, etc), partitioning oracle databases.

Environment: Informatica Power Center 7.1, Oracle 9i/10g, PL/SQL, SQL*Plus, SQL Server, SQL*Loader, Business Object.