PROFESSIONAL SUMMARY:

• 8 years of experience in software development maintenance testing and troubleshooting on Informatica Master Data Management MDM ETL/DWH applications data quality data integration and Oracle database
• Experience in software development maintenance testing and troubleshooting on Informatica Master Data Management MDM ETL/DWH applications data quality data integration and Oracle database.
• Gathering requirements from the Business and preparing the functional documents.
• Good experience in Data Warehousing methodologies/Dimensional Data modeling techniques such as Star/Snowflake schema using ERWIN.
• Extensively implemented Slowly Changing Dimensions Type1 Type2 Type3.
• Experience in Extraction Transformation and Loading ETL data from various sources into Data Warehouses using Informatica Power Center Power Mart Repository Manager Designer Workflow Manager and Workflow Monitor.
• Creating landing tables Staging tables Base Tables as per the data model and data sources
• Developing mappings using various cleanse functions and Address doctor functions to move data into Stage tables
• Defining Trust Score Validation rules Match rules and Merge settings
• Strong skills in SQL PL/SQL packages functions stored procedures triggers and materialized views to implement business logic in oracle database.
• Working with tools like TOAD SQL Developer and SQL plus for development and customization.
• Worked extensively on creating new CUSTOMER ONBOARDING process with new configuration on External matching Rules and processing the customer data before loading into MDM.
• Experienced in creating workshops with data stewards and business owners on match rules tuning IDD configurations and Trust scores and validations.
• Review the high level documents to ensure the requirements are addressed accordingly and discuss the possibilities of the requirements.
• Installed and configured Apache Hadoop, Hive and Pig environment on the prototype server.
• Configured SQL database to store Hive metadata and Loaded unstructured data into Hadoop File System (HDFS).
• Expertise using Informatica and Ab Initio ETL tools along with Business Objects and Cognos reporting tools.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Experience working closely with Test Data Management (TDM) team for data scrubbing. Used to send work order requests to Test Data Management team when sensitive data exists in source tables.
• Experience on Data warehousing concepts like OLAP, SCD modeling, ETL Process, Data Mart, Data Mining and Reporting.
• Experience in writing SQL Queries for different Databases such as Oracle, Teradata and SQL server and DB2.
• Excellent experience in various industries such as Banking, credit cards, mortgage financials and health care Insurance companies.
• Experience with automation Testing Tools of Selenium IDE.
• Extensive experience in developing complex SQL queries for data validation.
• Proficient in writing SQL scripts to validate ETL flow, Data Reconciliation, Initialization, and Change Data Capture, Delta Processing, Incremental process.
• Extensively worked on dimensions and Facts, Data cleansing and Data Staging of operational sources using ETL processes.
• Good experience with different data sources, data staging, data profiling, Data Cleansing, Data Scrubbing, data validation and Data Migration based on the business and functional requirements.
• Experience in testing Data Marts, Data Warehouse/ETL Applications developed in Informatica and Ab Initio using Oracle, DB2, Teradata, Sybase, Netezza, SQL Server and UNIX.
• Experience in testing Automated and scheduled multiple ETL jobs using UNIX Shell Scripting.
• Proficient in testing and monitoring batch loads in Data Warehouse using Control - M/Autosys, FTP, clean and archive process along with Error/ rejected records alerts
• Data Warehousing experience using Informatica Power Center 9.x/8.x/7.x (Workflow Manager, Workflow Monitor, Source Analyzer, Mapping Designer) ETL.
• Expert in working with fixed length, delimited flat files and also worked with large volume of data in the database/data warehouse.
• Expert in analyzing the error caused to failure of the ETL load with reference to the log file and report them to the corresponding team to get it rectified.
• Ability in validating and comparing the following (Expected-Actual): SQL-SQL; SQL-File; File-SQL; XML-SQL; SQL-XML
• Good understanding of data warehousing concepts like Star schema, Snowflake schema, Slowly Changing Dimensions, Fact and Dimensional tables etc.
• Experience in testing Web Based, Client Server Applications.
• Experience in Quality Assurance & Testing Phases including System Testing, User Acceptance Testing (UAT), Integration Testing, Smoke Testing and Regression Testing, Post deployment testing, shake out testing.
• Extensively worked with all phases of testing deliverables including creation of Test Strategy, Test plans, RTM, Test case specifications, Test execution, Defect tracking, Resolution, Documenting and Reporting.
• Expertise in analysis of Problem Severity and priority in Defects Reporting System using Test Management tools like Rational Clear Quest, Test Director, Mercury Quality Center and Application lifecycle management (ALM) and communicate toward the team to resolved it.
• Experience working with offshore teams. Ability to work on multiple projects which are in various phases of the system development lifecycle
• Worked in both Agile Environment and Water Fall methodology.
• Gathering requirements from the Business and preparing the functional documents.
• Review the high level documents to ensure the requirements are addressed accordingly.
• Able to work collaboratively with testers, developers and other team members in testing complex projects and in the overall enhancement of software product quality.

TECHNICAL SKILLS:

ETL Tools: Informatica 6.1/ 7.1/ 8.1/9.5/9.6.1, Ab Initio (GDE 1.14, Co>Op 2.14) and Data Stage 6.x/7.x/8.x, Informatica MDM 9.5.1

Reporting tools: Business Objects XIR2, SSIS, SSRS, Cognos 8.0, Crystal Reports 7.x.

Databases: SQL Server 2008 R2, Oracle 9i/10g/11g R2, Teradata SQL Assistant, Sybase, Netezza 7.0.2, MS access and DB2, NoSQL: HBase, SAP HANA, HDFS, MongoDB

Languages: C, SQL, PL/SQL, T-SQL, XML, HTML, XHTML, Shell Scripting, PERL, JavaScipt, and VB Script

Defect Tracking Tools: HP Quality Center, I-Cart, Rational Clear Quest, Mercury Test Director

Testing tools: QuickTestPro (QTP), Clear Quest and Load Runner, Selenium IDE

Scheduler Tools: Control-M and Autosys 4.5

Operating systems: Windows 2000/NT/XP/Vista/8.1, UNIX (Linux, Sun Solaris, IBM AIX)

Other skills: Siebel, Mainframe, Ultra Edit, WinSCP, Toad, XMLSpy 5.0

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr. ETL QA Analyst

Responsibilities:

• My tasks include data set-up, draft test cases based on business and system requirements and System test execution, System Integration Test (SIT) execution and supporting UAT.
• Extensively using Oracle, XML, DB2, Flat files and Informatica for data set-up, Informatica and UNIX box for Data Analysis and running batch jobs.
• The test cases and results are documented in Quality Center and SharePoint link.
• Worked closely with Business Analyst, System Analyst, and Developers to understand Requirements and Technical Design documents.
• Attended requirement/design meetings to understand project and testing scope.
• Developed test approach, test cases for informatica ETL’s based on technical specifications and Mapping documents
• Performed Integration test between LD, MBS POOL and cash Delivery systems.
• Submitted pools and commitments through Loan delivery portal.
• Identified Rule Failure scenarios and created XML messages with rule failure scenarios.
• Worked on Informatica 9.6.1 with development team, to resolve defects in SIT.
• Extensively involved in Interface System testing, Integration, Functional, Regression, Data Integrity, Compatibility, Installation, End to End Testing and User Acceptance testing.
• Ran Informatica workflows and sessions from the Informatica workflow manager and captured the run time.
• Extensively used TOAD to verify source data and target data after the successful workflow runs using SQL.
• Validated Informatica job dependencies for integration testing.
• Performed Shakeout test for Infomatica code, UNIX and DB.
• Executed Autosys jobs to load the data in ADS Target tables.
• Created links in DOORS and generated RTM.
• Raised defects in Clear Quest.
• Tested various UNIX Load Scripts and Informatica ETL data Validation.
• Validated the Source, Stage and Target (End-to-End) based on the test conditions derived from the business requirements.
• Validated Metadata for ADS target tables with reference to data dictionary and modeling document.
• Executed sessions and batches in Informatica and tracked the log file for failed sessions.
• Prepared the test data for incremental loads and Base loads.
• Involved in writing complex SQL queries by coming data from multiple tables with various filters
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica.
• Validated Informatica extraction, transformation and loading process by writing SQL against Business rules.
• Verified record counts, column data types, column values, exceptional handling and SCD1 & SCD2 functionality.
• Conducted the Regression tests after each and every bug fix.
• Created and Validated the XML files based on the defined XSD’s with the help of XML SPY.
• Validated vending XML messages from ADS to EDI, LDNG and EDQ.
• Coordinated with upstream and downstream systems and identifying the business scenarios.
• Worked closely with Developers in resolving the issues and discussing the functional dependencies.
• Worked to minimize risk by identifying, communicating issues/risks in advance.

Environment: Informatica 9.6.1, Oracle 11g R2, Sybase, Windows XP, Win 8.1, TIBCO, UNIX, Flat Files, XML files, SQL, ALM, ICART, GEMS, XMLSpy, TOAD, MS Excel, MS Access, Autosys 4.5.

Confidential, Washington, D.C.

Informatica MDM Developer

Responsibilities:

• Extensively used Informatica Client tools - Power Center, Work flow Manager, Workflow Monitor and Repository Manager.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, XML , XSD's , Flat Files.
• Developed complex mapping using Informatica Power Center tool.
• Extracting data from Oracle and Flat file, Excel files and performed complex joiner
• Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
• Created Sessions, Tasks, Work flows and worklets using Work flow manager.
• Exposure in configuring Informatica MDM Hub server, cleanse server and Address Doctor5 in Development, QA
• Configured the Landing Tables, mappings, staging tables, Base objects, relationships, Lookups, queries, packages, query groups, Batch groups
• Scheduling the batch jobs.
• Defined the Trust and Validation rules.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM .
• Took ownership for populating and validating lookup tables associated to data model.
• Ran batch jobs for customer, contacts, material, vendor, customer material domains
• Defined Match rules in Match and Merge settings of the base table by creating Match Path Components, Match Columns and Rule sets.
• Created IDD application to support the ongoing business needs to feed the data into the hub.
• Created roles, users for roles, and assigned privileges to roles using Security Access Manager
• Worked with Data modeler in developing STAR Schemas, Involved in performance tuning and query optimization.
• Used TOAD, SQL Developer to develop and debug procedures and packages.
• Involved in developing the Deployment groups for deploying the code between various environment (Dev, QA).
• Experience developing and supporting complex DW transformations
• Excellent understanding of Star Schema Data Models; Type 1 and Type 2 Dimensions.
• Created pre Sql and post sql scripts which need to be run at Informatica level.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Used Debugger to fix the defects/ errors and data issues.
• Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Monitored and improved query performance by creating views, indexes, hints and sub queries.
• Extensively involved in enhancing and managing Unix Shell Scripts.
• Developed workflow dependency in Informatica using Event Wait Task, Command Wait.

Environment: Informatica Power Center 9.5, Informatica MDM 10.0, HF2, 10.1, IDD, WebSphere, JBoss, Trillium, TFS, Oracle 11i, SQL Server 2008, MS Access 2010, FLINK, SQL*Loader, UNIX, WinSCP, Putty, Erwin 7.2, SQL, PL/SQL.

Confidential, New York

Informatica MDM Consultant

Responsibilities:

• Working with business analysts to gather business requirements and implementing the same into a functional data warehouse design.
• Prepared Business Requirement Documents (BRD's) referring to the Functional Requirements provided by System Users that described the scope of work for technical team to develop prototype and overall system.
• Involved in greater insights which are made possible by combining data from multiple payers and increasing the number of claims to detect new patterns and establish correlations with strong statistical validity.
• Combining data from multiple payers and creating a consistent provider identifier across those claims streams can highlight problems that might not be obvious from just one health plan.
• Worked on various Healthcare payers, including the Centers for Medicaid and Medicare Services (CMS), are banking on informed, engaged consumers to play an increasingly important role in driving down healthcare costs.
• Worked on an Agile SDLC model to deploy our product and customer data.
• Worked towards data modeling, baseline the data model to accommodate all business specific requirements and configured Informatica MDM Hub Server, Lookup Adapter, Cleanse Server, Cleanse Adaptor and Resource Kit.
• Implemented Data & Services integration with customer registry.
• Designed and created BO, staging tables, mappings, transformations as per business requirements.
• Created mappings to perform the tasks such as cleansing the data and populate that into staging tables.
• Used small sample data sets to complete DEV match iterations.
• Defined multiple conservative match rules for IDL .
• Used multiple server properties and cleanse properties for matching.
• Performed External match jobs.
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Responsible for creating user groups, privileges and roles to the users using Security Access Manager.
• Deployed new MDM Hub for portals in conjunction with user interface on IDD application.
• Worked on integrating Hierarchies created in MDM Hub Console and IDD.
• High level review of SAM - discussed use of Roles, creation of users and assignment of user to Role
• Implemented Search feature, Add/Update feature and Task Assignment feature in IDD for Admin user.
• Implemented Post Landing, Pre-Staging, Save Handler User Exits using Eclipse Mars and integrated those user exits with MDM Hub Console using User Object Registry module.
• Performed analysis, design, development and maintenance activities associated with the database and data in support of multiple applications (including following standards/procedures to achieve integration of systems through database design).
• Used ActiveVos Business process management model to deploy and manage process applications that combine system and human tasks.
• Using ActiveVos to create BPMN2.0 compliant process models that seamlessly integrate people, processes and systems for increasing the efficiency and visibility.
• Extensively worked on Informatica client tools - Source Analyzer, Warehouse Designer, and Transformation developer, Mapplet Designer, Mapping Designer, Workflow Designer, Worklet Designer and Task developer.
• Successfully Loaded Data into different targets from various source systems like Oracle Database , Flat files , XML files etc. into the Staging table and then to the target database.
• Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.
• Developed new and maintaining existing Informatica mappings and workflows based on specifications.
• Created Mapplets, reusable transformations, Worklets and used them in different mappings, workflows.
• Used Source qualifier, Expression, Aggregator, Lookup, Router, Normalizer, Sorter, Stored Procedure transformations to do necessary data calculations and manipulations according to the business rules and loaded data into Target systems.
• Performed trunk & Load process by using stored procedure transformation and load control table to stage the data.
• Worked on Slowly Changing Dimensions i.e. Type1 & Type2 and data ware housing Change Data Capture (CDC).
• Developed PL/SQL scripts, stored procedures, Indexes, Constraints and triggers in Oracle.
• Worked on production issues like bug fixing, bottlenecks, data validation and report errors.
• Expertise in creating complex reports in Cognos Report Studio such as List reports, Cross-tab reports, Drill through reports, Master-Detail Reports and Cascading Reports and involved in reports performance tuning.
• Experience in Metadata Modeling both Relational and Dimensional model.
• Created Projects, Models using Cognos Framework Manager and published packages to Cognos Server for reporting authoring.
• Performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Created pass through session partitions to improve performance of reading source data.
• Extensively used Shell scripts to automate the Pre-Session and Post-Sessions processes.
• Prepared test Scenarios and Test cases in HP Quality Center and involved in unit testing of mappings, system testing and user acceptance testing.
• Scheduled Informatica jobs through Control M as per the business requirement.
• Worked with reporting team to help understand them the user requirements on the reports and the measures on them.
• Involved in designing and developing the reporting requirements by using Business Object Xi3.1, Business Objects Report Designer.
• Created and maintained several custom reports for the client using Business Objects.
• Created List Reports and Cross Tab Reports and Drill Through reports.

Environment: Informatica MDM 10.1, Informatica Multi Domain Edition MDM 9.7.1 HF3, IDQ, IDD, SIF, Address Doctor5, ActiveVos, Informatica Power Center 9.6.1, Informatica B2B Data Exchange 8.6, Informatica B2B Data Transformation Studio 8.6, Cognos8.x, Control-M, Oracle 11g, PL/SQL, Visio, TOAD, SQL*Plus, Java, JBoss Application Server, XML, Windows, WinSCP, UNIX, Putty, Business Objects Xi3.1.

Confidential

ETL Developer

Responsibilities:

• Extensively involved in Interface System testing, Integration, Functional, Regression, Data Integrity, System, Compatibility, Installation, End to End Testing and User Acceptance testing
• Reviewed design changes, identified test scenarios, created test plan and test cases.
• Involved in scrum (standup) and used to update status of the tasks.
• Involved in project planning meetings and used to provide estimation of the testing tasks.
• Identifying/created test data that covers identified test scenarios.
• Tested and validated Informatica mappings.
• Knowledge and experience in various Informatica Transformations.
• Executed Informatica mappings in test environment and validated business functionality.
• Validated data in back end tables which is loaded through Informatica mappings.
• Extensively used Informatica Workflow Manager to run the workflows.
• Analyzed and tested Informatica Mappings with OLTP source data, staging and target data.
• Coordinated with business and development teams to resolve issues during test execution.
• Execution of UNIX, Autosys Batch jobs, retrieval of logs, identification for the source of errors.
• Responsibilities include meeting with the developers and client groups to determine performance requirements and goals and to determine test strategies that is based on requirements.
• Flexible and versatile to adapt to any new environment and work on any project in team
• Prepared status summary reports with details of executed, passed and failed test cases Interacted with developers, Business & Management Teams and End Users.
• Attended Bi-Weekly Defect Review and Defect Status meetings. Provided updates to Team Lead on testing activities.
• Reported the defects by entering in Quality Center defect tracking tool.

Environment: Windows XP, Informatica, PowerCenter 8.1, Manual Testing, Oracle, Putty, UNIX, Quick test Pro, Quality Center 9.0, Clear Quest 6.1, Autosys, SQL, PL/ SQL.

Confidential

QA Analyst

Responsibilities:

• Responsible for the creation and execution of Test Scripts based on functional specifications.
• Involved in review and verification of Test Scripts for Unit, Integration and Regression testing with the Technical Team.
• Involved in all the database changes to the development and test databases and implement SQL scripts as necessary.
• Tested different data warehouse transformations, created by using Informatica.
• Validated data at each Transformation.
• Validated data at each stage using SQL queries (ODS, Staging & Data Warehouse/Data Mart).
• Executed test scripts manually.
• Participated in automating the User interfaces using Win runner.
• Involved in End-to-End and User Acceptance Testing.
• Generated the detailed reports of the Bugs, Pass-Fail results, Comparison Chart and Defect Tracking and Defect Aging in Test Director.
• Participated in Code reviews.
• Actively involved in Regression testing for version releases and for customizing the software.
• Worked on the application Helpdesk/Support for queries or problems reported by the users.

Environment: Windows 2000, Manual Testing, Informatica 7.0, Test Director, MS Excel 2000, SQL-Server 2000, T-SQL, Java, XML, IBM Web Sphere Application Server 3.