Data Manager

MALA KUMARI

908-***-**** / ************@*****.***

Piscataway, NJ

PROFESSIONAL SUMMARY

Excellent understanding of Quality Assurance processes and SDLC (Waterfall and Agile)

Execution of Automation scripts on Selenium based TAPSIUM portal

Expert in System Integration Testing, Regression, and User Acceptance Testing (UAT)

Extensive experience in developing, executing and maintaining Test Scenarios, Test Plans, and Test Cases based on business requirements.

Represent QA team in all phases of product development including requirement, design, construction, testing, implementation, code reviews and support.

Hands on IT experience in Analysis, Design, Development, Implementation and Support of Relational Database (OLTP), Data Warehousing Systems (OLAP) and Data Marts in Pharmacy, Insurance, Financial, and Healthcare sectors.

Extensive experience in using Informatica Power Center 9.1/8.6.1/8.5/8.1., Power Exchange, Power Mart 5.x/4.x, and IBM Websphere DataStage 8.0.1 (Designer, Director, Administrator) & QualityStage.

Extensively used Informatica Client tools like Designer, Workflow Manager, Workflow Monitor, Repository Manager and Server tools – Informatica Server, Repository Server.

Strong technical background, and posses excellent analytical & Communication skills, Creativity, Leadership qualities, Team spirit & above all a Positive attitude to shoulder successfully, any responsibility or challenges.

TECHNICAL SKILLS

Testing

QC ALM, JIRA, SMART, Share Point, Tapsium

ETL Tools

IBM Websphere DataStage 8.0.1 (Designer, Director, Administrator), Informatica Power Center 9.1/8.6.1/8.5/8.1, QualityStage

RDBMS

Oracle, MS SQL, mysql, Microsoft Access, DB2, SQL Developer

Defect tracking Tools

HP Quality center 11.5, 12.20

Scripting Languages

Unix Shell Scripting

Languages

SQL, PL/SQL, HTML, XML

Other Tools & Utilities

SQL* Plus, TOAD, MS Office 2010 (Word, Excel, Power Point, Access)

Operating Systems

Windows 2000/2003/NT/XP, UNIX

PROFESSIONAL EXPERIENCE

Verizon Wireless, NJ June 2015 – Current

ETL Developer (IT- POS)

Responsibilities:

Responsible for analyzing, and developing ETL strategies and processes.

Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.

Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.

Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.

Created unit test cases for mappings developed and verified the data.

Fixed the invalid mappings and troubleshoot the technical problems of the database.

Met deadlines and worked closely with the different team for the task completion.

International Systems Technologies, NJ Jan 2015 – June 2015

(SAFESEA) - Quality Assurance Analyst (IT)

Responsibilities:

Analyzed, documented and validated QA work product for the new enhancements to be launched in the market against the Business Requirements Documents as part of the SDLC activity.

End to End testing of systems for every release.

Responsible for interacting with Project Leaders/ Team Leaders for understanding client’s specification for testing the application.

Involved in GUI, Functional, Regression and System Testing.

Creating, reviewing and setting up of test data

Creating and participating in the functional, integration, database/back-end and system testing activities.

Preparing daily status and weekly status reports

Collating metrics and preparing test completion and sign-off reports

Tata Consultancy Services,(TCSL) India

Client: Walgreens April 2013 to Aug 2014

ETL / Data Warehouse developer

Responsibilities:

Worked with Flat files with Various Data Files coming from Various Sources.

Worked with stages like transformer and Hash files, Aggregator, sorter etc

Used DataStage Designer to create complex mappings

Used QualityStage to coordinate the delivery, consistency, removing data anomalies and spelling errors of the source information

Involved in designing Star Schema for the business processes.

Develop UNIX Shell scripts and schedule the jobs.

Extracted the data from Oracle, Flat files and load into Data warehouse.

Developed complex mappings using multiple sources and targets in different databases

Developed the transformation logic to load data into Data warehouse

Used Oracle, Sequential files. Hash files, Transformer, in designing the ETL jobs

Involved in Understanding the Business Requirements and map to the Technical Requirements.

Performed Unit testing

Client: Eli Lilly Oct 2011 to March 2013

ETL Developer

Responsibilities:

Participated in requirement gathering, Business Analysis, user meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.

Involved in the extraction, transformation and loading of data from source flat files and RDBMS tables to target tables.

Worked with Informatica Power Center Mapping Designer, Workflow Manager, Workflow Monitor and Admin Console.

Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Lookup, Stored Procedure, Joiner, Update strategy, Expression and Aggregator transformations to pipeline data to Data Warehouse/Data Marts.

Handled slowly changing dimensions of Type1/Type2 to populate current and historical data to dimensions and fact tables in the Data Warehouse.

Extensively worked with Informatica Designer. Designed and developed Informatica mappings for data loads and data cleansing.

Developed and documented Informatica Mappings/Transformations, and Informatica sessions in a detail design document.

Created Sessions and Batches to run Workflows.

Responsible for writing unit test cases and performing the unit test.

Worked with the QA team in order to determine the data validation and performed the data validating at the source and the target database level.

Involved in Production support and trained the other developers to handle issues.

EDUCATION:

• B. Tech (ENGINEERING), Biju Pattnaik University of Technology, Bhubaneswar, Orissa (INDIA) - 2011

Contact this candidate