PhoenixRecruiter Since 2001
the smart solution for Phoenix jobs

Healthcare - Business / ETL Test Analyst

Company: NTT DATA Corporation
Location: Phoenix
Posted on: September 16, 2020

Job Description:

#INDIST

NTT DATA's Client is currently seeking a Business / ETL Test Analyst with 5 years of experience with Integration Services (SSIS), Extracting, Transforming and Loading (ETL) data from excel, pipe delimited, csv files to MS SQL Server by using SSIS services to join their team.

NTT DATA Services is committed to improving patient outcomes by creating efficiencies across the healthcare ecosystem. A recognized leader in the healthcare space, the company delivers targeted segment solutions including patient engagement, predictive analytics, healthcare cloud hosting, integration and interoperability, clinical and claims application implementation, revenue cycle management and policy administration, in addition to core managed infrastructure, application and business process services. Clients include more than 1,800 hospitals, 2,200 long-term care facilities, 225 acute care facilities, 43,000 clinicians, 1,000 physician practices and 50 insurance providers in support of 65 million policy holders.

Job Responsibilities Include:

Understand the existing data warehouse/databases, inbound data files and data ingestion process

Work with client stakeholders to capture business requirements for building data warehouse, data marts, reports and dashboards

Apply Healthcare knowledge to correctly understand the data, KPIs and metrics for reporting

Create data marts and reporting tables in SQL Server based on business requirements

Using SSIS and Stored Procedures, Develop ETL processes/jobs to load data marts/reporting tables

Implement database modelling best practices

Design, plan and execute product testing including functional testing, system integration testing, regression testing and performance testing ? for an analytics product including data visualizations and ETL

Test SSIS packages

Estimate, plan and execute testing activities for analytics content

Design, write and execute effective manual and automated test cases and create test data as needed

Discover, reproduce, prioritize, retest and clearly document system defects

Develop, update and maintain relevant test metric reporting

Perform test coverage analysis and requirements tracing. Actively participate with the team in software requirements, design and code reviews to provide early and continuous feedback

Work with team to continually improve test processes and practices based on inspection, adaption of previous iterations and to ensure adherence to process, tools and metrics standards within the project team

Understand data flow and test strategy for ETL and visualization testing

Write advanced SQL queries for ETL/data warehousing/visualization testing

Possess ability to research issues and improve processes

Develop and deliver the artifacts in Agile methodology

Basic Qualifications:

Minimum of 5 years of experience with Integration Services (SSIS), Extracting, Transforming and Loading (ETL) data from excel, pipe delimited, csv files to MS SQL Server by using SSIS services

Minimum of 3 years of experience in Data warehouse (DW) testing, understanding DW testing requirements and develop test cases to assure that the data that has been loaded from a source to destination after business transformation is accurate

Bachelor/Master of Computer Application or equivalent engineering/IT degree from an accredited University

Preferred Skills:

Strong domain knowledge of Healthcare specially Payer domain

Strong knowledge of SQL, SQL Server, SSIS, Stored Procedures

Experience in ETL and data warehousing testing and BI reporting tool testing

Strong exposure to Software Testing tools like ALM (Quality Center), JIRA

In-depth experience and demonstrated proficiency with QA methodology, process and deliverables

Expertise required in source to target data testing, data completeness testing, ETL job setup and validations

Knowledge of test planning activities & tools, test environment setup methods, test scripting methods and tools

Knowledge of data modelling, data warehousing and visualization concepts

Knowledge in tools like Visual Studio, VSTS (Visual Studio Team Services), TFS (Team Foundation Server)/Azure DevOps

Familiarity with Agile methodology for project

Experience of working with teams across other geographies in onshore/offshore model

Good understanding of Membership, Claims, Pharmacy orders

Ability to adapt quickly to an existing, complex environment and learn new concepts / software technologies as needs arise

Adaptable and flexible meet demands, being relentless and passionate to get the job done

Strong work prioritization, planning and organizational skills

The Company is an equal opportunity employer and makes employment decisions on the basis of merit and business needs. The Company will consider all qualified applicants for employment without regard to race, color, religious creed, citizenship, national origin, ancestry, age, sex, sexual orientation, genetic information, physical or mental disability, veteran or marital status, or any other class protected by law. To comply with applicable laws ensuring equal employment opportunities to qualified individuals with a disability, the Company will make reasonable accommodations for the known physical or mental limitations of an otherwise qualified individual with a disability who is an applicant or an employee unless undue hardship to the Company would result.

Keywords: NTT DATA Corporation, Phoenix , Healthcare - Business / ETL Test Analyst, Other , Phoenix, Arizona

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Other Jobs


RN-ICU/CVICU
Description: Job Summary The RN supports the vision of the Total Healing Environment and the values of respect, integrity, accountability, commitment and quality while providing nursing care to patients in accordance (more...)
Company: Yavapai Regional Medical Center
Location: Prescott Valley
Posted on: 09/23/2020

RN-Float Pool, Seasonal, Nights
Description: Job Summary The Seasonal RN supports the vision of the Total Healing Environment and the values of respect, integrity, accountability, commitment and quality while providing nursing care to patients (more...)
Company: Yavapai Regional Medical Center
Location: Prescott
Posted on: 09/23/2020

CDL-a Household Goods Mover Lease Purchase Truck Driver Jobs
Description: Drive How You Want. Drive Where You Want. Whether it's regional or OTR Owner Operator truck driver job opportunities that you're on the hunt for, United has a number of immediate positions open (more...)
Company: United Van Lines
Location: Maricopa
Posted on: 09/23/2020


Remote Work-From-Home Independent Contractor - Call Center Representative
Description: We got what you want, you got what we need Goodbye long commutes, rigid schedules, and busybody managers. Hello, Liveops. Our well-known clients are seeking Independent Contractors to provide virtual (more...)
Company: Liveops
Location: Sun City West
Posted on: 09/23/2020

High Demand For Quality Handymen - Get New Clients In Your Area
Description: Over 25 million homeowners have trusted HomeAdvisor 1800Contractor to help them find quality professionals with the expertise to turn their home improvement
Company: HomeAdvisor
Location: Prescott
Posted on: 09/23/2020

RN-ICU/CVICU, Nights
Description: Job Summary The RN supports the vision of the Total Healing Environment and the values of respect, integrity, accountability, commitment and quality while providing nursing care to patients in accordance (more...)
Company: Yavapai Regional Medical Center
Location: Prescott
Posted on: 09/23/2020

Diesel Mechanic - Phoenix
Description: Job DescriptionAt Hogan, We Mechanic Better Whether you have years of experience
Company: Hogan Transportation
Location: Sun City West
Posted on: 09/23/2020

RN-Med/Surg/Tele, Nights
Description: Job Summary The RN supports the vision of the Total Healing Environment and the values of respect, integrity, accountability, commitment and quality while providing nursing care to patients in accordance (more...)
Company: Yavapai Regional Medical Center
Location: Prescott Valley
Posted on: 09/23/2020

Remote Work-From-Home Independent Contractor - Call Center Representative
Description: We got what you want, you got what we need Goodbye long commutes, rigid schedules, and busybody managers. Hello, Liveops. Our well-known clients are seeking Independent Contractors to provide virtual (more...)
Company: Liveops
Location: Sun City
Posted on: 09/23/2020

RN-Med/Surg/Tele
Description: Job Summary The RN supports the vision of the Total Healing Environment and the values of respect, integrity, accountability, commitment and quality while providing nursing care to patients in accordance (more...)
Company: Yavapai Regional Medical Center
Location: Prescott Valley
Posted on: 09/23/2020

Log In or Create An Account

Get the latest Arizona jobs by following @recnetAZ on Twitter!

Phoenix RSS job feeds