SUMMARY

• Over 8 years of experience in Information Technology with a strong background in Database development and Data warehouse and ETL process using Informatica Power Center 10.2,9.6/9.1/8.x/7.x/6.x/5.x.
• Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, Sybase, COBOL files, XML Files and Worked on integrating data from flat files like fixed width and delimited.
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Experience with slowly changing dimension methodology and slowly growing targets methodologies.
• Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
• Experience in diversified fields in Data Warehousing. Worked on various projects involving Data warehousing using Informatica Power Center 7.1 and Power Center 9.1/8.1.6 (Workflow Manager, Workflow Monitor, Server Manager, Source Analyzer, Warehouse Designer, Mapping Designer, and Mapplet Designer & Transformation Developer).
• Extensively used Informatica Repository Manager and Workflow Monitor.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Agile development environment including Scrum methodology. Expertise to follow agile process in application development.
• Worked with Stored Procedures, Triggers, Cursors, Indexes and Functions.
• Strong analytical and problem-solving skills with the ability to quickly adapt to new environments and learn new technologies.
• Maintained summaries or aggregates on data using Materialized Views.
• Expertise in Analyzing system specifications and Business requirements.
• Involved in various stages of Analysis, Design, Development, Testing, and Implementation of application development process.
• Experienced in Database Design, Data Modeling, Migration, and Systems Architecture, Planning, Testing Query Optimization and Trouble Shooting.
• Extensive experience in creating new reports and customization of existing Reports, Forms and PL/SQL Procedures in Oracle Applications.
• Extensive experience in writing data conversion scripts for migrating legacy data into Oracle Applications using SQL*Loader and PL/SQL.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Excellent communication skills.

TECHNICAL SKILLS

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

ETL Tools: Informatica Power Center 10.2/9.6.1/9.1/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server)

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, DB2 v8.1, Teradata 13.0/14.0.

Data Modeling tools: Erwin, MS Visio

Languages: SQL, PL/SQL, UNIX, Shell scripts, C++, SOAP UI, JSP, Web Services, Java Script, HTML, Eclipse

Scheduling Tools: Autosys, Control-M, Windows Task Scheduler

Testing Tools: Quality Center, Clear case. Bugzilla

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL Informatica Developer

Responsibilities:

• ETL process performed using Informatica and the DB used are SQL SERVER, ORACLE 11g.
• Extensively used Informatica Power Center 10.1 version to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Implemented CDC mappings for DB2 Power exchange data.
• Converted Data manager etl jobs into Informatica mappings.
• Extensive Unix Shell Scripting knowledge.
• Optimized performance by tuning the Informatica ETL code as well as SQL.
• Based on the requirements, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update Strategy, Sorter, XML, Lookup, Salesforce lookup, Aggregator, Joiner and Stored Procedure transformations in the mapping.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Joiner, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Agile development environment including Scrum methodology. Expertise to follow agile process in application development.
• Involved in all kinds of testing unit, QA and user acceptance testing.
• Written Queries, procedures, created Indexes, primary keys and data bases testing.
• Defects were tracked, reviewed and analyzed.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Agile development environment including Scrum methodology. Expertise to follow agile process in application development.
• Strong expertise in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using Informatica Power Center 9.x/8.x/7.x/6.x ETL tool.
• Expertise in Data Modeling using Star Schema/Snowflake Schema, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modeling using ERWIN 4.x/3.x
• Experience in documenting High Level Design, Low level Design, STM's, Unit test plan, Unit test cases and Deployment documents.

Environment: Informatica Power Center 10.1, ORACLE 11g, Power Exchange, Data Manager, Windows XP, UNIX

Confidential, Columbus, OH

Sr. ETL Informatica Developer

Responsibilities:

• ETL process performed using Informatica and the DB used are SQL SERVER, ORACLE 11g.
• Extensively used Informatica Power Center 10.1 version to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Implemented CDC mappings for salesforce source data.
• Converted Business Object and data services (BODS) jobs into Informatica mappings.
• Extensive Unix Shell Scripting knowledge.
• Optimized performance by tuning the Informatica ETL code as well as SQL.
• Based on the requirements, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update Strategy, Sorter, XML, Lookup, Salesforce lookup, Aggregator, Joiner and Stored Procedure transformations in the mapping.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Joiner, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Agile development environment including Scrum methodology. Expertise to follow agile process in application development.
• Involved in all kinds of testing unit, QA and user acceptance testing.
• Written Queries, procedures, created Indexes, primary keys and data bases testing.
• Defects were tracked, reviewed and analyzed.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Agile development environment including Scrum methodology. Expertise to follow agile process in application development.
• Strong expertise in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using Informatica Power Center 9.x/8.x/7.x/6.x ETL tool.
• Expertise in Data Modeling using Star Schema/Snowflake Schema, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modeling using ERWIN 4.x/3.x
• Experience in documenting High Level Design, Low level Design, STM's, Unit test plan, Unit test cases and Deployment documents.

Environment: Informatica Power Center 10.1, ORACLE 11g, Salesforce, Business Object and data services (BODS), Active Batch, Windows XP, UNIX

Confidential, San Francisco, CA

ETL Informatica Lead Developer

Responsibilities:

• Review existing code, lead efforts to tweak and tune the performance of existing Informatica processes
• Conducted code reviews developed by my team mates before moving the code into QA.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Involved in meetings with key stakeholders of the business and discussed on strategies and roadmaps for Informatica Power Center implementation.
• Architected and designed end to end process automation to resolve any reconciliation discrepancies based on technology pull.
• Prepared a plan for OFSAA Informatica ETL and worked closely with Informatica Administrators and IT Teams to perform implementation.
• Documented the OFSAA Informatica ETL process and worked closely with Informatica Technical support on some of the issues.
• Extensively worked on Informatica Mappings, Sessions, Workflows and UNIX Shell scripts to provide end to end solution to ID Recertification process.
• Implemented the Data masking in Dev and SIT environment.
• Setup of Best Practices Standards in line with State Department and Velocity methodology
• Maintain naming standards for ETL and DB objects as per the Client Requirement.
• Involved in 'Performance tuning' in ETL objects, Oracle in order to meet SLA.
• Automation of the processing layer Unix script.
• Created the Test cases document and test case report handover to QA team as part of Dev exit.
• Created the Unit test document and validated the data as part of Dev exit.
• Created 'On boarding process' document for new members.
• Created 'OFSAA survival document' for production support and new members.
• Created 'Operating Level Agreement for file support' for post go-live.
• Created 'Autosys Details of ETL and processing layer' for post go-live.
• Responsible for creating the non production request to move the QC and data validation changes.
• Analyzed data lineage and prepared documents for pre-stage to stage and vice versa table level granularity.
• Conducted code walk through documents related to the assignments worked on.
• Responsible for creating the CM's for migrating the code from one environment to other.
• Taking Quick and Right decisions to fix the failures in order to meet SLA. Ensured that all support requests are properly approved, documented, and communicated. Documenting common issues and resolution procedures.
• Creating and modifying UNIX shell scripts.
• Bringing Up new innovations in the project to make the client satisfied.
• Agile development environment including Scrum methodology. Expertise to follow agile process in application development.

Environment: PowerCenter Designer 9.5.1, Oracle 11g, Toad 10.0.0.41, Green plum,HP Service Manager (HPSM), HP Quality Center (HPQC), MKS, Non Production Request (NPR), Auto Sys, UNIX and Windows XP