Post Job Free

Resume

Sign in

ETL QA

Location:
Colorado
Salary:
60/hr
Posted:
November 15, 2021

Contact this candidate

Resume:

ARLEEPTA M

Business Intelligence Test Automation Engineer Email: adpc6k@r.postjobfree.com Phone: 469-***-****

Proffesional Summary:

Around 9 years of experience in the IT industry as Software Test Engineer & Quality Analyst.

7 Years of IT experience in Business Intelligence, UI & Automation Testing, with 1 year of lead role.

Experienced in various aspects of Quality Assurance like Manual Testing, Quality Checks, Test Plan and Test Case preparation.

Highly Experienced in automation testing using Selenium, Protractor & TestNG & Cucumber.

Highly Experienced in Rest API testing using SOA Test, REST-assured & Postman.

Experienced in testing Angular applications using Protractor.

Created reusable automation frameworks using Appium for mobile automation.

Proven ability to independently drive projects & work collaboratively across teams.

Experienced on working with small to large sized projects from requirements gathering to product release, including well rounded testing skills with a firm understanding of Functional, System, User Acceptance and Regression Testing.

Experienced in creating detailed test scope, test plan and test cases/scripts utilizing functional and technical documentation.

Excellent working knowledge of System Development Life Cycle SDLC, Software Testing Life Cycle STLC and Defect Life Cycle.

Experienced in Functional testing, System testing, Application testing, Performance testing, Load testing, Integration testing, Regression testing, Black Box testing, Stress Testing, Smoke testing, Recovery testing, Reports testing, browser compatibility testing, UAT and GUI testing.

Expertise in writing Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases, Test scripts, RTMs, Defect status reports, Test Summary report.

Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like HP Quality Center and Rational Clear Quest.

Expert in writing complex SQL queries for back-end and Reports data validations.

Have solid experience on database query tools such as TOAD, SQL Navigator, SQL Assistant and SQL Plus and SQL Developer.

Have tested several complex Reports generated by IBM Cognos, Business Objects, including Dashboards, Summary reports, Master detailed, Drill down and Score cards.

Experience in testing the reports for both cosmetic static content and data validations as per Report specification documents.

Experience on UNIX commands for file validation.

Experience in Data Analysis, Data Cleansing Scrubbing, Data Validation and Verification, Data Conversion, Data Migrations and Data Mining.

Expert level skills in testing Enterprise Data Warehouses using Informatica Power Center DVO, DataStage, Ab Initio and SSIS ETL tools.

Have experience in testing reconcile initial and delta daily loads.

Experienced in using the Oracle SQL Loader features for loading the data from Flat Files to Data Base tables for Bulk Loading.

Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.

Knowledge on the phases of agile methodology and scrum Methodology.

Excellent interpersonal, communication, documentation and presentation skills.

Develop testing solution that focuses on automated testing and integrates with the CI environment. Work in conjunction with the Business Analysis and Development teams to ensure that applications meet requirements and are of high quality.

Experienced in working with epics, user stories, defects & test cases in JIRA in various Agile projects.

Ability to map test cases to business requirements and ensure software quality and usability requirements

Technical Skills

QA Methodologies : Iterative, Agile, Waterfall

QA Tools : Selenium Web Driver, TestNG, TFS Team, Foundation Server

BI/Reporting Tools : Business Objects, MicroStartegy, Crystal Reports, SSRS.

SAP tools : SAP Business Objects Business Intelligence XI 4.0, SAP Business Objects Business

Intelligence 3.1

Defect Management Tools : Microsoft Test Manager (MTM), HP ALM 9.1/10.0/11.

Test Management Tools : Microsoft Test Manager, HP ALM 9.1/10.0/11

Languages : C, C++, Java, HTML, SQL, Visual Basic.

Databases : Oracle, SQL Server 2005, MYSQL, MSSQL, Teradata

Web Technologies : HTML, DHTML, Java Script.

Operating System : WIN 98/NT/2000/XP/7/10.

Educational Qualification : Bachelor’s in Computer Science, Kalinga Institute of Industrial Technology, Odisha

Professional Experience:

Client : Frontier Airlines, Denver, CO Sep 2020 - Present

Role : ETL/QA/ BI Tester

Description : Frontier Airlines is committed to offering to more than 100 destinations and growing in the United States,

Canada, Dominican Republic and Mexico on more than daily flights. Headquartered in Denver, Frontier’s hard-working

aviation professionals pride themselves in delivering the company’s signature Low Fares Done Right service to

customers. Frontier Airlines is the proud recipient of the Federal Aviation Administration’s Diamond Award for

maintenance excellence and was recently named the industry’s most fuel-efficient airline by The International Council

on Clean Transportation as a result of superior technology and operational efficiencies.

Roles and Responsibilities:

Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.

Extensively worked on power center tools like Designer, workflow monitor and workflow manager to monitor and schedule sessions and workflows.

Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.

Used HP Quality Center 9.0 for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result

Performed SQL validation to verify the data extracts and record counts in the database tables by writing complex SQL minus queries.

Experience in manual testing which involves web-based application testing for provider and claims system.

Promoted Unix/Informatica application releases from development to QA and to UAT environments

Tested the ETL mappings from Source to Target.

Written test cases for checking the populated data correctly into fact and dimension tables.

Created Test Case documents in MS Excel template from the Test Plan and the Business Requirements documents.

Designed policies, standards and procedures for testing life cycle for the data warehouse and datamarts.

Prepared test cases by understanding the business requirements Data Mapping documents and technical specifications.

Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata

Responsible for different Data mapping activities from Source systems to Teradata

Extensively used Informatica power center for extraction, transformation and loading process.

Wrote and implemented manual automated test scripts for Risk Warehouse decision support system using HP Quality Center.

Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target

Coordinated with development team in system integration test and services level unit testing.

Exported Manual Test Cases from MS Excel template directly to HP Quality Center and executed all the Test Cases in Quality Center with Pass/Fail/Blocked status.

Extensively worked with backend activities for testing several reports developed by BI tools. Written several complex SQL queries.

Extensively used SQL Queries to verify and validate the Database Updates.

Actively participated in creating requirements Traceability matrices and Test plans

Prepared test requirements, test plan approach document and test cases.

Performed Unit and functional testing for all the Mappings and Sessions.

Tested Complex Reports in OBIEE functionalities like Slice and Dice Drill down Functions Cross Tabs Master/Detail and Formulae.

Environment

Informatica 9.1, HP Quality center 10.0, QTP 10.0, OBIEE10.1.3, Oracle 10g, Teradata V2R6, SQL server SSIS (2008),

SQL server SSRS (2008), PL/SQL, Toad, XML, XSD, PERL 5.12.1, XML Spy, Flat Files, Excel, Ms PowerPoint, Autosys,

UNIX, IBM AIX 6.1, Shell Scripting, Windows server

Client : Centene Corporation, Denver, CO Sep 2019 - Aug 2020

Role : BI Quality Engineer

Description : Centene Corporation is a multi-national company that provides high-quality healthcare services to

members in all 50 states and around the world. Since its founding in 1984, Centene has worked to transform the health

of communities, one person at a time. Centene is the largest Medicaid managed care organization in the country

and provides a portfolio of services to government sponsored healthcare programs. Our local health plans offer a range

of health insurance solutions with a focus on providing accessible care to uninsured and under-insured individuals.

Roles and Responsibilities:

Involved to create Business Risk Levels to determine Test Priorities.

Analyzed Test Plans and Test Cases based on Requirements and General Design Documents, involved in both Manual and Automation Testing.

Performed Regression testing using Test Director.

Extensively used SQL Queries to verify and validate the Database Updates.

Used Test Director a workflow automation tool for defect tracking and product automation.

Created User Defined Functions and procedures in Test Director Library to re-use them in different tests.

Performed data analysis and data profiling using SQL and Informatica on various sources systems including Oracle and Teradata.

Responsible for full testing life cycle, system testing and validating the Informatica mappings against the pre-defined ETL design standards.

Involved in developing test cases to test Teradata scripts (Bteq, multiload, fastload).Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly

Defining and performing the Test strategies and associated scripts for the verification and validation of the application and ensuring that it meets all defined business requirements and associated functionality.

Created high level test cases and test procedures for Unit Testing on reinsurance and documented them.

Used Test Director to create test plans, gathering requirements, analyzing the results and reporting.

Responsible for Reviews and documentation for reporting the status to the project manager.

Played a significant role of QA testing at various stages of the project including Data Quality Testing, Data load Testing, Data Integrity testing, Business Objects Reports Testing etc.

Tested Complex metrics, Nested Filters, Nested Prompts, Custom Drill Maps, Templates for Graphs and Templates for Drilled reports.

Environment :Informatica 8.1, Test Director 8.0, Win Runner 5.0, Business Objects 6.x, Rational Clear quest, SQL Server 2000,2005, Teradata V5R12, UNIX and XML, Quality Center 9.0, QTP 9.0

Client – Macy’s, Denver, CO Aug 2018 - Jul 2019

Role : QA Tester/Backend Tester/Automation Tester

Roles and Responsibilities:

Interacting with Business Analysts for Business Requirements, testing scope reviews, inspections and test planning.

Designed DVO informatica test cases for source and target Database validation.

Prepared Tractability matrix and prioritized test cases.

Involved in creating Test Plans, Test Scenarios, Test Scripts based on business Requirements, Use cases and Functional Specifications in Test plan tab of Quality Center tool

Create and maintain a Requirements Traceability Matrix

Performed extensive Data Integrity testing by executing SQL Statements on Oracle SQL database

Coordinated with the Developers regarding the Defects raised and Retested them against the application.

Developed and executed automated test scripts in Informatica DVO

Analyzed the data mapping and developed scenarios to verify the data migration from different data sources.

Wrote and executed complex SQL queries including JOINS to validate Back-end data.

Tested reports developed by Business Objects Universes for both Adhoc Canned Reporting users of Business Objects XI R3.1

Experience in Testing data conversions and transformations.

Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.

Prepared extensive set of validation test cases to verify the data

Performed Defect Management by prioritizing the issues and communicated the issues to the developer.

Planned, coordinate and execute Business Objects deployment for End-users and documented the entire project

Checking the integrity of UI data with the database using SQL queries, checking executing of stored procedures with the input values taken from the database.

Executed the Test cases, Test Scenarios in Test lab tab of Quality Center.

Worked with data reconciliation for the entire data migration project for both target system and rejected re-cords.

Created Test metrics and participated in status meetings and reported the progress to the manager.

Environment

Informatica DVO, Oracle 10g, SOAP, SOAPUI, Web Services, Business Objects, fToad,DB2, Mainframe, AS/400, MS Office,

SQL Query Analyzer, UNIX, Clear Quest, UNIX Scripting.

Client – Wipro / Cisco Sep 2008 - Oct 2015

Roles Played : Test Lead, Business Objects Developer, Business Objects Data Service Admin, Business Objects Admin

Role : Test Lead

Roles and Responsibilities:

Involved in test plan, test strategy preparation, test scenarios & test summary review.

Participated & conducted project planning, product demo/reviews, bug triage and walk-through meetings.

Experienced in working with epics, user stories, defects & test cases in JIRA

Develop UI Automation Test Suites using Selenium, Protractor, TestNG & Cucumber.

Worked on REST API test automation using SOATest, REST-assured & Postman.

Worked on integrating automation test suites with Git & Jenkins for CICD implementation.

Created reusable automation framework using Appium for mobile automation.

Provide daily updates on standup calls.

Manage user stories, defects & tests cases in JIRA.

Client – Wipro / Cisco

Role : Business Objects Developer / QA Lead

Roles and Responsibilities:

Involved in test plan, test strategy preparation, test scenarios & test summary review.

Participated & conducted project planning, product demo/reviews, bug triage and walk-through meetings.

Experienced in working with epics, user stories, defects & test cases in JIRA

Contributed actively in all Agile ceremonies

Closely worked with business teams on User Acceptance testing (UAT)

Good Understanding of SOAP and Restful Web Service/Web API testing

Have been a part of universe merging (Included joins, created contexts and aliases to resolve loop

Created reports and tested for universe merging.

Created BO reports based on new universe created after universe merging.

Analyzed queries in Teradata.

Prepared inventory and necessary documents for the project

Involved in testing various reports.

Prepared test cases for various applications, universes and reports.

Involved in Assessment, Planning, Migration, Validation

Finding the Gap/Impact analysis in the existing system

Testing & validating the migrated contents

Server setup, Administrating BO XI servers, Securities setup & content management plan.

Done quality assurance tests on the SIT environments for the connected systems in scope

To advise on test environments ‘setup

Reviewed the SIT test cases for GRP related to the connected systems to confirm that ownership of text execution is assigned correctly

Carrying out file loading in relevant systems, checking whether the files have loaded correctly and then feeding the results and test execution evidence back to GRP Project Team, along with any errors and record counts or other file statistics that were available as part of the load.

Monitoring the ETL Jobs and documenting their details on a daily basis.

Client – Wipro / Sony Music

Role : Business Objects Data Service Admin

Roles and Responsibilities:

Analyze business requirements and functional specifications, and develop test plan according to the functional specifications.

Monitoring the ETL jobs and documenting their details on a daily basis.

Contacting team members or other teams in case of issues in the jobs like incorrect file, database issues, server issues.

Worked on the change requests like adding new columns, its mappings in the ETL job.

Client – Wipro / Shell

Role : Business Objects Admin

Roles and Responsibilities:

Server monitoring, User management and security patch installation

Upgrade from BO XI 3.1 to XI 4.0.

Creating security model for XI 4.0 Migration strategies.

Migration of objects across environments.

Troubleshooting user issues creating reports based on audit tables to track the user activity

Scheduling of objects based on user requirement.

Performance Issues.

Coordinate with SAP team for the messages raised for bugs & Disaster recovery



Contact this candidate