SUMMARY:

• 7+ years of strong experience in business analysis, development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing ETL solutions using Informatica Power Center (9.x/8.x/7.x) and Informatica Data Quality (IDQ).
• Experience in developing ETL mappings and scripts using Informatica Power Center 9.6.1/9.1.0/8.6.1/8.5/8.1 , Informatica Data Analyst (IDA) tools using Designer (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer), Repository Manager, and Workflow Manager & Workflow Monitor.
• Conversant with all phases of Software Testing Life Cycle (STLC), Software Development Life Cycle (SDLC) in Requirement gathering, Analysis, Design, Development, Testing, Methods like Waterfall, AGILE, and SaFe Agile.
• Skilled in creating test Traceability Matrix, Test plan, Test design, Use cases, Test cases, Test procedures, Test log, and Defect reporting.
• Strong in Analyzing Business Specs and Developing Test Plans, Test Scripts and Test Cases and Execution. Worked on Test tools like Quality Center, ALM, and Quick Test Pro.
• Involved in Manual Testing of applications on Windows and UNIX Environment.
• Experience with structured QA Methodology and QA Processes to ensure the Quality Assurance Control.
• Highly Performed Back - end testing to check the Data Integrity throughout the database.
• Expertise in RDBMS backend testing for data validation and data integrity using SQL.
• Experience in testing and writing SQL and PL/SQL statements.
• Experience in performing GUI, functional, integration, system, regression, Performance testing and user acceptance testing in Client/Server, and Web based applications.
• Good knowledge on Use cases, Configuration Management. Executed negative and positive test cases to test application functionality against user requirements. Worked in Medium-paced as well as Fast-paced Projects with successful completion.
• Worked on Exception Handling Mappings for Data Quality, Data Profiling, Data Cleansing, and Data Validation.
• Experience in creating Metrics and Analytics to create Dashboards for better decision purpose.
• Expertise in data warehousing concepts, ETL programming using Server jobs, Job Sequencers, Batch Jobs and other data warehouse lifecycle tasks such as data analysis, cleansing, transforming, debugging/testing, and data loading across source systems.
• Expert in creating PL/SQL procedures, packages, functions, database triggers and other database objects like to generate back-end and front-end reports.
• Knowledge of data warehousing techniques, Dimensional Data Modeling, Star / Snowflake schema, Fact and Dimensions tables, physical and logical data modeling OLAP and Report delivery methodologies.
• Worked on Exception Handling Mappings for Data Quality, Data Profiling, Data Cleansing, and Data Validation.
• Used MS SharePoint to collect teams’ thoughts and knowledge and generated reports.
• Expert in creating PL/SQL procedures, packages, functions, database triggers and other database objects like to generate back-end and front-end reports.
• Involved in massive data profiling using IDQ (Analyst tool) prior to data staging.
• Performed data validation by Unit testing, integration testing and System Testing.
• Experience in integration of various data sources like Oracle, SQL Server, Teradata and flat files into staging area.
• Knowledge on reporting tools like Cognos and Tableau.

TECHNICAL SKILLS:

ETL, BI & Other Tools: Informatica Power Center 9.x.x, Informatica Developer 10, Business Objects, Cognos, SQL Server SSIS 2012

Operating Systems: MS Windows, UNIX

Testing Tools: HP QC, Quick Test Pro

Languages: SQL, Java, XML, HTML, R

Reporting Tools: Tableau, Cognos, MS SharePoint

Project Management: JIRA

RDBMS: Oracle 10g/11g/12c, DB2 and MS SQL Server

PROFESSIONAL EXPERIENCE:

Confidential, Blue Ash, OH

ETL Developer/Tester

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Create test plan, test cases and do the Unit testing, SIT and UAT and send them to projects lead for approval.
• Schedule the workflow using AutoSys. Sent error logs if any to project DBA's or assigned Project Leads to sort it out and resolve.
• Extensively used SQL queries for data validation and backend testing.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
• Preparation of Test Cases based on ETL Specification Document, Use Cases, Low Level Design document.
• Played role in creation and testing of designed scalable, reusable, and low maintenance ETL templates.
• Creating the expected results by executing the queries according to the test conditions.
• Raising defects where discrepancy found in the database and reporting it to the onshore development team.
• Guiding new resources to make them familiar with the project work.
• Provide demos/walk through regarding testing results.

Environment: Informatica Product Information Management (PIM 360), Informatica PowerCenter 9.6.1, JSON, Beyond Compare, Agile, HP QC, JIRA, SQL.

Confidential, NYC, New York

ETL Developer/Tester

Responsibilities:

• Worked in Agile methodology consisting of daily stand up sessions, two- week Sprints, Poker planning sessions and task cards.
• Involved in Preparing the High-Level Design (HLD) and Low-Level Design (LLD) documents for ETL Informatica process.
• Performed Data validity testing for Business Objects reports and based on client’s requirements.
• Involved in functional, explanatory, and Integration testing.
• Involved in writing complex SQLs.
• Identified data streams and reviewed data models for testing strategies.
• Extensively used Informatica Designer, Workflow Manager, and Workflow Monitor for testing the mapping logic during Functional testing. Performed integrated testing, end- end testing and validated results with Product Owner and/or customer.
• Developed several generic Informatica jobs which can be reused for several processes.
• Designed and developed complex mappings that involved Slowly Changing Dimensions, Error handling, Business logic implementation.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Extensively used bulk collection in PL/SQL objects for improving the performance.
• Involved in migration of Informatica Mappings, Sessions, and Workflows from development to System Test environment and execute the code in System Test Environment.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Developed complex mapping logic using various transformations like Expression, Lookups (Connected and Unconnected) Joiner, and Filter, Sorter, Router, Update strategy, Sequence generator, Rank, Aggregator, SQL, Xml, and Normalizer.
• Updated weekly status on the testing progress and other concerned issues.
• Involved in Formal Reviews and walkthrough for preparing test cases and test plans.
• Test case management using Quality Center.
• Involved in data modeling.
• Written test cases for ETL to compare Source and Target database systems.
• Developed Traceability Matrix of business requirements mapped to test scripts to ensure any change control in requirements leads to test case update.
• Conducted regression testing on the application under Test.
• Involved in User Acceptance Testing (UAT) and of the end users to improve business process.
• Used JIRA for defect tracking.

Environment: Informatica PowerCenter 9.6.1, Informatica Data Quality 10, Oracle 11g, MS SQL Server 2012, SQL, PL/SQL, UNIX, HP QC, JIRA, Agile.

Confidential, San Jose, CA

ETL Developer/Tester

Responsibilities:

• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Analysed the business requirements and technical specification documents.
• Prepared Test plan and Test strategy documents.
• Validated source files received from the source systems.
• Create test data to cover all positive and negative scenarios.
• Validated the load process of ETL to make sure the target tables are populated according to the data mapping provided that satisfies the transformation rules.
• Performed root cause analysis and backtracking the issue up to the source data if any discrepancy found it the data.
• Developed various mapping, mapplets/rules using the Informatica Data Quality (IDQ) based on requirements to profile, validate and cleanse the data using different IDQ transformations.
• Developed various complex stored procedures, packages, interfaces and triggers in PL/SQL.
• Developed complex mappings in Informatica to load the data from various sources
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure.
• Developed PL/SQL scripts to transfer tables across the schemas and databases.
• Writing validation packages using PL/SQL package using Data Structures.
• Tested the entire data reconciliation process for multiple source and target systems.
• Used Informatica Power Center 9.5/9.6.1 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure.
• Work closely with software developers/project owners and BAs to develop and execute thorough test suites in all phases of the software development cycle.
• Develop Test strategy, test plan/design, execute test cases and defect management for the ETL & BI systems.
• Worked with Informatica IDQ to determine Data Quality issues and Remediation process for bad data.
• Develop and execute detailed ETL related functional, performance, integration and regression test cases, and documentation.
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
• Analyze and understand the ETL work flows developed.
• Create UNIX shell scripts to access and move data from production to development environment.
• Performed back end testing by writing SQL queries to check data integrity, row-counts, and measures.

Environment: Informatica PowerCenter 9.5/9.6.1, Informatica IDQ, HP QC, JIRA, Agile, Oracle SQL, UNIX.

Confidential

ETL Developer/Tester

Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Designed ETL specification documents for all the projects.
• Created Tables, Keys (Unique and Primary) and Indexes in the SQL server.
• Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
• Extensively used the Add Currently Processed Flat File Name port to load the flat file name and to load contract number coming from flat file name into Target.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance. Involved in Test Requirement Analysis using Technical and Functional Specification documents.
• Participated in Business Walkthroughs to understand the Business functionality and its impact.
• Coordinated system test activities and necessities with business, development and pre-production groups.
• Prepared Test Plan, Test Cases based on BRD and Data Architecture Design for process and data testing.
• Developed complex test scripts/SQLs to perform validation.
• Extensively involved in data modeling.
• Conducted test plan and test case reviews with project team and users.
• Performed data analysis to understand the data transformation from source to target.
• Developed Traceability Matrix to match requirements.
• Participated in System Specification and Design documents.
• Used Informatica Power Center 9.6.x/9.5 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Developed complex mappings in Informatica to load the data from various sources.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure.
• Experienced on creating profile, rules and mapping with IDQ and worked on IDQ transformations like labeler, parser, standardizer, match, Merge and Exception.
• Used Oracle SQL developer for creating PL/SQL (Trigger, sequence, stored procedure).
• Developed stored procedures in PL/SQL for cleaning up data and providing underlying structure for reporting using SQL.
• Created complex stored procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins to implement business rules.
• Prepared various documents like Validation Rules and Mapping Document.
• Documented use cases and test cases in Quality Center.
• Executed test cases using the SQL queries.
• Worked with Data Warehouse developer who extensively used Informatica tools to design mappings to move data from source to target database- using Stages to understand the functionality.
• Created ETL test data for all ETL mapping rules to test the functionality of the mappings.
• Worked with Workflow Manager in scheduling workflows, worklets, and tasks.
• Used JIRA for defect tracking.

Environment: Informatica PowerCenter, Oracle 10g/11g, SQL, OLAP, PL/SQL, UNIX, HP QC, JIRA, Agile.

Confidential

ETL Developer/Tester

Responsibilities:

• Involved in the analysis of the user requirements and identifying the sources.
• Created technical specification documents based on the requirements by using S2T Documents.
• Involved in the preparation of High- level design documents and Low- level design documents.
• Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.
• Administered the repository by creating folders and logins for the group members and assigning necessary privileges.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and oracle tables to target tables.
• Worked on various kinds of transformations like Expression, Aggregator, Stored Procedure, Lookup, Filter, Joiner, Rank, Router and Update Strategy.
• Developed reusable Mapplets and Transformations.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Involved in monitoring the workflows and in optimizing the load times.
• Involved in writing procedures, functions in PL/SQL.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Worked with SQL*Loader tool to load the bulk data into Database.
• Prepared UNIX Shell Scripts and these shell scripts will be scheduled in AUTOSYS for automatic execution at the specific timings. n)
• Prepared test Scenarios and Test cases in HP Quality Center and involved in unit testing of mappings, system testing and user acceptance testing.Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Involved in developing test plan, test cases, and test scripts using Quality Center for Functional and Regression testing.
• Responsible for dimensional modelling of the data warehouse to design the business process.
• Parsing high-level design specification to simple ETL coding and mapping standards.
• Used SQL queries and database programming using PL/SQL (writing Packages, Stored Procedures/Functions, and Database Triggers).
• Worked on SQL tools like TOAD to run SQL queries and validate the data.
• Worked on database connections, SQL Joins, views in Database level.
• Created Informatica mappings with PL/SQL procedures to build business rules to load data.
• Most of the transformations were used like the Source qualifier, Aggregators, Connected & Unconnected lookups, Filters & Sequence.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Executing test scripts to verify actual results against expected results.
• Involved in Data Mapping specifications to create and execute detailed system test plans.
• Tested complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the staging area with data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables.
• Created ETL test data for all ETL mapping rules to test the functionality of the mappings.
• Tested the ETL workflows and other ETL processes.
• Wrote several complex SQL queries for validating/verifying the business rules for Data.
• Worked with complex stored procedures and functions as per requirements.
• Experienced in testing mappings, mapplets, and complex transformations using Information Designer.
• Worked with Workflow Manager in scheduling workflows, tasks, and sessions.
• Used QC to write test cases.
• Used JIRA for defect tracking.

Environment: Informatica PowerCenter, Oracle 10g, SQL*Loader, Autosys, SQL, OLAP, PL/SQL, UNIX, Java, HTML, XML, Windows, DB2, HP QC 9.1.