Data Quality Engineer

Name: Anamika Kumari

Position: Data Quality Engineer

Phone/e-mail: 937-***-****/********@*****.***

Location: Dayton, Ohio

Professional Summary

●Almost 6 years of IT experience in Data Quality testing in ETL and business Intelligence reporting/dashboards.

●Extensively used various ETL tools like Informatica PowerCenter 9.6/9.1/8, Informatica Data Quality (IDQ) 9.6/9.1, Informatica DVO 9.6.0, Microsoft SSIS for extracting, transforming, loading, and cleansing data from various source data inputs to various targets, in batch and real time and automating the ETL/Big Data testing.

●Working Experience with various Agile methodology and ceremonies, Scrum process and Kanban methodology

●Excellent knowledge in requirement analysis, test planning, test strategies and test schedules.

●Experience in CDC, daily load strategies of Data warehouse and Data marts, slowly changing dimensions (Type1, Type2, and Type3), Surrogate Keys and Data warehouse concepts.

●Used Informatica Data validation Option (DVO) to complete data testing quickly and easily by creating rules that test the data being transformed during the data integration process.

●Experience in leading, communicating, managing SLA and expectations of the senior management team and affected stakeholders during the planning and roll out of project releases.

●Experience in Testing Data pipeline Development with Azure Data Factory (ADF), Azure Data Bricks, Data Lake & Azure Blob

●Possess specific experience performing testing including Backend, Frontend, Regression, Functional, System, Interface, Usability, Black box, White box, Integration testing and User Acceptance Testing.

●Proficient in troubleshooting database issues and experienced in using performance monitor/profiler to solve dead locks/ long running queries.

●Experience in Business Intelligence testing in various reports using IBM Cognos, SAP Business Objects, MicroStrategy, Microsoft Power BI and Microsoft SSRS.

●Excellent Knowledge in Microsoft 365, Microsoft Visio, Microsoft TFS

●Strong analytical and quantitative skills with the ability to use data and metrics to back up assumptions, recommendations, and drive actions.

ETL Tool

Informatica Power Center, Informatica DVO, Microsoft SSIS, Microsoft Azure Data Storage, Azure Blob, Microsoft Azure data Factory (ADF), AWS, Redshift, S3,EC2

Business Intelligence and Reporting Tools

Microsoft SSRS, Microsoft Power BI, MicroStrategy

Database

Microsoft SQL Server, Teradata, Oracle PL/SQL, IBM DB2, Microsoft Azure database

IT Service Management

Incident Management, Change Management, Problem Management, Knowledge management, Project Management

ALM/DevOps Tools

ServiceNow, BMC Remedy, HP Service Manager, HP Quality Center, Microsoft TFS, Jira, Jenkins

Languages

SQL, Unix

Work Experience

Client: Wells Fargo

Position Title: Data and ETL Quality Engineer

Location: Remote San Francisco, CA

Period of Employment: July 2019 – August 2020

Description of Work Performed:

Created Test strategies, test plans, test cases and executed test cases for the ETL/Big Data & BI systems

Developed and executed detailed ETL related functional, performance, integration and regression test cases, and documentation.

Created test cases and executed ETL functionality to test – Source to Target Data count validation, data transformation validation, data length validation, duplicate data check, audit check, performance check.

Validated of data transformations and performed End-to-End data validation for ETL & BI systems

Performed data analysis, identified data dependencies with the source systems to create test data sets.

Developed SQL queries including complicated joins to verify proper mapping of data elements.

Wrote SQL queries to validate ETL transformation processes (SQL Server objects - Tables, Views, Stored Procedures, Triggers, Scheduled Jobs etc., CSV/XML/JSON data files).

Used various transformations like Address validator, parser, joiner, filter, matching to develop the maps.

Logged and tracked defect management tools such as HPQC, Microsoft DevOps TFS

Worked in data warehouse migration project from Teradata to Microsoft SQL Server

Worked for migration of mapping from Informatica Power Center to Microsoft SSIS

Migrating on-premises SSIS workloads to SSIS in Azure Data Factory (ADF).

Validated data migration from on-premises platform to Microsoft Azure

Tested data in Azure Blob, validated data ingested in SQL Server.

Validated the new data flows to new Azure platforms.

Worked with the Azure storage technologies (Azure Data Lake, Azure SQL Data Warehouse, Azure SQL Database)

Facilitated UAT with Product owners and Business owners.

Worked on Microsoft Team Foundation Server/Azure DevOps for Agile to create Epics, Features, User Stories.

Validated Microsoft Power BI dashboards and Microsoft SSRS report metrics and calculations

Actively participated and conducted Agile ceremonies like Stand-ups, User Story grooming, Sprint Review, Sprint Planning, Story pointing, prioritization meeting and Retro meetings.

Environment: Teradata, Microsoft SQL Server, Microsoft Power BI, Microsoft SSIS, Microsoft SSRS, Microsoft TFS, Service Now, HP Tidal Jobs, Agile, Microsoft Office 365, Unix, Microsoft Azure Data Factory, Azure Data Lake, Azure SQL Data Warehouse, Azure SQL Database

Client Name: Caterpillar

Position Title: Data and ETL Quality Engineer

Location: Peoria, IL

Period of Employment: April 2018 - July 2019

Description of Work Performed:

Validated ETL data using complex SQL queries.

Created Test Estimation, Test Planning, Test Case design and Test Case Execution for data warehouses across a variety of database types, including tests for database schemas, data management, data quality, data mapping, and health care regulatory compliance.

Created mockup data and capture the result sets against the jobs developed in test environment.

Updated the production support Run book, Control M schedule document as per the production release.

Monitored the production data loads, updated the bug tracker document with the issues, Identify the performance issues.

Performed Quality assurance check, Reconciliation post data loads and communicate to vendor for receiving fixed data.

Manually performed integration and regression testing, documented bugs and worked with development team to resolve issues.

Extensively used Informatica Data Quality (IDQ) profiling capabilities to profile various sources, generate score cards, create and validate rules and provided data for business analysts for creating the rules.

Used Informatica DVO for Table Pairs Test, value tests, single table constraints to test source to target mapping.

Imported various Sources, Targets, and Transformations using Informatica Power Center Server Manager, Repository Manager and Designer.

Assisted in the translation of other business data requirements into conceptual, logical, and physical data models.

Worked for migration of mapping from Informatica Power Center to Microsoft SSIS

Documented BI/DASHBOARD application deployments and services.

Documented steps needed to migrate database objects between various. environments including Development, UAT, Staging, and Production.

Created Remedy/Service Now tickets and/or incidents to trigger Control M jobs for FTP and ETL/ELT jobs on ADHOC, daily, weekly, Monthly, and quarterly basis as needed.

Developed data maps to document data attributes to data sources also data targets, including identification and documentation of data transformation algorithms.

Assisted in knowledge transfer to other technical staff members on business data processes.

Validated various Sources, Targets, and Transformations using Informatica Power Center Server Manager, Repository Manager and Designer.

Hands-on in Project Management Methodologies-Agile (Scrum) environment.

Actively participated in Agile ceremonies like Stand-ups, User Story grooming, Sprint Review, Sprint Planning, Story pointing, prioritization meeting and Retro meetings.

Work with ETL Admin, ETL and SAS admin teams for code deployments and health checks.

Created test dashboard and Reported test plans and verified counts between summary and detail reports various SAP Business objects dashboards.

Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.

Tested standard and Ad hoc reports and undergone data validation for the MicroStrategy reports.

Worked on multiple projects using Informatica developer tool IDQ of latest versions 9.1.0 and 9.5.1.

Worked on Production support cycle to address ETL job failures and dashboard failures.

Experience working with HP ALM tools like Agile, TFS, Jira.

Worked to find Root Cause Analysis of a ETL job failure and data anomaly.

Environment: Informatica Power Center 9.6.1/9.5, Informatica Data Quality (IDQ) 9.6, SQL Server, SQL, T-SQL, HP Quality Center, SSMS, MicroStrategy, MS Office Suite, Jira, Azure, SSIS.

Client Name: Amazon

Position Title: Etl/BI Quality Engineer

Location: Bangalore, India

Period of Employment: March 2016 - Jan 2018

Description of Work Performed

Involved in QA Analysis, Design, and Testing of the application.

Created Test strategy and Test Plans, reviewed requirements to ensure they were clear and testable.

Executed Test Scripts and Test Cases using manual testing procedures.

Designed test design documents and QA project development design documents.

Coordinated test activities with all testing resources.

Performed Regression testing on corporate and personal documents and fixed the errors.

Tested Data Stage ETL jobs according to data mapping requirements.

Testing to make sure that data is moved from source database to destination database by writing SQL queries.

Worked on Value added routines in Facets and provider and subscriber modules.

Involved in validating the claims, invoices coming as Electronic data Interchange transactions.

Involved in validated the communications, syntax, and compatibility of information between EDIs.

Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Worked on improving stored procedure and trigger performance.

Conducted Black Box (Functionality Testing), User Acceptance, and Regression testing.

Created Traceability Matrix to ensure that all the requirements are covered by the test cases.

Involved in testing Cognos reports for data quality and cosmetics according to requirements.

Conducted status report meetings with internal team on a weekly basis and Documented and tracked status meeting minutes and activities.

Provided clear concise feedback to Development team on recurring errors both on individual and team with aim of long-term reduction of defects found in final releases.

Conducted status report meetings with internal team on a weekly basis and Documented and tracked status meeting minutes and activities.

Provided on Call Support for Prod mission-critical (24x7) or problematic databases, and own problem resolution from end-to-end.

Extensive worked on Migrating Databases residing on servers in one data center to another and Upgrading Database platforms to newer versions.

Documented technical details of issues resolved and assist the team with building and maintaining technical repositories.

Work closely with the infrastructure team to perform SQL Server installations and to configure hardware and software so that it functions optimally with the DBMS. Plan and implement database upgrades as needed.

Environment: SQL Server 2005, MS SQL Server Reporting Services 2005, MS SQL Server Integration Services 2005, Microsoft SSRS, Flat Files, MS Office, XML, Windows Server 2003, Agile Scrum

Client Name: Infosys

Position Title: Etl/BI Quality Engineer

Location: Bangalore, India

Period Of Employment: June 2014 - March 2016

Description of Work Performed

Worked closely with business users to gather requirements, define project specifications, develop implementation and test plans for the projects & enhancements.

Designed, createded and tested reports to meet business requirements.

Produced the visual models for the application to create use cases, state charts, sequence diagrams and activity diagrams.

Created quarterly reports for each department in respect of their adherence to standard operating procedures and audit manuals.

Worked with ETL group for understating mappings for dimensions and facts.

Documented and maintained STM to ensure that all requirements are traceable from top to bottom and to provide a basis for test plan.

Worked as data architect or data modeler. Administers and controls an organization's data resources, including multiple relational databases and servers.

Carried out cause analysis of Database/SQL performance problems and recommend a solution for Production as well as Release environments.

Contributed to the ongoing development of technology and production processes company wide.

Kept abreast of new design tools, hardware, software and technology and make recommendations for future deployment.

Coordinated, scheduled and implemented database related patches, both software and security

Experience of Reporting, Analysis, and Integration Services (SSRS/SSIS/SSAS)

Performed Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse.

Created data mapping documents mapping Logical Data Elements to Physical Data Elements and Source Data Elements to Destination Data Elements.

Maintained documentation related to difficulties, complexities and anomalies that may arise during the ETL process.

Ability to analyze root cause of a problem and demonstrate good sense when handing the problem over to development.

Worked on migration project to migrate from IBM Data stage to Microsoft SSIS.

Environment: SQL, Oracle 9i, DB2, IBM Data Stage, IBM Cognos, Crystal Reports, Manual Testing, SQL Server 2003, UNIX log files, XML, Flat Files, MS Office, MS Visio, MS Excel.

Education: Bachelor of Technology in Applied Electronics and Instrumentation, BPUT India

Contact this candidate