Quality Assurance Data Warehouse

Sandeep.Sriramdas

Contact no: 234-***-**** Email: ad5cqs@r.postjobfree.com

Professional Summary:

Over 2+ years of Professional Experience in Software DWH, Quality Assurance, Database Analyst, and Testing in different environments and platforms.

Expertise in Automated Software Quality Testing and manual Testing of Web-based and Client-Server applications and in Data Warehouse applications testing using Informatica Power Center and Data stage on multiple platforms.

Proficient experience in different Databases like Oracle, DB2, and Teradata.

Strong knowledge of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC), and QA Methodologies like Agile, Scrum, and Iterative process

Extensive experience in reviewing Business Requirement Documents and software Requirement Documents and preparing Test Cases, Test scripts, and Execution.

Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio, and data stage tools.

Extensive ETL testing experience using DataStage, Informatica (Power Center/ Power Mart, DVO, designer, Workflow Manager, Workflow Monitor, and Server Manager).

Experience in testing Business Reports developed in Business Objects and Cognos.

Good Knowledge of Business intelligence, OLAP, Dimensional modeling, Star and Snowflake schema, extraction, transformation, and loading (ETL) process.

Expertise in Testing Complex Business rules by creating mapping and various transformations.

Experience in testing and writing SQL and PL/SQL statements.

Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation, and Load (ETL) of data from Legacy systems using Informatica.

Extensive testing ETL experience using Informatica (Power Center/ Power Mart) (Workflow Manager, Workflow Monitor and Server Manager)

Extensive knowledge and experience in producing tables, reports, graphs and listings using various SAS procedures and handling large databases to perform complex data manipulations.

Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.

Expertise in PL/SQL Packages, Stored Procedures/Functions, and triggers.

Education –

Masters in Information Technology Management

Campbellsville University (Jan 2022 – Mar 2023)

Technical Skills:

ETL Tools

Informatica, DVO, Data Stage, SSIS.

BI Tools

Tableau, Cognos, OBIEE, Micro strategy, SSRS

Database Tools

Oracle, SSMS, Teradata, Sybase, DB2

Quality Assurance Tools /Test Management

SQL, PL/SQL, Visual Basic, DB Visualizer

Testing Tools

HP/ALM Quality Center, Jira, Test Director, TFS

Languages

SQL, SQL* Plus, PL/SQL, Teradata SQL Assistant, TOAD, Win SQL

Tools

MS Office suite (Word Excel, Project and Outlook)

Digital Intelligence Systems, LLC (DISYS), McLean, VA

AUG-2021-NOV 2023

Role: APP DEV QA ANALYST

Responsibilities:

Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.

Created test case scenarios, executed test cases, and maintained defects in HP ALM

Studied the feasibility of the reports by conducting the data analysis.

Plan and execute data migration projects, ensuring smooth transitions between different database systems or versions.

Validate and cleanse data during migration processes.

Design and develop database structures to meet the requirements of the organization.

Collaborate with software developers, data scientists, and other stakeholders to ensure the database design aligns with the overall system architecture.

Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using DataStage.

Identify any potential quality issues per defined process and escalate potential quality issues immediately to management.

Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e., backward navigation from target to source.

Used Business Objects Lifecycle Manager to migrate BI resources from one environment to another.

developers to resolve the bugs.

Involved in Unit testing and integration testing of Informatica mappings.

Experience in creating UNIX scripts for file transfer and file manipulation.

Preparing Defect Reports and Test Summary Report documents.

Checking the status of ETL jobs in UNIX and tailing the log files while the loading is under processing.

Used Business Objects Lifecycle Manager to migrate BI resources from one environment to another.

Developed the Test Plan and Testing Strategy for Data Warehousing projects.

Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.

Participated in defining and executing test strategies using agile methodology.

Prepared documentation for all the testing methodologies used to validate the Data Warehouse.

Environment: SQL Server, Informatica Power Center 10.2, Control M, Flat files, XML files, UNIX Shell scripting, SQL Assistant, ALM/HP Quality Center 11

Ascent, Concord, CA

Sep 2019- Feb 2020

Role: SQL/ETL Tester

Responsibilities:

Responsible for Gathering test requirements and scoping out the test plan.

Strong in performing backend testing using SQL on Informatica Power Center.

Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.

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.

Performed the Extract Transform and Load ETL source to target, utilizing Informatica Power center and Data Validation Option DVO

Wrote various documents describing DVO functionality, and how DVO should be used by group based on discussions with team lead.

Tested Informatica Power Center mappings. Performed data validations against Data Warehouse

Used TFS 2010(Team Foundation Server) for bug tracking, Work Item Tracking and published test results in TFS to share with the team members.

Defect Detection, Reporting and Tracking using TFS & Participated in Bug-Review meetings.

Attending agile meetings and working on monthly sprint backlog items and updating the activities in Microsoft TFS.

Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.

Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.

Worked with Oracle database to compare the results from front-end data values with backend data values.

Used all Teradata utilities including Fast Load, Multi Load, Fast Export, SQL Assistant, BTEQ and TPUMP

Executed the Test cases for Cognos Reports.

Extensively tested several Cognos reports for data quality, fonts, headers and cosmetic.

Assigning resources throughout the SDLC process based on the Test Estimates.

Participated in defining and executing test strategies using agile methodology.

Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.

Written SQL queries to access the data in Oracle database to execute back-end testing.

Involved in data warehouse testing by checking ETL procedures/mappings.

Involved in Implementing Agile (Scrum) methodologies for the complex project modules.

Worked with Data Conversion projects for testing data quality after migration.

Involved in testing data mapping and conversion in a server-based data warehouse.

Involved in testing Cognos Reports and closely worked with operations, and Release teams to resolve the production issues.

Involved in extensive DATA validation using SQL queries and back-end testing

Responsible for leading and coordinating with offshore team.

Environment: Informatica Power Center, DVO, SQL, PL/SQL, Agile/Scrum, Cognos, Teradata, Oracle, SQL Assistant, Microsoft TFS, Flat Files.

Contact this candidate