PROFESSIONAL SUMMARY:

• Over 8 + years of experience in all phases of software development life cycle including Design, Development & Testing of data transfers for Healthcare, Insurance and Finance Industries
• Experience working on End - To-End implementation of Data warehouse.
• Extensive experience with Data Warehousing and Business Intelligence applications using Informatica 10.x/9.x/8.x/7.x (Administrator, PowerCenter, Repository, Workflow Manager, Workflow Monitor)
• Proficient in data warehousing techniques to perform data profiling, data cleansing, data analysis, implementing slowly changing dimension
• Excellent SQL writing skills, worked on database technologies like Oracle, SQL server, DB2 coding, stored procedures, complex queries, triggers, functions .
• Created complex relational, dimensional data models from by leading discussions with business groups using Erwin tools. Converting OLTP models to OLAP cubes
• Converted complex logical models to physical models. Example Party data model for Master Data management.
• Designed ETL architecture documents and specifications, mapping documents.
• Extensively documented STTM (mapping documents), TDD (Technical design documents), IDD (Interface design document), UT docs (Unit test case documents), Migration process documents
• Experience in performance tuning of Informatica mappings, capable in identifying and resolving performance bottlenecks at various levels.
• Exposure to many Reporting tools like SAP Business objects, Cognos, SSRS, Tableau
• Experience working with scheduling tools like Tidal, Control M
• Followed SOX evidence processes across projects
• Very strong technical and functional understandings

TECHNICAL SKILLS:

ETL: Informatica 8.6.1, 9.1, 10.1

Data Modelling: Erwin

Database: SQL Server 2008,2014, Oracle, DB2

Domain Skills: Insurance, Investment Banking, Finance

Web technologies: HTML, XML, XSLT

Operating Systems: UNIX, Windows Server 2003/Xp

Programming Language: ABAP/4, C, Java

PROFESSIONAL EXPIRENCE

Confidential, NJ

ETL Consultant

Environment: Informatica 9.5.1,10.1 Oracle11g, SQL Server 2008, Teradata, TOAD, SQL Navigator, Windows Server 2008, UNIX, Netezza 4.2.

Responsibilities:

• Involved in the design, development and implementation of the Enterprise Data Warehousing (EDW) process.
• Hands-on Experience in working with Source Analyzer, Mapping Designer, Mapplets to extract, transform and load data.
• 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.
• Coordinated Joint Application Development (JAD) sessions with Business Analysts and source developer for performing data analysis and gathering business requirements.
• Developed technical specifications of the ETL process flow
• Designed the Source to Target mappings and involved in designing the Selection Criteria document.
• Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in SQL Server and Oracle.
• Used Informatica PowerCenter to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (SQL server, Oracle, Flat files).
• Worked with various sources like Flat files, XML, Relational sources.
• Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, Sequence Generator and Normalizer.
• Used Informatica PowerCenter 9.5.1 to Extract, Transform and Load data into Netezza Data Warehouse from various sources like Oracle and flat files
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Manager.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Used version mapping to update the slowly changing dimensions to keep full history to the target database.
• Involved in migration of Informatica from 8.x to 9.x.
• Implemented sending of Post-Session Email once data is loaded.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Used Debugger to test the mappings and fixed the bugs.
• Tuned performance of mapping and sessions by optimizing source, target bottlenecks and implemented pipeline partitioning.
• Worked with DBA for partitioning and creating indexes on tables used in source qualifier queries.
• Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.
• Involved in exporting database, tablespaces, tables using Data pump(10g) as well as traditional export/import (until 9i).
• Scheduled various daily and monthly ETL loads using Control-M
• Involved in writing UNIX shell scripts to run and schedule batch jobs.
• Involved in unit testing and documentation of the ETL process
• Involved in Production Support in resolving issues and defects.

Confidential, NJ

ETL Consultant

Environment: Informatica 9.0.1, PL/SQL, AWS, Framework Manager, Transformer, Teradata, Oracle 11g, TOAD, Windows Server 2008, UNIX

Responsibilities:

• Gathered User Requirements and designed Source to Target data load specifications based on business rules.
• Used Informatica PowerCenter 9.0.1.for extraction, loading, and transformation (ETL) of data in the DataMart.
• Designed and developed ETL Mappings to extract data from Flat files and Oracle and to load the data into the target database.
• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica PowerCenter.
• 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, Normalizer and Sequence Generator transformations.
• Interacting with Business Analyst and users to get new requirements and enhancements.
• 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.

Confidential

ETL Developer

Environment: Informatica PowerCenter 9.5, Erwin, MS Visio, Oracle 11g, SQL, PL/SQL, Oracle Sql Developer Tool, SQL Server 2008, Flat Files, XML, Mainframe, Cobol Files, Autosys, UNIX Shell Scripting, Subversion

Responsibilities:

• Learned the existing DataMarts to understand and integrate the new source of data.
• Designed and created new Informatica jobs to implement new business logic into the existing process.
• Using Informatica modules (Repository Manager, Designer, Workflow Manager and Workflow Monitor) to accomplish end to end ETL process.
• Performed data profiling with Sources to analyse the content, quality and structure of source data
• During mapping development.
• Created required scripts/transformations to extract the source data from various sources such as Oracle, Flat Files etc.
• Used all the complex functionality of Informatica (Mapplets, Stored Procedures, Normalizer,
• Update Strategy, Router, Joiner, Java, SQL Transformation Etc...) to interpret the business logic into the ETL mappings.
• Designed and developed complex aggregate, joiner, lookup transformations to implement the business rules in the ETL mappings to load the target Facts and Dimensions.
• Defined Target Load Order Plan for loading data into Target Tables
• Used Mapplets and Reusable Transformations prevent redundancy of transformation usage and maintainability.
• Used Informatica’s features to implement Type 1, 2, 3 changes in slowly changing dimension Change Data Capture (CDC)
• Fine-tuned the session performance using Session partitioning for long running sessions.
• Involved in Informatica Upgrades process from one version to other versions
• Design/Configuration for Custom MDM Child entities for phone and email
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Used Versioning, Labels and Deployment group in the production move process.
• Automation of Workflow using UNIX scripts using PMCMD, PMserver commands.
• Setup Permissions for Groups and Users in all Environments (Dev, UAT and Prod).
• Created tables, views, primary keys, indexes, constraints, sequences, grants and synonym.
• Used debugger to test the mapping and fixed the bugs.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time.
• Developed Oracle Stored Procedures, Packages and Functions and utilized in ETL Process.
• Handled the performance tuning of Informatica Mappings at various level to accomplish the established standard throughput.
• Analysed the Target Data mart for accuracy of data for the pre-defined reporting needs.

Confidential

ETL Consultant

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

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 the 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.
• Scripting queries with SQL Server 2000