SUMMARY

• Over 7 years of experience in Information Technology as Informatica Developer/Lead/ Architect with strong background in ETL Data warehousing experience using Informatica Power Center 9.x/8.x/7.x/6.x/5.x.
• Experienced in Planning, Designing, and Developing and Implementing Data warehouses/Datamarts with experience of both relational & multidimensional database design.
• Extensive experience in developing complex mappings from varied transformations like Source Qualifier, SQL, Connected and Unconnected lookups, Router, Filter, Sorter, Expression, Aggregator, Joiner, Union, Update Strategy, Sequence Generator, Web services and XML transformations etc.
• Experienced in Informatica Administration tasks using Admin Console and Repository Manager.
• Experienced in Metadata Manager for documenting ETL process and to integrate and consolidate meta data from different resources.
• Experienced in Informatica Power Exchange with Change Data Capture (CDC) for extracting data from Oracle.
• Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional data modeling (Star Schema, Snow Flake Schema, FACT & Dimension Tables), OLAP.
• Experienced in developing High Level Design (HLD) and Low Level Design (LLD) for Data Warehouse Applications.
• Experience with the Informatica Data quality and Master Data Management products.
• Designed developed and implemented Master Data Management solution Customer Party MDM Domain using MDM 9.6.1.
• Worked with different sources like Flat Files and varied RDBMS.
• Using the data Integration tool Pentaho for designing ETL jobs in the process of building Data warehouses and Data Marts.
• Good Experience in creating cubes by using Pentaho Schema Workbench.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS) and Informatica.
• Experienced in performing Incremental Loads and Data cleaning in SSIS.
• Expert in handling errors, logging using Event Handlers using SSIS.
• Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and tuning the SQL queries.
• Handful experience working with various databases like Oracle, TeraData, UDB DB2, Microsoft SQL Server, Sybase, Microsoft Access as Sources & Targets.
• Expertise in developing SQL & PL/SQL codes through various procedures, functions, packages, triggers, views and indexes to implement the business logics.
• Strong knowledge in UNIX Shell scripting to automate data warehouse jobs.
• Worked with various SQL Editors such as TOAD, SQL Plus, and Query Analyzer.
• Effective working relationships with client team to understand support requirements, and effectively manage client expectations.
• Team player with good communication skills, written skills, technical documentation skills and also a self - motivated individual with exemplary analytical and problem solving skills.

TECHNICAL SKILLS

Data Integration Tools: Informatica Powercenter, MDM, IDQ, SSIS, Web Services, Data Analyst, Pentaho.

Languages: SQL, PL/SQL, Forms 6i, C, C++, Java, JSP, XML, EJB.

RDBMS: Oracle 9i/10g/11g/12, SQL Server 2000 and Sybase 10.0.

Data Modelling Tools: Erwin, ER Studio.

Reporting Tools: Crystal Reports, Reports 6i, Cognos, Business Objects.

Other Tools: SQL *Loader, TOAD and Oracle Workflow. Visual Source Safe, MS Project plan, Visio, JIRA.

Operating Systems: Windows/98/NT/2000/XP/7 and UNIX, Red Hat Linux Environments.

Scheduling Tools: Tidal, Autosys.

PROFESSIONAL EXPERIENCE

Confidential, NY

Project Analyst/Informatica Developer

Responsibilities:

• Involved in requirement gathering and analysis, after multiple discussions with the MLBAM Team and business analyst.
• Design and develop technical design and ETL frame work for the project using MS Visio.
• Documenting user requirements, Translate requirements into system solutions and developed implementation plan and schedule.
• Responsible for reviewing Business Requirement document.
• Translated user requirements into system solutions.
• Involved in Data Analysis of the OLTP system to identify sources data elements.
• Prepared Technical Specification Document.
• Prepared Source to Target ETL mapping Documents.
• Designed and developed Informatica Mappings, Reusable Sessions, Worklets, Workflows, Dynamic Parameter files.
• Provided solutions for various performance bottle necks in Informatica Mappings.
• Coding UNIX scripts and ParamFiles for implementing business rules.
• Created Receive, Send ports and Locations using Different BizTalk Adapters which comes out of the Box.
• Consumed and published the web Services and used various adapters like FTP, HTTP, FILE, SQL, Soap Adapters.
• Created complex mappings with Indirect file list methodology.
• Used Pentaho Data Integration Designer to create ETL transformations.
• Good knowledge in designing ETL scripts using PDI to extract the data from two different systems to populate BI data mart.
• Cleanse and Scrub the Data in uniform data type and format applying MDM Informatica andIDQtools and Load to STAGE and HUB tables and then to the EDW and Finally to Dimension and rollup/aggregate the data by the business grains into the FACT tables.
• Handled extraction of various types of source files Flat files, XML standard source data of different transactions and loading to staging area.
• Worked on data cleansing by creating SSIS packages against the Flat Files.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the legacy databases to SQL server.
• Have written lots of SQL Scripts in Pre-SQL and Post-SQL session tasks.
• Building complex views based on various business rules out of the staging tables to extract data in a more faster and efficient manner
• Created Batch jobs, scheduled them.
• Developed and implemented Audit control and Exception control Strategies.
• Used InformaticaIDQ 8.6.1to complete initialdata profiling and matching/removing duplicate data.
• Informatica Data Quality (IDQ) is the tool used here for data quality measurement.
• Created test cases and pseudo test data to verify accuracy and completeness of ETL process.
• Involved in Unit testing, System Integration testing, User Acceptance Testing.
• Involved in Informatica Code Migration across various Environments.
• Involved in Production Support and Knowledge Transfer sessions.

Environment: Informatica 9.6.1, IDQ 9.6.1, Informatica Multidomain MDM 9.6.1, Oracle 11g, Netezza, PL/SQL, SQL*loader, TOAD, Unix and Windows 7, Embarcadero Data Architect XE4, JIRA, BizTalk, MS Project Plan, MS Visio, Tidal.

Confidential, NY

Project Analyst /Informatica Developer

Responsibilities:

• Discussed business requirements and mapped business needs.
• Designed and constructed the pre-staging tables to populate from different source system.
• Written PL/SQL packages, procedures and functions and developed Informatica Mappings to perform test loads.
• Involved in Preparing Source-Target Mappings documents to provide the logic for Informatica mappings development.
• Implemented Error Handling strategy for trapping errors in Mapping, Date Validation, and Data type mismatch.
• Used Transformations like Source Qualifier, Joiner, Aggregator, Expression, Router, Lookup, Update Strategy, and Sequence Generator etc.…
• Implemented Performance tuning in Mappings and Sessions by identifying the bottlenecks and Implemented effective transformation Logic.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
• Designed the system so that the streams can run independently thereby causing minimal impact to the users.
• Created test cases and pseudo test data to verify accuracy and completeness of ETL process.
• Involved in Unit testing, System Integration testing, User Acceptance Testing.
• Involved in Informatica Code Migration across various Environments.
• Involved in Production Support and Knowledge Transfer sessions.

Environment: Informatica 9.6.1, IDQ 9.6.1, Informatica Multidomain MDM 9.6.1, Oracle 11g, Netezza, PL/SQL, SQL*loader, TOAD, Unix and Windows 7, Embarcadero Data Architect XE4, JIRA, MS Project Plan, MS Visio, Tidal, Business Objects.

Confidential

Project Analyst

Responsibilities:

• Coordinated with Business Relationship team and business partners in the creation of Business Intelligence functional requirements.
• Created source to target data mapping documents.
• Developed Informatica ETL mappings and workflows.
• Designed and developed Informatica mappings for data loads, data cleansing.
• Extensively used transformations like Joiner, Expression, Connected/Unconnected lookups, and Filter, Aggregator, Rank, Update, Router, Stored Procedure, Normalizer and Sequence generator.
• Designed Mapplets to encapsulate re-useable code.
• Fine-tuned Informatica mappings for performance optimization.
• Resolved Logical, Design Errors in mapping with the help of Debugger and different Log files.
• Developed Informatica mappings for Slowly Changing Dimensions with (merging and repairing).
• Responsible for migration of code from one environment to other.
• Provided Production support. Was actively involved in troubleshooting the issues related to ETL and reporting that occur on day-day basis.
• Wrote PL/SQL Procedures, Packages and Shell Scripts to apply and maintain the Business Rules. Created and executed Sessions and Batches using Server Manager.
• Developed reusable mappings using Mapplets Designer.
• Involved in Setting up Environments for Development, Test and UAT, which involved Configuring Informatica, Rep Server and running full loads in all the three environments.
• Involved in fine-tuning the ETL mapping by studying the session logs and coming up with a better strategy to deal with bottlenecks such as time involved in building the cache.
• Created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers

Environment: Informatica 9.6.1, Oracle 11g, Netezza, PL/SQL, SQL*loader, TOAD, Unix and Windows 7, Embarcadero Data Architect XE4, JIRA (Task/Work Management), MS Project Plan, MS Visio, Tidal

Confidential

Project Analyst

Responsibilities:

• Analyzed the source data, Coordinated with Data Warehouse team in developing Relational Model. Designed and developed logical and physical models to store data retrieved from other sources including legacy systems.
• Extensively used All Fusion-ERwin for Logical / Physical data modeling and Dimensional data modeling, and designed Star join schemas.
• Designed and developed Star Schema, Snowflake Schema and created Fact Tables and Dimension Tables for the Warehouse and Data Marts and Business Intelligence Applications using ERwin Tools.
• Used Informatica Repository Manager to create Repositories and Users and to give permissions to users.
• Used Informatica Designer to create mappings using different transformations to move data to a Data Warehouse.
• Designed and Developed mappings in Informatica using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Router, Rank, Filter and Sequence Generator transformations.
• Created Update Strategy and Stored Procedure transformations to populate targets based on business requirements.
• Created and Configured Workflows, Worklets and Sessions to transport the data using Workflow Manager.
• Scheduled the sessions to extract, transform and load data into warehouse database as per Business requirements. Improved the session performance by pipeline partitioning.
• Implemented Slowly Changing dimension methodology for accessing the full history of accts & transaction info.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Developed Procedures and Functions in PL/SQL for Data ETL.

Environment: Informatica 9.6.1, Oracle 11g, Netezza, PL/SQL, SQL*loader, TOAD, Unix and Windows 7, Embarcadero Data Architect XE4, JIRA (Task/Work Management), MS Project Plan, MS Visio, Tidal

Confidential

Project Analyst

Responsibilities:

• Involved in different phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment.
• Handled the ETL related activates by interacting with onsite team on a regular basis.
• Have worked on requirement gathering and E/R modeling.
• Have worked on performance tuning by collecting statistics and observing explain plan.
• Created source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.
• Developed source to target mappings and scheduling Informatica sessions.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Worked in Oracle SQL, PL/SQL, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms, and Sequences etc., closely worked with DBAs to create Physical Databases.
• Involved in designing the Data mart and entire data warehousing life cycle.
• Involved and Worked with DBA to build Dimension Tables and Fact Tables.
• Interacted extensively with user and Involved in gathering requirements, prototyping and prepared various documents like Interface Requirement Document, Customer Requirement document, Integration test plan, Unit test plan Release notes etc.

Environment: Informatica 9.6.1, Oracle 11g, PL/SQL, SQL*loader, SharePoint, Unix and Windows 7, Embarcadero Data Architect XE4, JIRA (Task/Work Management), MS Project Plan, MS Visio, Tidal

Confidential

Sr. ETL Developer

Responsibilities:

• Involved in Data modeling and design of data warehouse in star schema methodology with confirmed and granular dimensions and FACT tables.
• Extracted data from sources like DB2, Oracle and Fixed width and Delimited Flat files Transformed the data according the business requirement and then Loaded into the Oracle Database
• Modified several of the existing mappings and created several new mappings based on the user requirement.
• Created Mappings using Mapping Designer to load the data from various sources using different transformations like Aggregator, Expression, Stored Procedure, External Procedure, Filter, Joiner, Lookup, Router, Sequence Generator, Source Qualifier, and Update Strategy transformations.
• Created Mapping Parameters and Variables.
• Handled operating system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Created and Scheduled Sessions and Batch Processes based on demand using Informatica Server Manager.
• Involved in Optimizing the Performance by eliminating Target, Source, Mapping, and Session bottlenecks.
• Used pmcmd command to run sessions.
• Design and create tables, views, materialized views, triggers, stored procedures, and packages
• Fine-tuning of SQL queries and views by passing hints and analyzing them using plan table
• Tuned the process flow that takes about 4 hours to 20 min by turning the CACHE on.
• Worked on converting this to Informatica.

Environment: Oracle 9i/10g, Oracle Warehouse Builder 10g(r2), Oracle Workflow 2.6.4, SQL*Plus, OMB Plus, PL/SQL, SQL*loader, TOAD, Unix and Windows 2000/XP, Embarcadero ERStudio 6.5.

Confidential

Sr. ETL Developer

Responsibilities:

• Involved in Data modeling and design of data warehouse in star schema methodology with confirmed and granular dimensions and FACT tables.
• Extracted data from sources like DB2, Oracle and Fixed width and Delimited Flat files Transformed the data according the business requirement and then Loaded into the Oracle Database
• Modified several of the existing mappings and created several new mappings based on the user requirement.
• Created Mappings using Mapping Designer to load the data from various sources using different transformations like Aggregator, Expression, Stored Procedure, External Procedure, Filter, Joiner, Lookup, Router, Sequence Generator, Source Qualifier, and Update Strategy transformations.
• Created Mapping Parameters and Variables.
• Handled operating system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Created and Scheduled Sessions and Batch Processes based on demand using Informatica Server Manager.
• Involved in Optimizing the Performance by eliminating Target, Source, Mapping, and Session bottlenecks.
• Used pmcmd command to run sessions.

Environment: Oracle 9i/10g, Oracle Warehouse Builder 10g(r2), Oracle Workflow 2.6.4, SQL*Plus, OMB Plus, PL/SQL, SQL*loader, TOAD, Unix and Windows 2000/XP, Embarcadero ERStudio 6.5.