EXPERIENCE SUMMARY:

• Working as a Senior Associate/Team Lead for past 8 years with expertise in INFORMATICA ETL, PL - SQL Developer and Qlikview Reporting.
• Good experience as Informatica (ETL) Developer, Qlikview Developer, PLSQL Developer, Netezza Developer and QA Tester.
• Eight plus (8+) years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Telecom and Manufacturing Sectors.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Extensive ETL testing experience using Informatica 9.1/8.6.1 (Power Center) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Oracle and Business Objects.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema.
• Expertise in working with relational databases such as Oracle 11g/10g, Netezza.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger) as ETL tool on Oracle and Netezza.
• Experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using Oracle PL/SQL.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle, DB2, Netezza, Excel files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in using Automation Scheduling tools like CA-WA workstation, Control-M and DAC.
• Worked extensively with slowly changing dimension types.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 8.6.1/9.0.1 /9.5.1 with shell scripts for scheduling

Reporting tools: Qlikview10/11, Jasper soft

Scheduling Tools: Control M, DAC, ESP (CA Workstation), DIS

PL/SQL Tools: Aginity Workbench, MySQL Workbench, PLSQL Developer, Toad

Testing Tools: Quality center, HP ALM

Database: Netezza DB, Oracle 10g/11g, MySQL, DB2, SQL Server.

Operating Systems: Windows XP/ 2003/7/Unix.

Data modeling tools: MS Visio, Toad Data Modeler

DB Programming: SQL and PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte - NC

Senior Informatica Developer/Designer

Tools: Informatica PowerCenter 9.5.1, Win SCP, Shell Scripting using Unix, Microsoft SQL server 2014, DIS Scheduling tool, ALM testing.

Responsibilities:

• Understand the business requirements.
• Extracted data from relational databases DB2, Oracle and Flat Files using Informatica.
• Developed various Mappings with the collection of all Sources, Targets, and Transformations.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created functional specification Document for each module of the project.
• Worked with complex mappings.
• Used Workflow manager for Session Management, Database Connection Management and Scheduling of jobs.
• Designed and Developed Transformations, Mappings and Sessions in Informatica to load target database and tuned mappings for improving performance.
• Coordinating with Testing Team and resolving possible defects.
• Created and Scheduled sessions and worklets using workflow manager to load the data into target database.
• Worked with different data sources such as SQL server, Sybase and Flat files.
• Wrote PMCMD and PMREP commands and Korn Shell scripts to automate various administrative tasks.
• Used Workflow manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions.

Confidential, Rochester - NY

ETL Informatica Developer/Designer

Tools: Informatica PowerCenter 9.5.1, Win SCP, Shell Scripting using Unix, Microsoft SQL server 2014, Control M

Responsibilities:

• Understand the business requirements.
• Imported various Sources, Targets, and developed Transformations using Informatica Power Center Designer.
• Developed various Mappings with the collection of all Sources, Targets, and Transformations.
• Designed, developed and deployed new data marts along with modifying existing marts to support additional business requirements.
• Created functional specification Document for each module of the project.
• Worked with complex mappings.
• Used Workflow manager for Session Management, Database Connection Management and Scheduling of jobs.
• Designed and Developed Transformations, Mappings and Sessions in Informatica to load target database and tuned mappings for improving performance.
• Co-ordinating with Testing Team and resolving possible defects.
• Created and Scheduled sessions and worklets using workflow manager to load the data into target database.
• Worked with different data sources such as SQL server, Sybase and Flat files.
• Used Workflow manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions

Confidential, Winston Salem - NC

ETL Informatica Developer/Designer

Tools: Informatica PowerCenter 9.5.1, Win SCP, Shell Scripting using Unix, Aginity workbench, Toad, ESP (CA Workstation)

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, lookup, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the Mappings from development to testing and then to production repositories.

Confidential, Sandiego - CA

ETL Informatica/Qlikview Developer.

Tools: Informatica PowerCenter 9.1.0, Qlikview 11, Aginity workbench, Toad, Control M

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, lookup, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the Mappings from development to testing and then to production repositories.

Confidential

ETL Informatica/Qlikview Developer

Tools: Informatica PowerCenter 9.0.1, Qlikview 11, Aginity workbench.

Responsibilities:

• Participated in business meetings and Interacted with client to understand the business requirements.
• Configured Informatica to work with Netezza Database
• Designed mapping/sessions and workflows to pull data from sources and load it to Netezza database tables
• Defined validation rules and implemented to ensure the correctness of the data.
• Optimized ETL code, following best practices
• Involved in creating Unit test cases and their execution.
• Developed various reports and dashboards in Qlikview

Confidential

ETL Developer

Tools: Informatica Power Center 9.0.1, Aginity workbench.

Responsibilities:

• Interacted with client to understand the business requirements.
• Defined ETL strategies which include auditing and recovery
• Configured Informatica to work with Netezza Database
• Designed fact tables and dimension tables.
• Designed mapping/sessions and workflows to pull data from source and load it to stage and weekly aggregate tables.
• Defined validation rules and implemented to ensure the correctness of the aggregate data
• Written shell script to send notifications whenever there’s a failure or abnormal activity taken place.
• Optimized ETL code, following best practices and tuning techniques

Confidential

ETL Developer

Tools: Informatica Power Center 8.6.1/9.0.1, PL/SQL Developer, DAC.

Responsibilities:

• Coordinating with users and gathering the business requirements Designed for fact tables and dimension tables.
• Developed ETL Reusable transformation, Mapplets, mappings, Sessions and Workflows using Informatica Power Center.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, joiner, aggregate transformation and expression.
• Mappings were developed to maintain history data by applying slowly changing dimensions concepts.
• Done code review on Informatica mappings and relative session which are developed by the team members.
• Involved in creating Unit test cases and their execution.
• Prepared deployment document and assisted to deployment activity with team while doing migration.
• Coordinating with QA team in resolving the defects rose during QA.
• Scheduling Informatica objects using DAC by creating execution Plans.

Confidential

QA/ETL Developer

Tools: Informatica Power Center 8.6.1/9.0.1, MySQL Workbench, DAC.

Responsibilities:

• Walk through the Designs and understand the requirement.
• Experience in Designing Test Plan and Execution of Test Cases.
• Interacting with Developers for fixing the Defects.
• Ability in handling Defect Tracking and Defect reporting.
• Documentation of Test-Results.
• Daily customer interaction and updating of daily status reports.
• Developed ETL Reusable Transformations, Mapplets, Mappings, Sessions and Workflows using Informatica Power Center.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, joiner, aggregate transformation and expression.
• Prepared deployment document and assisted to deployment activity with team while doing migration.
• Scheduling Informatica objects using DAC by creating execution Plans.