SUMMARY

• 7+ years of IT experience in the Analysis, Design, Development, Testing, Implementation and production support of business application systems for Insurance,RetailBanking and financial Sectors.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server and Mainframe applications.
• Strong knowledge of various development tools of Pentaho - Pentaho Design Studio (PDS),Pentaho Report Designer (PRD), Pentaho Analyzer, Pentaho Workbench, Community Dashboard Framework (CDF), and Pentaho BI Server.
• Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modelling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files (Fixed width & Delimited), XML Files,VSAM, IBM DB2, Excel, Oracle, Sybase, MS SQL Server,Netezza and Teradata
• Extensive testing ETL experience using Informatica 9.1/8.6.1/8.6 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
• Strong experience in Dimensional Modelling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modelling.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.
• 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), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, Oracle SQL and Teradata.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Worked extensively with slowly changing dimensions.
• 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 10.0/9.6/9.1/8.6/8.5.1 (PowerCenter/Power Mart) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect),Pentaho

Data Modeling: Erwin 4.0/3.5, Star Schema Modelling, Snow Flake Modelling

Databases: Oracle 11g/10g/9i/8i, My SQL Server 2014/2012/2005/2000 , DB2, Netezza, Hive.

Languages: SQL, PL/SQL, Unix Shell Script, Visual Basic, Cobol, JavaScript, Groovy Script

Tools: Toad, SQL* Loader, Cognos 7.0/6.0

Operating Systems: Windows 2010/2008/20072003/2000/ NT, UNIX, MS-DOS, Mac

Scheduling Tools: Autosys r11.3/10.X, Control-M 9/8/6.1.X

PROFESSIONAL EXPERIENCE

Confidential, Montvale, NJ

ETL Informatica Analyst

Responsibilities:

• Works with Data Architects to understand and identify the source extracts.
• Ability to understand and interpret the requirements to accurately design the mapping data flow.
• Designed and maintained the ETL strategies.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping &Mapplet Designer and Transformation Designer.
• Involved in high level design.
• Experience in creating Informatica mappings to load data from Flat files to Stage Data bases to ODS.
• Cleansed and standardized data using Pentaho transformations like Standardizer, Parser, Match, Merge & Consolidation Transformations using PDI tool.
• Used connected and unconnected lookups, to look up for Domain and mapping values in relational tables.
• Designed and developed the mapping which generates the parameter file dynamically.
• Expertise in preparing the Unit Test Cases and assists QA team in test plans and test scripts preparation.
• Managed the ETL defects and enhancement and change requests to meet the changes in business needs.
• Worked on ETL code elevation from Dev to QA/Test/Acceptance.
• Have done performance tuning of mappings and sessions to meet SLAs.
• Identified and investigated data integrity problems.
• Tuned Informatica mappings and sessions for optimum performance.
• Defined the jobs flow which loads the data into ODS from staging.
• Scheduled and monitored the jobs using Informatica.

Environment: InformaticaPowerCenter 10.0,Informatica BDE 10.0, Netezza, SQL Server, HDFS, Hive, HBASE, Oracle 11g, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange

Confidential, Montvale, NJ

Informatica Consultant

Responsibilities:

• Works with business partners to understand and facilitate project requirements
• Worked with data modeler to design dimensional model that fits best to the requirements.
• Involved in high level design.
• Created Informatica mappings to load data from different source like ODS, Flat files, CSV to Data warehousing and Data mart.
• Used Java transformations to encrypt the sensitive data.
• Used XML transformations to extract data from XML files into staging data base.
• Used connected and unconnected lookups to look up for values in relational tables.
• Designed and developed the mapping which generates the parameter file dynamically.
• Prepared the Unit Test Cases and tested the same.
• Worked on ETL code elevation from Dev to QA/Test/Acceptance.
• Extensively involved in fine tuning of mappings and sessions for better performance and through put.
• Defined the jobs flow which loads the data into Enterprise Data warehousing and Claims Datamart.
• Scheduled the jobs in Control M

Environment: InformaticaPowerCenter 9.6, Oracle 11g, Autosys r11.3, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, DB2, Toad 9.0.

Confidential

Informatica Developer

Responsibilities:

• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all applications and system.
• Experience in writing Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Extensively worked on Power Center Client Tools like Repository Admin Console, Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
• Analyzed the source data coming from different sources (Oracle, DB2, XML, Flat files) and worked on developing ETL mappings.
• Developed complex Informatica Mappings, reusable Mapplets and Transformations for different types of tests in research studies on daily and monthly basis.
• Implemented mapping level optimization with best route possible without compromising with business requirements.
• Created Sessions, reusable worklets and workflows in Workflow Manager and Scheduled workflows and sessions at specified frequency.
• Worked on fixing invalid Mappings, testing of Stored Procedures and Functions, and Integration Testing of Informatica Sessions.
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and Session Level.
• Worked extensively on SQL, PL/SQL, and UNIX shell scripting.
• Performed Data profiling for data quality purposes.
• Proven Accountability including professional documentation, and weekly status report.
• Performed Quantitative and Qualitative Data Testing.
• Documented flowcharts for the ETL (Extract Transform and Load) flow of data using Microsoft Visio and created metadata documents for the Reports and the mappings developed and Unit test scenario documentation for the mentioned.

Environment: InformaticaPowerCenter 9.6, Oracle 11g, Autosys r11.3, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, DB2, Toad 9.0.