Data Test Cases

PARVATHI PADIBANDLA Email:*************@*****.*** Phone: 614-***-****)

Summary

Over 7 years of work experience in IT industry in analysis, design, development, implementation and troubleshooting in the area of ETL tool Informatica.

Extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.

Well acquainted with Informatica Designer Components - Source Analyzer, Target Designer, Transformation Developer, Mapplet and Mapping Designer.

Extensive experience in developing complex mappings from varied transformations like Router, Filter, Sorter, Connected and Unconnected lookups, Normalizer, Expression, Aggregator, Joiner, Union, Update Strategy, TCL, Stored Procedure and Sequence Generator.

Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2, type3.

Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.

Experience in creating and using Mapping Parameters, Mapping Variables, and Mapplets & Parameter files in Informatica Power Center.

Have some exposure to Teradata Utilities such as BTEQ, Fast Load, Fast Export, Multi Load, T pump, etc.

Experience in Performance tuning of targets, sources, Transformations, mappings and sessions.

Prepared migration document to move the mappings from development to testing and then to production repositories.

Worked with various look up cache like Dynamic Cache, Static Cache, Persistent Cache, Re Cache from database.

Strong knowledge in DW concepts like Dimensional modeling, Star schema/Snowflake modeling, Facts and Dimensions, Slowly changing dimensions, OLAP, Data Cleansing etc.

Strong experience in using SQL, PL/SQL Procedures/Functions.

Executing test cases and identifying mismatches and reporting defects into Quality Center and tracking them till they are fixed.

Created and modified test cases for functional and regression testing of business workflow.

Efficient in scheduling and monitoring Informatica jobs using Informatica scheduler, Crontab and ESP schedulers.

Ability to plan, organize, prioritize work and meet deadlines.

Ability to perform consistently under pressure and varied environment.

Education

Master of Computer Applications

Technical Skills

ETL Tools

Informatica Power Center 8.X/9.X (Repository Manager, Designer, Workflow Monitor, Workflow Manager), SSIS.

Databases

MS SQL SERVER 2008/2005/2000, Oracle 9i/10g/11g, Teradata 13.

Data Modeling Tools

Erwin 4.5/3.5.2 (Star Schema Modelling, Snow Flake Modelling).

Operating systems

Windows 98//2000/XP/NT/Vista, Windows 7, UNIX.

Scheduling Tools

Informatica scheduler, Crontab, ESP

Programing Languages

SQL, PL/SQL

Web Technologies

HTML, XML, Unix/Linux Shell scripting

Other Tools

AQT, Harvest, SQL Developer, Putty, Win SCP, Undraleu, CAWA workstation, ALM 12.21, Quality Center.

Professional Experience

Nationwide Insurance, Columbus, OH Mar 2016-Till date

Informatica Developer

Responsibilities:

Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data Warehouse.

Developed Informatica mappings by usage of Aggregator, Lookup, Filter and data flow management into multiple targets using Router transformations.

Used various transformations like SQ, Union, Filter, Expression, Joiner and Update strategy.

Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.

Created and used mapping parameters and mapping Variables.

Did unit testing and wrote SQL queries to ensure loading of data.

Involved in Performance tuning at source, target, mappings, sessions levels.

Extensively used expression, lookup, Update and router transformations.

Configured session properties and target options for better performance.

Configured sessions to send an email to notify business and production/Development teams when any Data errors/warnings occurs.

Migrated Informatica objects, ESP and BEE scripts from Development to higher environments.

Prepared migration document to move the code from development to testing and then to production repositories. Also, prepared Incident Resolution Documents to provide Production support.

Developed test cases and executed the test cases for Informatica objects.

Documented Test cases corresponding to business rules and other operating conditions

Experience in mentoring and providing knowledge transfer to team members and support teams.

Have good experience in solving production issues during nightly on-call support.

Environment: Informatica 9.6.1, Oracle 12c, Microsoft SQL Server 2008 or 2012, Putty, AQT (Advanced Query Tool), UNIX, ESP (IBM CICS Explorer), Harvest(workbench), CAWA Workstation, Undraleu, ALM 12.21, Quality Center.

Sunglass Hut International, Inc. Mason, OH Aug 2014-Mar 2016

Informatica Developer

Responsibilities:

Involved in Dimensional modeling (Star Schema) of the Data warehouse.

Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data Warehouse.

Developed number of complex Informatica mappings, reusable transformations to implement the business logic and to load the data incrementally.

Developed Informatica mappings by usage of Aggregator, TCL, Lookup, Filter and data flow management into multiple targets using Router transformations.

Created List file and Used Indirect method to load multiple source Files into one Target.

Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.

Migrated mappings, sessions, and workflows from Development to testing and then to Production environments.

Created and used mapping parameters and mapping Variables.

Created SCD Type2 mapping for inserting and updating the data in a dimension table.

Involved in writing the shell scripting for accessing the flat files from the FTP location and archiving the files.

Session performance was improved with pipeline partitioning and increasing block size, data cache size, sequence buffer length and target based commit interval. Involved in Performance tuning at source, target, mappings, sessions levels.

Created error log tables in database and sending the error rows to error table so that they can be corrected and re-loaded into a target system.

Configured session properties and target options for better performance.

Environment: Informatica Power Center 9.5.1, Oracle, SQL Server 2008, UNIX.

General Motors, Detroit, MI Feb 2013 – July 2014

Responsibilities:

Studied the existing environment and accumulating the requirements by querying the Clients on various aspects.

Used Informatica power center 9.1 to Extract, Transform and Load data into Data Warehouse from various sources like Oracle and flat files.

Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, router, Filter etc., transformations to implement complex logics while coding a mapping.

Created connected Lookup transformations to look up the data from the source and target tables.

Created a mapping to update the slowly changing dimensions to keep full history to the target database.

Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.

Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.

Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 9i.

Experience in working with Teradata Utilities such as BTEQ, Fast Load, Multi Load, T pump, etc.

Experience in Performance tuning of targets, sources, Transformations, mappings and sessions.

Monitored sessions that were scheduled, running, completed or failed.

Attended daily status call with internal team and weekly calls with client and updated the status report.

Environment: Informatica 9.0.1, Oracle 10g, Putty, PL/SQL, SQL, SQL Developer, Win SCP, Tera data 13, UNIX.

Allstate, Chicago, IL Aug 2011- Jan 2013

Informatica developer

Responsibilities:

Studied the existing environment and accumulating the requirements by querying the Clients on various aspects.

Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.

Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router etc., transformations to implement complex logics while coding a mapping.

Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.

Created connected and unconnected Lookup transformations to look up the data from the source and target tables.

Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.

Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).

Involved in the development of Informatica mappings and also performed tuning for better performance.

Monitored sessions that were scheduled, running, completed or failed.

Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica 9.0.1, Oracle 10g, PL/SQL, SQL, SQL Developer, UNIX, Win SCP.

L & T InfoTech, India Aug 2008- Sep 2009 Database/ETL Developer

Responsibilities:

Contributed to building a Data Warehouse to analyze the information about their sales and human resources. Designed Physical, Logical models and developed mappings, transformations, sessions and workflows to load in to a Data Warehouse.

Session performance was improved with pipeline partitioning and increasing block size, data cache size, sequence buffer length and target based commit interval.

Created Source to Target columns mapping sheet using MS-Excel.

Implemented Aggregate, Filter, Join, Expression, Lookup, Update Strategy, and Stored Procedure Transformations.

Created mappings with PL/SQL procedures/functions to build business rules to load data.

Worked with SQL joins, loops, aliases, views, Indexes and aggregate conditions.

Extensively used ETL to load data from different databases and flat files to Oracle.

Creating and running sessions and batches to load the data into the Target Database.

Environment: Informatica Power center 8.6.1, SQL server 2005, Oracle PL SQL, UNIX.

Contact this candidate