SUMMARY:

• Around 8 years of work experience in Information Technology as Informatica Developer with strong background in ETL Data warehousing experienced using Informatica Power Center 9.x/8.x/ 7.x. Informatica IDQ 9.X, MDM.
• I have good experience in Informatica Installation, Migration and Upgrade Process.
• Expertise in defining and configuring Informatica MDM Hub configurations - Data Mappings, Data Validations (landing, staging and base objects).
• Expertise in Informatica IDQ Match and Merge Rules, Batch Jobs and Groups and Proactive Monitoring tool.
• Extensive experience in Data warehousing, Data Analysis, Data Profiling, Reporting, Development, Maintenance, Testing and Documentation.
• Experience in using Informatica Power Center Transformations such as Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Experience in integration of various data sources like SQL Server, Oracle, Flat Files, and XML files.
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2, type3.
• Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine-tuned transformations to make them more efficient in terms of session performance.
• Database experience using Oracle 11g/10g/9i, Teradata, MS SQL Server 2008/2005/2000 and MS Access.
• Experience in UNIX Operating System and Shell scripting.
• 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 and Data warehouse using Informatica Power Center.
• Used Debugger in Informatica Power Center Designer to check the errors in mapping
• Experience in writing complex SQL queries.
• Excellent skills in fine tuning the ETL mappings in Informatica.
• Actively involved in Daily check in meetings to discuss on the production issues and resolved
• 24*7 Production Support to fix data quality issues and also supported ETL failures
• Extensive experience using database tool such as SQL *Plus, SQL *Developer, Autosys and TOAD.
• Effective working relationships with client team to understand support requirements, and effectively manage client expectations.
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.
• Managing Amazon Web Services (AWS) infrastructure with automation and configuration management

TECHNICAL SKILLS:

ETL Tools: Informatica 9.x/8.x/7.x (Power Center/Power Mart) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect) Informatica Data Quality (IDQ), Data Quality/IDE.

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams.

Databases: Oracle 11g/10g/9i/8i,Teradata,MS SQL Server 2008/2005/2000, MS Access and DB2

Languages: PLSQL,SQL, C,C++,Data Structures, Unix Shell Script, Visual Basic

Web Technologies: XML,HTML, Java Script, AWS

Tools: Toad, SQL* Developer, Autosys, ERwin

Operating Systems: Windows Server, NT/2008/2003/XP/Vista/7, UNIX, MS-DOS and Linux

PROFESSIONAL EXPERIENCE:

Confidential, NC

Senior ETL Developer

Responsibilities:

• Involved in the design, development and implementation of the Enterprise Data Warehousing (EDW) process.
• Provided data warehouse expertise including data modeling, Extract, Transform and Load (ETL) analysis, design and development.
• Hands-on Experience in working with Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets to extract, transform and load data.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Creating mappings with different transformations like Parser transformation, Standardizer transformation, Address Validator in Informatica developer (IDQ) tool.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Worked with various Active and Passive transformations like Source Qualifier, Sorter, Aggregator, Filter, Union, and Router Transformations, Sequence Generator and Update Strategy Transformations.
• Handled versioning and dependencies in Informatica.
• Developed schedules to automate the update processes and Informatica sessions and batches.
• Resolving technical and design issues.
• Developed data transformation processes, maintain and update loading processes.
• Developed and implemented the UNIX shell scripts for the start and stop procedures of the sessions.
• Used UNIX shell scripts to run the batches.
• Developed standards and procedures to support quality development and testing of data warehouse processes.
• Actively involved in Daily check in meetings to discuss on the production issues and resolved
• 24*7 Production Support to fix data quality issues and also supported ETL failures

Environment: Informatica 9.5.1, Informatica Data Quality (IDQ), MDM, Oracle11g, SQL Server 2008, Autosys, Windows Server 2008, UNIX.

Senior ETL Developer

• Analyzed the business systems, gathered requirements from the users and documented business needs for decision supporting data.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Created the (ER) Entity Relationship diagrams & maintained corresponding documentation for corporate data dictionary with all attributes, table names and constraints.
• Designed & developed multiple cleanse function, Graph function and standardization scenarios using IDQ.
• Analyzed data from a variety of data sources to present a cohesive view of the data and completed data profiling using IDE on various source systems to understand the data.
• Involved in integrating the change in the workflow to both test and allow error handling using Informatica IDQ 9.5 and developed solutions based on the data governance.
• Extensively used Full Pushdown Optimization in Informatica to performance for DB loads.
• Prepared technical documentation to map source to target.
• Designed, Developed, Deployed and implemented ETL mappings using Informatica
• Migrated Workflows, Mappings, and other repository objects from Development to QA and then to production.
• Responsible for performance tuning at all levels of the Data warehouse.
• Created Informatica sessions in workflow manager to load the data from staging to Target database.
• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Using Aggregator transformation calculated SUM, AVG of monthly sales for different products.
• Created different target schemas for Staging and Data Mart.
• Designed the Mapping Design documents and the Deployment Documents.
• Designed and Developed several mappings to Load the Dimensions and the fact tables using transformations like XML, Union, Expression, Filter, Aggregator, Lookup and Router etc.
• Worked with Flat files and XML files generation through ETL process
• Generated XML files as target to load into the vendor customized application to generate the reports.
• Involved in XML and XSLT coding in order to create the Front End screen insert activities
• Implemented Slowly Changing Dimensions Type1, Type 2.

Environment: Informatica 9.5.1, Oracle11g, IDQ, IDE Data Management, MDM, SQL Server 2008, TOAD, SQL Navigator, Windows Server 2008, UNIX.

ETL Developer

Responsibilities:

• Gathered user Requirements and designed Source to Target data load specifications based on business rules.
• Used Informatica Power Centre 9.0.1.for extraction, loading and transformation (ETL) of data in the datamart.
• Creating mappings with different transformations like Parser transformation, Standardizer transformation, Address Validator in Informatica developer (IDQ) tool.
• Used Address validator transformation in IDQ and passed the partial address and populated the full address in the target table
• Performed and used data profiling tools (IDE) and techniques, and development of review and QA data requirements.
• Integrated the change in the workflow to test and allow error handling using Informatica IDQ and developed solutions based on the data governance.
• Designed and developed ETL Mappings to extract data from Flat files and Oracle to load the data into the target database.
• Developing several complex mappings in Informatica a variety of Power enter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica Power enter.
• Built complex reports using SQL scripts.
• Created complex calculations, various prompts, conditional formatting and conditional blocking etc., accordingly.
• Created complex mappings to load the data mart and monitored them. The mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Union, Normaliser and Sequence generator transformations.
• Design roles and groups for users and resources using AWS Identity Access Management (IAM).
• Ran the workflows on a daily and weekly basis using workflow monitor.

Environment: Informatica 9.0.1, Informatica Data Quality (IDQ),IDE, Data Quality, MDM,PL/SQL, AWS, Framework Manager, Transformer, Teradata, Oracle 11g, TOAD, Windows Server 2008, UNIX.

ETL Developer

Responsibilities:

• Participated in all phases of system development life cycle from requirements gathering to deployment of the finished system into production followed by maintenance and knowledge transfer tasks.
• Gathered requirements by analyzing source systems and identification of business rules through regular requirements gathering sessions with business users and other support teams for various OLTP and OLAP systems.
• Used Power Center Designer to design the business process, grain of the data representation, dimensions and fact tables with measured facts.
• Extensively used Transformations like lookup, Router, Filter, Joiner, Source qualifier, Aggregator, Update strategy, Etc.
• Involved in performance tuning of sessions that work with large sets of data by tweaking block size, data cache size, sequence buffer length and target based commit intervals.
• Developed sessions and batches to move data at specific intervals and on demand using workflow manager.
• Participated in deployment planning and in deployment of the system to production.
• Facilitated business user smoke testing of the production system by setting up test data.
• Involved in production support duties including monitoring of nightly batches.
• Responsible for updating business stakeholders and OLTP/OLAP application support teams about the status of various ETL sessions and the impact of failed sessions on data availability.

Environment: Informatica Power Center 9.1., Oracle10g, SQL*PLUS, TOAD, DB2, UNIX, Windows

Informatica Developer

Responsibilities:

• Based on the requirements created Functional design documents and Technical design specification documents for ETL Process.
• Developed mappings and mapplets using Informatica Designer to load data into ODS from various transactional source systems.
• Used Informatica Designer to import the sources, targets, create various transformations and mappings for extracting, transforming and loading operational data into the EDW from ODS.
• Used various transformations such as expression, filter, rank, source qualifier, joiner, aggregator and Normalizer in the mappings and applied surrogate keys on target table.
• Used the Informatica Server Manager to register and monitor the server, create and run the sessions/batches for loading the data using the earlier created mappings.
• Created mapplets and reusable transformations.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Migrated mappings from Development to Testing and performed Unit Testing and Integration Testing.

Environment: Informatica Power Center 8.x, Repository Manager, Designer, Oracle 8i, SQL, UNIX, Win 2000/NT.

Database Developer

Responsibilities:

• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Writing queries to fetch data from the OLTP system and executed at regular intervals of time.
• Modified existing forms, reports, and graphs as per the enhancement.
• The backend was in Oracle and database operations were handled using stored procedures.
• Worked on all phases of multiple projects from initial concept through research and development, implementation, QA, to live production, by strict adherence to project timelines.
• Moved data from one database to other database, Used SQL*Loader for data migration.

Environment: Oracle 8i, SQL, TOAD, UNIX, Windows 2000/03/NT

Accounting System

Responsibilities:

• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Writing queries to fetch data from the OLTP system and executed at regular intervals of time.
• Modified existing forms, reports, and graphs as per the enhancement.
• Worked on all phases of multiple projects from initial concept through research and development, implementation, QA, to live production, by strict adherence to project timelines.
• Moved data from one database to other database, Used SQL*Loader for data migration.

Environment: Oracle 8i, SQL, TOAD, Windows.s