SUMMARY:

• 7+ years of Strong data warehousing experience with extensive knowledge in SDLC: Data Analysis, Design, Development, Implementation and Testing using Data Extraction, Data Transformation and Data Loading (ETL) using Informatica Power center 9.5/9.1.1/8.6/8.1/7.1.
• Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio.
• Experience in BI / Data warehouse projects involving Informatica and Cognos suite of products.
• Experience in working with data warehouses and data marts using Informatica Power center (Designer, Repository Manager, Workflow Manager, and Workflow Monitor).
• Understanding & Working knowledge of Informatica CDC (Change Data Capture).
• Worked as a Technical Team Lead to help my team members resolving any issue related to coding, testing, performance tuning in developing Informatica mappings and workflows.
• Proficient in designing and developing complex standard and re - usable mappings and mapplets using various transformation logics by utilizing the expression, filter, joiner, lookup, router, rank, normalizer, aggregator.
• Expertise in unit testing at various levels of the ETL as well as SQL, UNIX etc.
• Developed Strategies for Extraction Transformation Loading (ETL) mechanism.
• Extensive experience in analyzing the Dimensional Data modeling, Star Schema/Snowflake Schema, modeling, FACT & Dimensions tables, Physical & logical data.
• Experience in developing OBIEE/Siebel Analytics Repository (.rpd) - three layers (Physical Layer, Business Model & Presentation Layer).
• Experience in customizing reports, dashboards, filters and charts in Oracle Answers.
• Extensive work with PL/SQL, performance tuning of Oracle.
• Experienced with Informatica Power Exchange (5.x/8.x/9.x) for Loading/Retrieving data from mainframe systems.
• Good experience with configuring Data Warehouse Administration Console (DAC) for creating execution plans, metadata management and monitoring the Informatica ETL Process.
• Configured and registered the custom workflows in DAC.
• Worked with Data warehouse Administration Console (DAC) to schedule and run full and Incremental ETL loads, to schedule the Informatica jobs, and to customize Execution Plans.
• Experienced Oracle Apps (Oracle E-Business Suite).
• Experience in Data Modeling experience using ERWIN 3.x
• Experience with Sybase as the target for the data marts.
• Extensive Unix Shell Scripting knowledge.
• Extensive experience with relational databases (Sybase 15.x, Oracle 8i/9i/10g, Teradata v2 R6, SQL Server 2000/2005).
• Strong understanding in the principles of Data ware housing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, Slowly changing dimensions, foreign key concepts, referential integrity.
• Maintained outstanding relationship with Business Analysts and Business Users to identify information needs as per the business requirement Experience working with Onside-Offshore model.

SKILL SET:

ETL Tools: Informatica Power Center 9.1/8.6.1.1/7.1.2/6.2/6.1/5.1 , Power Mart 5.0/4.7, Dataware House Builder, Abintio.

Operating Systems: Windows XP/2000/NT/98/95, Windows 2003 server, Unix, MSDOS

RDBMS: Oracle 11g,10g/9i/8i/8.0, MS-SQL Server 2005/2000/7.0/6.5

Data Modeling: Erwin 4.1.4/3.5.2

Data Base Tools: SQL Loader, Toad 4.0.3, MS Visio, MS Access

Reporting Tools: Business Objects XI/6.x/5.x, OBIEE 10.x/9.x; Power play and Transformer.

Scripting: UNIX Shell Scripting

Web Technology: Web Technology HTML, Java script

Languages: SQL, PL/SQL, C, C ++, Java 1.2, XML.

PROFESSIONAL EXPERIENCE:

Confidential, Newark, NJ

Sr. ETL Developer

Responsibilities:

• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Designed Informatica mappings by translating the business requirements.
• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Developed mappings for customers, Investments and Risk analysis.
• Developed reusable Transformations.
• Widely used Informatica client tools -- Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
• Used look up, router, filter, joiner, stored procedure, source qualifier, aggregator and update strategy transformations extensively.
• Assisted in adding Physical conceptual data model using Erwin 4.0.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Done extensive bulk loading into the target using Oracle SQL Loader.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.
• Involved in the process design documentation of the DW Dimensional Upgrades. Installed, and Documented the Informatica Power Center setup on multiple environments.

Environment : Informatica Power Center 9.5, Work Flow Manager/Monitor, Erwin 4.0, Oracle 10g/9i, SQL, PL/SQL, TOAD, SQL * Loader, UNIX /LINUX Shell Scripting, DB2, Microsoft SQL Server 2012, Tivoli Scheduling Tool, OBIEE.

Confidential, Chantilly, VA

Sr. ETL Developer

Responsibilities:

• Interacted with business analysts, architects and application developer to analyze the data model and gathered the requirements.
• Involved in Code reviews and determining Informatica standards for Mappings/Sessions/ Workflows.
• Created reusable transformations and mapplets and used them in mappings.
• Implemented the slowly changing dimensions (SCD) type1 and type2 to maintain current information and history information in the dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, SQL, Union, Lookup, Joiner, XML Source Qualifier, Unconnected lookup transformations.
• Created shell scripts to kick off Informatica workflow/s and PL/SQL procedures.
• Created Database Triggers, Stored Procedure, Functions and Packages.
• Extensively used debugger to trace the errors.
• Extensively tested the code and documented the Unit Test Cases.
• Assisted the testers in system and integration testing and preparing the test cases and test plan.
• Taking the backup of the repository at regular interval depending on the amount of work done.
• Extensively used UNIX scripts for automation of ETL process.
• Extensively worked on tuning mappings and reducing processing times.
• Worked with DBA to identify source and target bottle necks.
• Analyzed existing requirements and consolidated the reports for effective and efficient reporting.
• Involved in production support for the data warehouse Informatica jobs.
• Involved in bug fixing. Debugged the issues during QA level.

Environment: Informatica Power Center 9.5, Sybase 15.x, CA Scheduling, DBArtisian 9.0, YART1.0, UNIX /LINUX Shell Scripting, Tortoise SVN, Putty, Toad, OBIEE.

Confidential, Virginia Beach, VA

Sr. DW ETL Informatica Consultant

Responsibilities:

• Interacting with Business Analysts to understand the requirements
• Analyzing the requirements and preparing design.
• Involved in ETL designing and coding. Extensively used ETL to load data from Oracle database, SQL server, and Flat files to Teradata Data Warehouse.
• Reviewed the logical model with Business users, ETL Team, DBA’s and testing team to provide information about the data model and business requirements.
• Involved in production support for the Data Warehouse Informatica jobs.
• Modified the existing mappings and workflows as per requirement changes and migrated them back to production environment.
• Created robust and complex workflow and Worklets using Informatica Workflow Manager and troubleshot data load problems
• Wrote SQL Queries, Triggers and Shell Scripts to apply and maintain the Business Rules.
• Translated business requirements into Informatica mappings/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.
• Used Informatica Designer to create complex mappings using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Filter and Router transformations to pipeline data to Data Warehouse/Data Marts.
• Developed Mappings to extract data from ODS to Data Mart, and monitored Daily, Weekly and Monthly Loads.
• Designed and developed unit test cases for system integration testing.
• Involved with the users in the creation of test scripts for the user acceptance testing
• Developed some scripts to take weekly backups of certain tables using korn shell and import/export utilities.
• Worked on tuning some individual mappings and oracle queries that causing performance bottlenecks.
• Written documentation to describe program development, logic, coding, testing and changes made.
• Created and monitored Sessions/Batches using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.
• Worked with mapping variables, Mapping parameters and variable functions like set variable, Count Variable, Setminvariable and Setmaxvariable.
• Monitored incremental and full load of data extraction through Data Warehouse Administration Console (DAC) and Informatica.

Environment: Informatica Power Center 9.5/9.1, Teradata 13 1, SQLServer 2005, Tidal, Mercury Quality Centre 10.1, DAC, PL/SQL, OBIEE 10g, Toad, UNIX Shell Scripts.

Confidential, Richmond, VA

Sr. ETL Consultant

Responsibilities:

• Interacted with business analysts, architects and application developer to analyze the data model and gathered the requirements.
• Analyzed existing requirements and consolidated the reports for effective and efficient reporting.
• Extensively worked on tuning mappings and reducing processing times.
• Involved in Code reviews and determining Informatica standards for Mappings/Sessions/Workflows.
• Met with end users to gather requirements.
• Translated business requirements into Informatica mappings/workflows .
• Created various transformations such as Normalizer, Union, Aggregator, Update Strategy, Look Up, Joiner, Filter and Router Transformations.
• Involved in Performance tuning. Identified and eliminated bottlenecks (source, target, and mapping).
• Proficient experience in working on conceptual, physical and logical data models(3NF) using various Data Modeling tools like Erwin, MS Visio, Power Designer.
• Created shell scripts to kick off Informatica workflows and PL/SQL procedures.
• Used DAC (Data warehouse Administration Console) for both incremental and full loads.
• Created Database Triggers, Stored Procedure, Functions and Packages.
• Extensively used debugger to trace the errors.
• Extensively tested the code and documented the Unit Test Cases.
• Created UNIX scripts for automation of ETL process.
• Assisted the testers in system and integration testing and preparing the test cases and test plan.
• Trained on building Conceptual, Logical and Physical data model
• Taking the backup of the repository at regular interval depending on the amount of work done.
• Worked with DBA to identify source and target bottle necks.
• Involved in bug fixing. Debugged the issues during QA level.

Environment: Informatica Power Center8.6.1/9.1, SQL Server 2005, Control M, Oracle 10g, PL/SQL, Business Objects XIR2, DAC, Toad, Linux, UNIX Shell Scripts.

Confidential, Deerfield, IL

Sr. Informatica Developer

Responsibilities:

• Designed and developed slowly changing dimensional model for reference tables.
• Extensively used ETL to load data from sequel server database, Flat files to Data Warehouse
• Used Informatica Power Connect to directly source and integrate enterprise data.
• Used Informatica Designer to create complex mappings using different transformations like filter, Router, lookups, stored procedure, joiner, update strategy, expressions and aggregator transformations to pipeline data to Data Warehouse/Data Marts.
• Modified the existing mappings and workflow as per requirement changes and migrated them back to production environment
• Created robust and complex workflow and workletsusing Informatica workflow manager and troubleshooting data load problems.
• Created Database Triggers, Stored Procedure, Functions and Packages.
• Extensively worked in the performance tuning of programs.
• Pmcmd commands of Informatica in UNIX scripts.
• Designed and developed a process to load Historical data.
• Prepared estimates and tracked each and every task and strictly adhered to the estimated deadlines.
• Extensive knowledge in promoting packages (code) across development, test, preproduction and production environment using tools like Computer Associate Harvest package.
• Extensive knowledge in promoting packages (code) across development, test, preproduction and production.
• Preparation of Test Data/Unit Testing /Integrated testing and generated various test cases.
• Involved in different Team review meetings.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Communication with the client for weekly status report.

Environment: Informatica PowerCenter8.1, SQL server 2005, Autosys, Oracle 10g, PL/SQL, Toad, Business Objects 6.0, Windows NT, UNIX Shell Scripts.

Confidential

ETL Analyst

Responsibilities:

• Extensively used ETL to load data from Oracle database, Flat files to Data Warehouse.
• Involved in production support for the data warehouse Informatica jobs.
• Modified the existing mappings and workflows as per requirement changes and migrated them back to production environment.
• Automated Reports and generated documents using Scheduler.
• Created robust and complex workflow and work lets using Informatica workflow manager and troubleshoot data load problems.
• Wrote SQL Queries, Triggers and Shell Scripts to apply and maintain the Business Rules.
• Translated business requirements into Informatica mappings/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.
• Used Informatica Designer to create complex mappings using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Filter and Router transformations to pipeline data to Data Warehouse/Data Marts.
• Involved in Performance tuning. Identified and eliminated bottlenecks (source, target, and mapping).
• Developed Mappings that extract data form ODS to Data mart and Monitored the Daily, Weekly and Monthly Loads.
• Created and monitored Sessions/Batches using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.

Environment: Informatica Power Center 7.1.2, Oracle 9i, PL/SQL, Toad, OBIEE, DAC, Windows NT, UNIX Shell Scripts.