SUMMARY:

• 13 years Experience in IT industry among all the aspects of Software Development Life Cycle (SDLC) serving multiple clients from Health care and Banking domains.
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Strong Experience in working with ETL tools - Informatica Power Center 9.x/8.x and Informatica Data Quality 9.5.1/9.6.1 interacting with different databases like - Oracle 11g, SQL Server, DB2, Mainframes.
• Well acquainted with Informatica client tools - Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager and Workflow Monitor.
• Strong Knowledge of Relational and Dimensional Modeling techniques like Star, Snowflake Schema, OLAP, Fact and Dimensional Tables.
• Developed ETL mappings using different source and target systems like flat files, XML files and Relational tables from heterogeneous databases like Oracle, SQL Server, Teradata and DB2.
• Extensively used Informatica Power Center in developing Complex mappings from various Data Transformations (DT) like Source Qualifier, Normalizer, Router, Filter, Expression, Aggregator, Joiner, Union, Sequence Generator, Update Strategy, Unconnected/Connected lookups and more.
• Designed and documented various complex mappings and experienced working with Business Analysts to Provide Technical solutions to Business requirements.
• Very strong knowledge of Informatica Data Quality transformations like Address validator, Parser, Labeler, Match, Exception, Association, Standardizer and other significant transformations.
• Experience in implementing Performance Tuning at various levels of sources, targets, mappings, sessions, worklets, workflows and transformations to resolve or remove the bottlenecks.
• Create test plan, test cases and the Unit testing, SIT and UAT and send them to projects lead for approval.
• Involved in Code migration from lower environments to higher environments using Deployment groups and Export/Import of xml files.
• Exposed to different methodologies in Software Development Life Cycle - (Agile and Waterfall and Lean).

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x, and Informatica Data Quality 9.5.1/9.6.1

Reporting Tools: OBIEE 10.1.3.1.

Databases: Oracle 11g/10g/9i, MS SQL Server 2008/2005/2012, Main Frames, DB2.

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

Other tools & Utilities: SQL*Plus, Cognos, Control-M, SQL Developer, OBIEE, Toad, Autosys, MS-Office.

PROFESSIONAL EXPERIENCE:

Confidential, IL

Sr. ETL Informatica Consultant

Responsibilities:

• Coordinated with host team to understand the current functionality to migrate
• Assisted in preparing the high level and low level technical design
• Created the source to target mappings based on the low-level designs.
• Coded the new Informatica mappings according to the requirements
• Worked with DBAs to tune the SQL used in the Informatica mappings
• Developed Shell scripts to run the Informatica jobs
• Performed the Unit testing and Documented the test results
• Worked with auto flow and scheduling team to implement the changes in test environment
• Deployed the code to system testing environment
• Assisted the system testing team during system testing
• Fixed the defects identified in system testing and implemented in test environment
• Conducted user acceptance testing with business partners
• Implemented various performance tuning techniques to improve the performance
• Implemented the code in production and supported post production
• Monitor the production flows
• Fix if Informatica/Unix job fails with in time to continue the flow
• Correct if any valid data in the source files
• Document the production log if any new errors for their sources

Environment: Informatica Power center 9.6.1, Power Exchange 9.6.1, DB2, UNIX Shell Scripting, IBM Data studio, IBM Mainframe

Confidential

Responsibilities:

• Involved in business requirements gatherings
• Used the source data from flat files and DB2 tables
• Used various transformations like Joiner, Aggregator, Expression, Connected/Un-connected lookup, Filter, Router, Union, Stored procedure and Update Strategy
• Declared and used mapping parameters and variables with in the mappings
• Coordinated with DBAs to create the test objects in various test environments and in production during final implementation
• Performed debugging to identify the issues and resolved all the issues
• Developed shell scripts to run Informatica workflows
• Worked with auto flow and Scheduling team to schedule the jobs in Test and Production
• Implemented the code in system testing environment and assisted the test team while testing
• Documented the test results in project phases in Lotus notes
• Implemented the code and auto flows in production

Environment: Informatica Power center 9.5.1, DB2, UNIX Shell Scripting, IBM Data studio

Confidential, Richmond VA

Informatica Consultant

Responsibilities:

• Interacted with business partners and gathered the requirements
• Assisted in designing logical and physical data models
• Developed Informatica mapping to extract the data from Flat files and DB2 tables lookups, Stored procedures, Aggregator, Joiner, Router and Update strategy
• Created SCD (slowly changing dimension) type 2 mappings and Facts
• Created Informatica Mapplets to reuse the same functionality in multiple mappings
• Created workflows and modified worklets to run the modified sessions
• Developed Korn Shell scripts to run the Informatica workflows
• Worked with DBAs to review the changed/new SQLs and made code changes as per the DBA Recommendations
• Performed Unit testing and Validated the data according to source to target mapping
• Documented test results and shares to project for review
• Identified the bottlenecks and tuned the performance of the session
• Deployed the code in system testing environment and assisted the test team during their testing
• Resolved the defects identified during system testing and closed all defects in time
• Shared the test results with business partners and assisted in user acceptance testing
• Worked with change management team on implementation plans to production
• Implemented the code in production and supported the process till transitioning

Environment: Informatica power center 9.1, DB2, UNIX shell scripting, IBM Data studio, Control-M, IBM Mainframe

Confidential, Richardson, Texas

Software Engineer

Responsibilities:

• Involved in Project Cycle from Design phase to Implementation of Code. The focus is to secure the confidential information in Non-Production Environment.
• Gathering requirements from logged QC requests and processed accordingly to apply business logic by Initiating the Analysis at lower level.
• Good Knowledge in Understanding the different databases and their structures.
• Work with the application teams to understand data flows, tracking sensitive data elements in lower environments and observing all masking rules which are implemented according to business requirement.
• Created various tasks, arranged related tasks in different worklets, arranged different worklets in workflow depending upon their interdependencies in workflow manager.
• Designed Data Quality using IDQ and developed several informatica mappings.
• Design reference data and data quality rules using IDQ and involved in cleaning the data using Informatica Data Quality 9.1 environment.
• Modified the existing mappings for the updated logic and better performance and Worked on Mapplets and created parameter files wherever necessary to facilitate reusability.
• Implemented Data Masking techniques to the Production data and applied all the rules using the Mapplets, reusable transformations.
• Extracted Data from sources like SQL Server, Flat files, Teradata and captured for record and then implemented different masking techniques and then changes are being captured for same set of source and targets.
• Reduced complexity and time using re-usable components worklets, Mapplets, and transformations.
• Implemented Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Used Debugger wizard to remove bottlenecks at source, transformations, and target for optimum loads.
• Performed data validation testing writing SQL queries and listing the Test Cases for all possible scenarios using the debugger session in Designer.
• Worked with session logs, Error Handling and validated data populated by Unit testing and Integration testing on mappings.
• Performed Integration, End-to-End, system testing and Involved in Functional Testing & Regression Testing with SD’s and Testing team.

Environment: Informatica Power Center 9.2, IDQ 9.5.1, Oracle 11g, TOAD, SQL Server Management Studio, Teradata Assistant, DB2, Unix, MS- Access and Windows-NT.

Confidential, North Kansas City, MO

ETL/BI DEVELOPER

Responsibilities:

• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Spearheaded a project, actively participated in the requirement gathering with business users and solution designer, Functional and Technical design discussion with Knowledge Architect, split into stories and completed successfully.
• Developed mappings/Reusable Objects/Transformation/mapplets/user defined functions by using mapping designer, transformation developer and mapplet designer in Informatica Power center.
• Used various Informatica Power center and Data quality transformations such as - source qualifier, aggregator, update strategy, expression, joiner, lookup, router, sorter, filter, web services consumer transformation, XML Parser, labeler, parser, address validator, match, comparison, consolidation, standardizer , merge to perform various data loading and cleansing activities
• Implemented Slowly Changing Dimensions (SCD), facts, bridges and views in various mappings supporting the application system and developed scripts to create Oracle objects such as Tables, Views, Indexes.
• Extended logic for some of the existing mappings in the system to meet enhancement procedures.
• Written various Procedures, Functions in PL/SQL, tuned SQL queries to reduced bottlenecks and improve Performance.
• Used SQL tools like SQL Developer, PL/SQL Developer to run SQL queries and validate the data in warehouse.
• Extensive experience in integration of Informatica Data Quality ( IDQ ) with Informatica Power Center.
• Created various data quality mappings in Informatica Data Quality tool and imported them into Informatica power center as mappings, mapplets.
• Involved in performance tuning, query optimization and modified pre- and post SQL commands to add or recreate indexes to increase the loading performance.
• Created new subject areas in OBIEE , used Star schema to model the joins between Dimensions and facts. Renamed according to business needs
• Working on Oracle BI Administration tool 11.1, Involved in generating reports based on changes in MUD Environments.
• Migrating the data from different environments like Development to production for creating shortcuts and by creating deployment groups.
• Written implementation steps for all the stories part of the release for CSM’s and DBA’s to execute and move code to production.
• Worked with the Quality Assurance team to build the test cases to perform unit, Integration, Functional and performance Testing.

Environment: Informatica Power Center 9.6, IDQ 9.6.1, Oracle 11g, OBIEE, SQL, PL/SQL, MS- Access and Windows-NT.

Confidential, Lansing, MI

Sr. ETL - Informatica Consultant

Responsibilities:

• Involved in the complete life cycle development of the project including Analysis, Design, Development, Testing and Production support.
• Interacted with Business analysts to understand and convert Business Requirements to Technical Requirements.
• Designed and Developed mappings using which involve different sources that includes Flat Files, XML files and Relational tables from heterogeneous databases like Oracle, SQL server and DB2.
• Prepared High-level and Detailed Level Design Documents for Extractions, Validations, Transformations and Loading to target systems.
• Used IDQ to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes.
• Experience with the process of Data profiling by profiling different formats of data from different sources and analyzed its actual structure, the rules which are implemented as part of Standardization.
• Created business rules in Informatica Developer and imported them to Informatica power center to load the standardized and good format of data to staging tables.
• Very familiar about Sorter, Filter, Expression, Consolidation, Match, Exception, Association and Address validator transformations.
• Working extensively on Informatica Designer, workflow manager to create, sessions, workflows and monitor the results and validate them according to the requirement.
• Experience in performance tuning of Informatica mappings and sessions to improve performance for the large volume projects.
• Experience in debugging mappings, identified bugs in existing mappings by analyzing the data flow and evaluating transformations.

Environment: Informatica Power Center 9.5.1, DB2, Oracle, Flat Files, MS-Access, SQL-Developer, Crystal Reports, Dollar Universe, Control-M.

Confidential, Boston, MA

ETL Consultant

Responsibilities:

• Involved in the full life cycle development from Requirements gathering process to Design, Development, Testing and Production support.
• Involved in JAD sessions with End users and assisted Business Analysts in preparing Source-Target Mapping, Data Validation and Functional Design and Conversion Specification documents.
• Prepared Technical Detail Documents from the Functional Specifications gathered in JAD sessions.
• Worked with team leads and fellow developers in developing estimates for mapping designs and implementation deadlines.
• Extensively worked on Informatica IDE/IDQ.
• Involved in massive data profiling using IDQ (Analyst Tool) prior to staging and Used IDQ’s standardized plans for addresses and names clean ups.
• Used IDQ to complete initial data profiling and removing duplicate data and Performed many multiple tasks effectively and involved in troubleshooting the issues.
• Extensively worked with Data Analyst and Data Modeler to design and to understand the structures of dimensions and fact tables and Technical Specification Document.
• Developed Informatica Mappings using Mapping Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.
• Used Mapping Parameters, and Workflow Variables to fulfill the business requirements and Environment Specific Parameter files for development standards.
• Involved in Performance Tuning of sources, targets, mappings, sessions and data loads by increasing data cache size, sequence buffer length and target based commit interval.
• Design reference data and data quality rules using IDQ and involved in cleaning the data using IDQ in Informatica Data Quality 9.1 environment.
• Extensively involved in monitoring the jobs to detect and fix unknown bugs and track performance.
• Involved in Performance Tuning of sources, targets, mappings, sessions and data loads by increasing data cache size, sequence buffer length and target based commit interval.

Environment: Informatica Power Center 9.2, IDQ 9.x, Windows 2007, DB2, Teradata, Oracle, Flat Files, MS-Access, SQL-Developer, Teradata SQL Assistant, Control-M.

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

• Worked closely with BSA's and Team leads in acquiring business & technical requirements, customizations aspects to meet the warehouse requirements.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica Power Center.
• Extensively used different transformations in Informatica - Expression, Filter, Sorter, Sequence Generator, Aggregator, Lookup, Update Strategy, Router, and Joiner.
• Developed mappings to load data in Slowly Changing Dimensions to keep track of historical data.
• Created various tasks, arranged related tasks in different worklets, arranged different worklets in workflow depending upon their interdependencies in workflow manager.
• Used IDQ to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata.
• Experienced in massive data profiling using IDQ (Analyst tool) prior to data staging.
• Performed Unit Testing and Integration Testing of Mappings and Workflows.
• Tracking bugs in code and logging them into Test Director. Prepare the Test Plan for all the releases. Implementation and Update system documentation.
• Perform System testing and Regression testing for the new releases and making changes to test scripts for new deployments.
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads.
• Resolved many existing production issues in existing mappings by analyzing the data flow, evaluating transformations and fixing bugs so that they conform to the business needs.
• Performed impact analysis, remedial actions and documented on process whenever a new change is made to production mappings

Environment: Informatica 9.0, IDQ 9.x DB2, XML, Flat files, Oracle 9i/8i, UNIX, PL/SQL, SQL Developer, Windows NT.

Confidential

Informatica Developer

Responsibilities:

• Worked closely with BSA's and Team leads in acquiring business & technical requirements, customizations aspects to meet the warehouse requirements.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica Power Center.
• Extensively used different transformations in Informatica - Expression, Filter, Sorter, Sequence Generator, Aggregator, Lookup, Update Strategy, Router, and Joiner.
• Developed mappings to load data in Slowly Changing Dimensions to keep track of historical data.
• Developed PLSQL procedure to handle complex requirements that cannot be handled through ETL.
• Created various tasks, arranged related tasks in different worklets, arranged different worklets in workflow depending upon their interdependencies in workflow manager.
• Participated in Technical feasibility discussions, Peer reviews and in unit testing.
• Assisted the testing team in System Integration Test of the ETL application.
• Interacted with external, internal users and DBA in troubleshooting problems reported in huge Volume testing ( Million records Data) systems.
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads.
• Resolved many existing production issues in existing mappings by analyzing the data flow, evaluating transformations and fixing bugs so that they conform to the business needs.
• Performed impact analysis, remedial actions and documented on process whenever a new change is made to production mappings

Environment: Informatica 8.0, DB2, Sybase, XML, Flat files, Oracle 9i/8i, UNIX, PL/SQL, Windows NT, Brio 6.0

Confidential

Oracle Developer

Responsibilities:

• Developing stored procedures and database triggers and used user exits and PL/SQL interfaces to access foreign functions.
• Using triggers for block processing, interface events, master-detail relationships, message handling, mouse events, navigation, query-time processing, transactional processing, validation and key processing.
• Extensively involved in Coding PL/SQL, Packages, Procedures, Functions and Database Objects according to Business rules.
• Experience in using Arrays in stored procedures and processing it.
• Wrote extensive Sub-Queries, PL/SQL procedures, functions, database triggers and packages.
• Written and modified Shell Scripts to automate the data loading.
• Developed scripts to create Oracle objects such as Tables, Views, Indexes, Synonyms, Materialized views, Sequences, Cursors, Partitions, and Dynamic SQL.
• Involved in Performance tuning, which included creating Indexes, providing Hints, Gathering Stats, analyze tables and using Explain Plan utility.
• Tracking bugs in code and logging them into Test Director. Prepare the Test Plan for all the releases. Implementation and Update system documentation.
• Perform System testing and Regression testing for the new releases and making changes to test scripts in accordance with changing UIs
• Writing Test Scripts for various initiatives after analyzing BRD (Business Requirement Document) and User Interface documents.
• Wrote scripts for populating the database tables with test data.
• Performed unit testing, system testing and documentation of results.

Environment: Oracle 9i, SQL, PL/SQL, MS- Access, Visual Basic 8.0 and Windows-NT.