Home

Sathya - ETL Tester, Tester

[email protected]

Location: Englewood, Colorado, USA

Relocation: All over USA

Visa: H1B

Resume file: Sathya Kannan- QA-ETL Tester_1750772478058.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

Sathya Kannan Professional Summary Around 9 years of IT experience in testing of Data Warehouse (ETL/BI) applications. Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources, and scheduling Experience in all phases of Software Development life cycle such as Agile, Scrum, Waterfall, Kanban, Waterfall hybrid. Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices Good understanding in the concepts of Data modeling, slowly changing dimensions, Star schema & snowflake schema and Business process testing, Data analysis and experience in testing the reports. Expertise in performing all kinds of testing like black box testing, white box testing, grey box testing, functionality testing, integration testing, regression testing, performance, boundary testing, System testing and UAT testing. Led functional testing for Integrated Eligibility (IE) systems on both Customer and Worker Portals, ensuring compliance with business and policy requirements. Conducted detailed testing of eligibility determination workflows, including application intake, renewals, verifications, and notice generation. Expertise in using Quality Center & HP ALM for designing, writing, implementing, and maintaining the Test Plans, Test Cases, Test Execution, Defect management, Bug Reporting, and familiarity with other features of Quality Center and Administration. Designed and executed test plans, test cases, and test scripts based on eligibility rules, system requirements, and use cases. In depth technical understanding of Data Warehousing, Data Validations, OLAP, SQL Server and Oracle Knowledge in Business Intelligence tools like SSRS, Power BI, Tableau Expertise in designing the test scenarios and scripting the test cases to test the application. Expertise in Agile/SCRUM Process, V-Model and Waterfall Model methodologies and extensive work experience on QA process and Approaches Automated and scheduled the Informatica jobs using UNIX Shell Scripting Good working experience in Oracle, Unix Shell Scripting Strong in testing Stored Procedures, Functions, Triggers, and packages utilizing PL/SQL. Extensively strong on databases including Oracle, MS SQL Server, and Teradata Experience in testing and writing complex SQL, T-SQL, and PL/SQL statements to validate the database systems and for backend database testing. Technical Skills: Languages: SQL, PL/SQL, HTML, Shell Scripting Databases: Oracle, MS SQL Server, MS Access, Teradata, DB2 Reporting Tools: Power BI, SSRS, Tableau Tools: TOAD, Win SQL, Teradata SQL Assistant, XML Methodologies: Agile (Scrum), TDD (Test Driven Development), Waterfall Tools: MS-Office suite (Word, Excel, Project, and Outlook), Microsoft Teams Testing Tools: HP ALM, Jira ETL Tools: SSIS, Informatica Power Center, DataStage Charter Communications, Denver, CO April 2023-Present EDW/ETL QA Specialist Responsibilities: Interaction with Business/System Analyst team members to understand the project scope and business task with BRD s. Worked on agile environment. Prepared tests related documents including Test Plan, Test procedures, Test Scenarios, an Testcases. Performed all aspects of data verification, validation including functional, regression, retesting, system testing, positive, and negative, integration testing, smoke, back-end, and security testing. Attended daily stand-up, sprint grooming, sprint planning, sprint review and retrospective meetings. Extraction of test data from tables and loading of data into SQL tables. Written SQL statements for various business scenarios. Performing web analytics, data extraction, data analysis using SQL and Tableau software for visualization. Collaborated with business analysts and stakeholders to translate Charter-specific eligibility policy rules into detailed test cases and scenarios. Used python scripts to update content in the database and manipulate files. Created Various Informatica Power Center Graphs for preparing the test data and validating the data. Responsible for Data mapping testing by writing complex SQL Queries using WINSQL. Experience in creating UNIX scripts for file transfer and file manipulation. Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices. Worked with developers with advanced SQL training and mentoring how to write functions, stored procedures and ad-hoc SQL and learned advanced set-based queries in SQL server 2019 and T-SQL features. Written & Executed test cases based on acceptance criteria prepared test plan document and created test strategy for the project. Used Informatica Power Center Workflow Manager to run the workflows. Involved in user training sessions and assisting in UAT (User Acceptance Testing). Carried out manual testing for various modules of the product as per test plan. Expert in writing SQL scripts in querying SQL Server Management Studio (SSMS). Validated the data in excel spreadsheets to compare the data. Performed manual testing to validate APIs. Tested the functionality and performance of web services using SOAP UI test automation framework. Involved in testing of services using SOAP/REST services using SOAPUI, Groovy Scripts. Worked on SOAP UI for Web services API testing. Worked on automation scripts usings Maven & Jenkins for continuous integration using GitHub to store the framework and all automated scripts. Effectively using data blending feature in tableau. Involved in testing data mapping and conversion in a server-based data warehouse. Involved in testing the XML files and checked whether data is parsed and loaded to staging tables. Environment: Informatica, Tableau, SQL, UAT, SOAP UI, Agile, Shell Scripting, Oracle, SSMS, XML U.S. Anesthesia Partners, Dallas, TX May 2018-Mar-2023 Sr. ETL QA/Data Warehouse Tester Responsibilities: Prepared Execution procedure document format to prepare the Test cases based on mapping document. Ensured that the mappings are correct and Conducted data validation testing. Worked with business analyst to understand the business requirements and the developers for the reproducing the defects and setting up of a test data support. Created complex SQL queries to verify the Reports and data validations. Prepared Test Plan, Test Scenarios & Test Cases based on Business Requirement Document. Worked within the current QA methodologies, standards, and procedures to create, implement, and maintain the Test Plans, Test Cases, Test Execution, Defect tracking and Bug Reporting for ETL process using Azure DevOps test suites and JIRA tickets. Experience with testing various SSIS packages for data transformation to ensure the data integrity by writing SQL query to validate the data such as duplicate validation, table structure validation, historical update validation and source to target row counts. Using JIRA (workflow manager) for team communication on defect management and updating the test results document. Performed different kinds of manual testing like Functional and Integration and End-to-End tests during different phases of testing life cycle. Written several complex SQL queries for validating the reports manually. Performed Build Verification Testing, Smoke Testing, System / integration Testing and Regression Testing of the application. Attended Sprint Planning, defect triage, story grooming, retrospective meetings and UAT Kick off meetings. Involved in writing test scenarios and test cases for manual testing. Validate SQL Performance tuning of store procs, queries and indexes for production performance enhancement of EDW legacy databases using MS SQL server(T-SQL). Tested several dashboards and deployed them across the organization to monitor the performance. Experience with data warehouse, data mart testing for various database schemas objects like tables, stored procedures, user-defined functions, views, mapping etc. using MS SQL Server(T-SQL). Manually tested the data through SQL query for data validation, constraints, source to target row counts. Extracted data from various sources like flat files and SQL Server. Through testing of SCD1 and SCD2 in dimension tables. Worked on Advanced Pl/SQL packages, procedures, triggers, index to implement business logic using SQL Navigator. Extensively tested SSRS reports with use of complex SQL queries for data accuracy and universe related errors. Responsible for different Data mapping activities from Source systems to Teradata. Performed extensive testing on Power BI dashboards and reports developed based on non-functional requirements such as reliability, scalability and performance. Performed end-to-end testing of applications and coordinated with other teams on data Integration and migration testing. Created test strategy/scenarios and test case and created complex SQL queries and reviewed python scripts to verify and validate data across multiple stage within AWS Validated data for various database schemas for migration project from MS SQL Server to AWS Redshift in DBeaver using PostgreSQL. Performed all aspects of data verification, validation including functional, regression, retesting, system testing, positive, and negative and security testing. Environment: SSIS, SSRS, SQL, UAT, Jira, Agile, Test Plans, Test Cases, Test Scenarios, SOAP UI, AWS, XML, SQL, Oracle, DB2. The Home Depot, Atlanta, GA Jul 17 May 18 ETL QA/BI/Data Warehouse Tester Responsibilities: Performed all aspects of data verification, validation including functional, regression, retesting, system testing, positive, and negative and security testing. Attended daily-stand up s, sprint planning and retrospective meetings. Written SQL statements for various business scenarios. Tested data migration manually to ensure data integrity and data was not compromised. Written & executed test cases based on acceptance criteria. Performed Manual Testing to check usability of the system. Extensively involved in manual testing of the Application. Performed Regression testing for the POS (Point of sale) transaction scenarios. Expert in writing SQL scripts in querying SQL Server Management Studio. Interaction with Business/System Analyst team members to understand the project scope and business task. Developed test scripts using QTP for Functionality and Regression Testing Involved in tracking defects using JIRA and all testcases are maintained and executed in qTest Manager. Verified and validated tabular model and extensive Power BI dashboards. Performed Data Analysis and data validation including data completeness, Data Transformation and functions, Data Quality. Wrote Manual Test cases for POS (Point of sale) based on Functional and Business requirements. Strong in performing backend testing using SQL on Informatica. Writing or creating UNIX scripts for file manipulation. Generated automated test cases on first build of the module using QTP, Rational Tools. Tested several ETL jobs for loading purpose and tested incremental/Full load. Strong experience in using Informatica Data Quality (IDQ) tool. Complex quality rule. Using JIRA (workflow manager) for recording Test cases, Test Executions, Bugs. Written SQL queries to test reports developed by POWER BI based on functional and non-functional requirements. Used SQL tools to run SQL queries and validate the data loaded into the target tables. Validated the data in excel spreadsheets to compare the data. Performed the data profiling and analysis making use of Informatica Data Quality (IDQ) Documented all the testcases, test results and test scripts for a given task in JIRA. Internal documents are reviewed in Box folders and shared to access it. Environment: Informatica, Power BI, SQL, Agile, SQL Server, UAT, UNIX, QTP/UFT, XML, JIRA, Oracle, qTest Manager. XL Catlin, Hartford, CT Feb 16-Jun 17 QA ETL Tester Responsibilities: Worked on agile environment. Performed all aspects of data verification, validation including functional, regression, retesting, system testing, positive, and negative and security testing. Involved in web services testing using SOAP UI, validated request, and response XML. Managed implementation for Confidential (Credit Risk Data and Repository) with Composite (Data Virtualization) Involved in tracking defects using HPALM and all testcases are maintained and executed Manager. Performed Data Analysis and data validation including data completeness, Data Transformation and functions, Data Quality. Attended daily-stand-up, sprint planning and retrospective meetings. Written SQL statements for various business scenarios. Tested data migration to ensure data integrity and data was not compromised. Written & executed test cases based on acceptance criteria. Extensively used various Informatica active and passive transformations like Filter Transformation, Router. Responsible for all aspects of using Business Objects Data Integrator Expert in writing SQL scripts in querying SQL Server Management Studio. Interaction with Business/System Analyst team members to understand the project scope and business ask. Provide customer service and support for Property & Casualty risk management needs. Through testing of SCD1 and SCD2 in dimension tables. Used SQL tools to run SQL queries and validate the data loaded into the target tables. Validated the data in excel spreadsheets to compare the data. Improved session Performance in Informatica by enabling property incremental aggregation to load incremental data into target table. Documented all the testcases, test results and test scripts for a given task in HP ALM. Internal documents are reviewed in Box folders and shared to access it. Environment: Informatica, SQL, UAT, UNIX, XML, SQL Server, SOAP UI, HP ALM, Agile, Oracle. EDUCATION: Master of Science in Computer and Information Science University of Massachusetts Dartmouth, North Dartmouth, MA Bachelor of Engineering in Computer Science Jeppiaar Engineering College, Chennai, TN Keywords: quality analyst user interface business intelligence active directory information technology hewlett packard trade national microsoft procedural language Colorado Connecticut Georgia Massachusetts Tennessee Texas