SUMMARY

• Around 7 years of IT experience in analysis, design, development, data conversion and Implementation of various projects using Data Warehousing tools a working knowledge of traditional transaction based (OLTP) systems as well as latest data warehousing/data mart techniques.
• Over 7 years of strong experience in ETL process using Informatica PowerCenter 7.1/8.5.1/8.6.1/9.0.1 with strong background in SDLC, Data Warehousing and Data base Development
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing, DataMarts using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflakes Modeling, fact and dimension tables, Pivot Tables, modeling of data at all the three levels: view, logical & physical.
• Extensively used Informatica Repository manager, Power center Designer, Workflow manager, Workflow Monitor.
• Expert in design and development of complex ETL mappings and scripts using Informatica PowerCenter.
• Hands on solid experience in Performance Tuning of source, target, mappings, transformations and sessions.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.
• Extensively worked on Relational Databases RDBMS like Oracle 11g/10g/9i/8i, MS SQL Server, DB2. Also worked on various Source files like flat files, XML files, CSV files.
• Expertise in developing Slowly Changing Dimensions mappings (Type1, Type2) and Change Data capture.
• Expertise in different Informatica Performance Tuning issues like Source, Target, Mapping, Transformation, session to make them more efficient in terms of session performance.
• Experience in SQL, PL/SQL and UNIX shell scripting.
• Strong logical, analytical and communication skills with Solid business acumen. Ability to effectively gather and refine report requirements from Users and Management.
• Strong Team Management skills and excellent team player.
• Experience in a wide range of Business Domains like HealthCare, Financial and Insurance.
• Excellent communication and interpersonal skills, good analytical reasoning and ability to learn quickly, high adaptability to new technologies and tools.

TECHNICAL SKILLS

ETL: Informatica Power Center 9.1.0/8.6.1/ 7.1.4

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables

Databases: Oracle 11g/10g/9i/8i, DB2, MySQL, PL/SQL, SQL*Plus, MS SQL Server 2008, MS Visio 2012

Tools: Toad, SQL* Loader, Tidal, Control-M, MS Office

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, C, C++

Operating Systems: Windows 2000/2003,UNIX and LINUX

PROFESSIONAL EXPERIENCE

Confidential - Norfolk,Virginia

Sr. Developer

Responsibilities:

• Participated in gathering requirements from Business Analysts.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.
• Perform validation on various kinds of data based on the requirements.
• Implemented SCD1, SCD2 type mappings to capture new changes and to maintain the historic data.
• Identified ETL specifications based on Business Requirements Document(BRD)/Mapping Document.
• Defined ETL standards and Best Practices for the ETL team to use in ETL maps and processes.
• Created Technical Design Documents(TDD) along with unit test cases.
• Created reports using SSRS.

Environment: Informatica Power Center 9.5, Oracle 10g, SQL Server2012,Microsoft Visual Studio 2012.

Confidential - Norfolk,Virginia

Sr. Informatica Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Worked in AGILE SCRUM environment regularly attending the Status Meetings and updating status to Scrum Master and involved in Code Review meetings, Implementing User Stories etc.
• Developed mappings, sessions and workflows in Informatica Power Center9.5.
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup and Filter.
• Has experience working with relational tables, flat files.
• Involved in creating stored procedures and using them inInformatica.
• Responsible for Performance Tuning at the Mapping Level and Session level.
• Experienced working in Oracle 10g and SQL Server 2012 environment. Responsible for Performance Tuning at the Mapping Level and Session level.
• Trouble shooting of long runningsessionsand fixing the issues.
• Responsible for migration of the work from dev environment to testing environment
• Responsible for solving the testing issues.
• Created documents that have the detail explanation of the mappings, test cases and the expected results and the actual results.
• Involved inUnit testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Migrated repository objects, services and scriptsfrom development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.

Environment: Informatica Power Center 9.5, Oracle10g, SQL Server2012, Windows 7, SDLC Jira, SVN Tortoise.

Confidential - Minneapolis, Minnesota

ETL Developer

Responsibilities:

• Participating in the entire requirements engineering process right from requirements elicitation phase to the phase involving documenting of the requirements.
• Identifying ETL specification based on Business Requirements/Mapping Document. Formulating and documenting ETL process design. Participated and lead research and development efforts (proof of concept, prototypes), as subject matter experts, with new technologies.
• Implementing ETL standards and Best Practices while naming Maps and processes.
• Coordinated and communicated the overall project execution status with Project Manager and Technical Delivery Manager
• Developing complex maps to extract data according to the Transformation Business Rules and User requirements.
• Modified several of the existing maps and created several new maps based on the user requirement.
• Creating Workflows and used various tasks like Email, Control, Decision, Session in the workflow manager.
• Worked with Informatica PowerCenter client tools like Source Analyzer, Warehouse Designer and Mapping designer.
• Developed new ETL mappings according to the requirements using Informatica PowerCenter9.1
• Involved in creating Workflows, Worklets and Configured Sessions, Used pmcmd command of Informatica in UNIX scripts.
• Debugging code, testing and validated data after processes are run in development according to business Rules.
• Assisted QA Team to fix and find solutions for the production issues.
• Implemented Change Data Capture (CDC) in Informatica Powercenter.
• Working closely with all team members to resolve the technical issues and business related questions.
• Involved in automating the Informatica process by using Unix Shell Script.
• Managing timely written and verbal communication on project progress, load status, issue tracking, and concerns for managementattention and/or escalation. Written documentation to describe program development, logic, coding, testing, changes and corrections.
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop different solutions for challenging client needs.

Environment: Informatica Power Center 9.1, Oracle 10g, SQL Server 2008, Tidal, Toad 11.6.0.43, Unix.

Confidential - Phoenix, AZ

Sr. Informatica Developer

Responsibilities:

• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets.
• Derived and designed required Fact and Dimension tables to accommodate the data as per the user requirements.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.
• Implemented SCD1, SCD2 type mappings to capture new changes and to maintain the historic data.
• Worked on extract and load type of mappings.
• Identified ETL specifications based on Business Requirements/Mapping Document.
• Defined ETL standards and Best Practices for the ETL team to use in ETL maps and processes
• Extensively developed complex maps to extract data according to the Transformation Business Rules and User requirements to extract data from different sources like Flat Files and SQL Server to Targets SQL Server and XML files.
• Conducted team meetings in order to gather the status from each team member, coming up with the meeting minutes and making sure that everyone in the team is very effective in order to meet the project deadlines.

Environment: Informatica Power Center 8.6, Oracle10g, SQL Server2005, ERWIN,UNIX.

Confidential - Buffalo, NY

Informatica Developer

Responsibilities:

• Analyzed business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Worked on analyzing source systems and their connectivity
• Analyzed different options for heterogeneous database connectivity and defined policies for dealing with different source databases with ETL team.
• Created multiple ETL flows to provide business with monthly, quarterly and yearly reports well ahead of regular schedules using Informatica Power Center8.6
• Developed mappings using the mappings specs and process flow, used Joiners, aggregators, update strategy, Lookup, expression, sorter, filter, router, rank, transaction control transformations in mappings
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Participated in software design reviews with developers to ensure that the architecture is scalable to meet long-term performance goals.
• Involved throughout the life cycle of this project since requirements analysis.
• Scheduled jobs using Autosys.
• Involved in extensive performance tuning by determining bottlenecks using Debugger at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Performed unit testing, negative testing and then handed over the data to QA team.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Conducted User Acceptance Testing (UAT). Performing early analysis of existing systems to help define integrations.
• Involved in support and troubleshooting of production systems as required, optimizing performance, resolving production problems

Environment: Informatica Power Center 8.6, MS SQL server 2005/2008, Oracle 9i, DB2, Control -M.

Confidential

ETL Developer

Responsibilities:

• Collaborated with business analysts and the DBA for requirements gathering, business analysis and designing of the data marts
• Analyzed the data in the source databases and designed the overall data architecture and all the individual data marts in the data warehouse for each of the areas Merchandising, and store operations
• Mainly involved in the requirements definition and analysis in support of data warehousing efforts
• Involved in error handling, data audit and data recovery design.
• Developed ETL mappings, transformations using Informatica Power Center 8.5.1
• Created Mapplets with the help of Mapplet Designer and using these Mapplets in various mappings
• Created various Tasks, Sessions, Worklets & Workflows using Workflow Manager
• Troubleshoot connectivity problems. Looked up and read session, event and error logs for troubleshooting.
• Coordinated with the Quality Assurance team for component, unit and integration test environments.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Involved in automating the Informatica process by using Unix Shell Script.
• Managing timely written and verbal communication on project progress, load status, issue tracking, and concerns for managementattention and/or escalation. Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 7.1, Erwin 7.1, DB2, Oracle 10g, TOAD8.0, UNIX