SUMMARY:

• Over 9 years of experience in System Analysis, Design, Development, Testing, Implementation, Maintenance and Production support of Data Warehouse and Data Integration Applications for Health care and financial sectors.
• Strong experience in designing and developing complex ETL scripts to support large data volume movement using Informatica Power Center 9.6.1/9.1/8. x/7.x
• 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
• Experience in Informatica Data Quality (IDQ - Informatica developer 9.6.1/9.1) for cleansing and formatting customer master data.
• Experience in Informatica Analyst to analyze customer master data.
• Used Informatica Analyst to perform profiling.
• Created reference tables for standardization.
• Extensive testing ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (Power Center) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using Erwin
• Expertise in working with relational databases DB2 UDB 9.6/9.7, Oracle 11g/10g/9i, SQL Server 2008/2005.
• 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, Complex SQL queries using SQL Server, and Oracle PL/SQL
• Solid experiences in implementing SCD TYPE I and SCD TYPE II, and working with mapping parameters and variables.
• Thorough understanding of Data Warehouse concepts Ralph Kimball Methodology, Bill Inmon methodology, Star Schema, Snow Flake Schema, Dimensional Modeling.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• Experience in ETL Performance Tuning/Optimization.
• Experience in using Automation Scheduling tools like Confidential and Control-M
• Knowledge on MDM and Bigdata.

TECHNICAL SKILLS:

Data warehouse Tools: Informatica Power Center 9.6.1/9.1/8. x/7.x (Mapping Designer, Workflow Designer, Workflow Monitor and Repository Manager), Informatica Power Exchange.

Cleansing Tools: Informatica Data Quality (IDQ9.6.1/9.5)

OS: Windows 2008/2007/2005/ NT/XP, UNIX, MS-DOS

Databases: Oracle 11g/10g,MS SQL Server 2005/2008, DB2 v8.1

Languages: SQL, PL/SQL, UNIX, Shell scripts

Scheduling Tools: Confidential, Control-M

PROFESSIONAL EXPERIENCE:

Confidential, Sacramento,CA

Responsibilities:

• Prepare Technical system Design document and Specific functional design document based on analysis of business requirements by coordinating with business analyst and customers
• Design the ETL processes using Informatica(7.1.1 and 8.5.1) to load data from Cobol VSAM, Oracle, Flat Files, and Excel files to staging database and from staging to the target Oracle Warehouse database.
• Work with several facets of the Informatica PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping & Mapplets Designer and Transformation Designer
• Involve in full life cycle development including Design, ETL strategy, troubleshoot reporting, and identifying facts and dimensions for various projects.
• Modify complex mappings, mapplets and workflow to meet the business/project needs ensured they are reusable transformation to avoid duplications.
• Coordinate from start to end of the project working with project manager, business analyst, QA Leads and other stakeholders and ensure project gets delivered on time with high quality
• Document ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis
• Designed and developed efficient Error Handling methods and implemented throughout the mappings. Involved in Data quality analysis to determine cleansing requirements.
• Prepare SQL scripts, shell scripts and control files
• Prepare the Project relase plan (PRP) document.
• Involved in the migration of Informatica from 8.5.1 to 10.1

Environment: Informatica Power Center 7.1.1,8.5.1,10.1(Repository Manger, Designer, Workflow Manager, Workflow Monitor), Oracle 10g,11g,12,SQL Plus,Unix,Solaris

Confidential, Centennial, CO

Sr. ETL /Informatica Developer/Data Quality(IDQ) Developer

Responsibilities:

• Develop ETL mappings, sessions and workflows to implement business requirements using Informatica Power Center 9.1
• Communicated with business customers to discuss the issues and requirements.
• Participated in Daily Stand ups
• Created PL/SQL stored procedures for moving the data from staging area to data mart
• Created indexe s on the tables for faster retrieval of the data to enhance database performance
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD
• Performed profiling using Informatica Analyst and Informatica Developer.
• Captured DQ metrics( like Total record count, Distinct record count, Count of a distinct field,
• Work on developing the entire ETL design to retrieve data from various sources and build the stage data that will be used by DW process to load the final tables.
• Created scorecards to review data quality.
• Used Informatica Data Quality tool (Informatica Developer) to scrub, standardize and match customeraddress against the USPS database.
• Design, Development and implementation of Informatica Developer Mappings for data cleansing using Address validator, Labeler, Association, Parser, Expression, Filter, Router, Lookup transformations etc.
• Design the database structure to store the information in data warehouse
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Develop and work on Slowly changing dimensions Type 1,2 and 3
• Created complex mapping involving multiple transformations including procedure transformation to have the codes utilized.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Created detailed unit test document
• Designed workflows with many sessions with decision, assignment task and control task
• Identified problems in existing production data and developed one time scripts to correct them .
• Load Historical data (2011, 2012, 2013, 2014-Quarterly, 2015 Monthly) in Dev and QA.
• Develop, test and promote all of the code changes toQA and Production environment.
• Test data against different levels of hierarchy, multiple dates and data points.

Environment: Informatica Power Center 9.1(Repository Manger, Designer, Workflow Manager, Workflow Monitor), Informatica Data Quality 9.1,SQL Server 2008, 2012, Flat files, SQL

Confidential

ETL Developer

Responsibilities:

• Gathered business requirements and created mapping documents based on the data model and source system analysis.
• Involved in initial design meetings
• Integrated data from heterogeneous source systems extract and transform data with business rules and built re-usable Mapplets using Informatica Designer.
• Extensively worked with transformations Lookup, Update Strategy, Expression, Filter, Stored Procedures, Router, joiner and others.
• Created complex mappings and transformations using expressions, aggregators, filters, and sorter, and sequence generator, lookups to develop DataMart’s.
• Worked on creating star schemaDataMart’s using the dimensional modeling approach.
• Fine-tuned transformations and mappings for better performance.
• Used Informatica Power Center workflow manager to create sessions, workflow to run with the logic embedded in the mappings.
• Efficient documentation was done for all phases like analysis, design, development, testing and maintenance.
• Associated with Production support team in various performances related issues.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.

Confidential

QA Analyst

Responsibilities:

• Involved in writing and reviewing test cases
• Involved in the String Test case Modification (Phoenix)
• Explored on tools like SOA accelerator
• Involved in creating XML Messages using SOA Accelerator
• Involved in Test case to Screen Mapping (Phoenix)
• Involved in Test case to BR & DR Mapping (Phoenix)