PhoenixRecruiter Since 2001
the smart solution for Phoenix jobs

Healthcare - Business / ETL Test Analyst

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

Job Description:

#INDISTNTT 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 processWork with client stakeholders to capture business requirements for building data warehouse, data marts, reports and dashboardsApply Healthcare knowledge to correctly understand the data, KPIs and metrics for reportingCreate data marts and reporting tables in SQL Server based on business requirementsUsing SSIS and Stored Procedures, Develop ETL processes/jobs to load data marts/reporting tablesImplement database modelling best practicesDesign, plan and execute product testing including functional testing, system integration testing, regression testing and performance testing ? for an analytics product including data visualizations and ETLTest SSIS packagesEstimate, plan and execute testing activities for analytics contentDesign, write and execute effective manual and automated test cases and create test data as neededDiscover, reproduce, prioritize, retest and clearly document system defectsDevelop, update and maintain relevant test metric reportingPerform test coverage analysis and requirements tracing. Actively participate with the team in software requirements, design and code reviews to provide early and continuous feedbackWork 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 teamUnderstand data flow and test strategy for ETL and visualization testingWrite advanced SQL queries for ETL/data warehousing/visualization testingPossess ability to research issues and improve processesDevelop and deliver the artifacts in Agile methodologyBasic 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 servicesMinimum 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 accurateBachelor/Master of Computer Application or equivalent engineering/IT degree from an accredited UniversityPreferred Skills:Strong domain knowledge of Healthcare specially Payer domainStrong knowledge of SQL, SQL Server, SSIS, Stored ProceduresExperience in ETL and data warehousing testing and BI reporting tool testingStrong exposure to Software Testing tools like ALM (Quality Center), JIRAIn-depth experience and demonstrated proficiency with QA methodology, process and deliverablesExpertise required in source to target data testing, data completeness testing, ETL job setup and validationsKnowledge of test planning activities & tools, test environment setup methods, test scripting methods and toolsKnowledge of data modelling, data warehousing and visualization conceptsKnowledge in tools like Visual Studio, VSTS (Visual Studio Team Services), TFS (Team Foundation Server)/Azure DevOpsFamiliarity with Agile methodology for projectExperience of working with teams across other geographies in onshore/offshore modelGood understanding of Membership, Claims, Pharmacy ordersAbility to adapt quickly to an existing, complex environment and learn new concepts / software technologies as needs ariseAdaptable and flexible meet demands, being relentless and passionate to get the job doneStrong work prioritization, planning and organizational skillsThe 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, Professions , Phoenix, Arizona

Click here to apply!

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

I'm looking for
in category
within


Other Professions Jobs


Amazon Warehouse Assistant
Description: Seasonal Warehouse Team Members br br Shifts: br Overnight, Early Morning, Day, Evening, Weekend br br Location: br Phoenix, AZ br Job opportunities vary by location. We update postings (more...)
Company: Amazon
Location: Sun City West
Posted on: 09/28/2020

Transportation Supervisor (Flexible Part-Time) - Night Shifts Available
Description: This position offers an exciting opportunity to make history and become a member of a team whose purpose is to solve complex challenges and create unprecedented customer experiences. We're looking for (more...)
Company: Amazon
Location: Sun City West
Posted on: 09/28/2020

Warehouse Coordinator (Flexible Part-Time) - Earn $15/hr or more
Description: This position offers an exciting opportunity to make history and become a member of a team whose purpose is to solve complex challenges and create unprecedented customer experiences. We're looking for (more...)
Company: Amazon
Location: Sun City West
Posted on: 09/28/2020


Amazon Warehousing Worker
Description: Seasonal Warehouse Team Members br br Shifts: br Overnight, Early Morning, Day, Evening, Weekend br br Location: br Phoenix, AZ br Job opportunities vary by location. We update postings (more...)
Company: Amazon
Location: Sun City West
Posted on: 09/28/2020

Warehouse Operator (Seasonal)
Description: Seasonal Warehouse Team Members br br Shifts: br Overnight, Early Morning, Day, Evening, Weekend br br Location: br Phoenix, AZ br Job opportunities vary by location. We update postings (more...)
Company: Amazon
Location: Sun City West
Posted on: 09/28/2020

Amazon Warehouse Attendant
Description: Seasonal Warehouse Team Members br br Shifts: br Overnight, Early Morning, Day, Evening, Weekend br br Location: br Phoenix, AZ br Job opportunities vary by location. We update postings (more...)
Company: Amazon
Location: Sun City West
Posted on: 09/28/2020

Amazon Warehouse Assistant (Seasonal)
Description: Seasonal Warehouse Team Members br br Shifts: br Overnight, Early Morning, Day, Evening, Weekend br br Location: br Phoenix, AZ br Job opportunities vary by location. We update postings (more...)
Company: Amazon
Location: Sun City West
Posted on: 09/28/2020

Warehouse Team Member (Immediate Openings)
Description: Seasonal Warehouse Team Members br br Shifts: br Overnight, Early Morning, Day, Evening, Weekend br br Location: br Phoenix, AZ br Job opportunities vary by location. We update postings (more...)
Company: Amazon
Location: Sun City West
Posted on: 09/28/2020

Warehouse Lead (Flexible Part-Time) - Night Shifts Available
Description: This position offers an exciting opportunity to make history and become a member of a team whose purpose is to solve complex challenges and create unprecedented customer experiences. We're looking for (more...)
Company: Amazon
Location: Sun City West
Posted on: 09/28/2020

Warehouse Coordinator (Flexible Part-Time) - Night Shifts Available
Description: This position offers an exciting opportunity to make history and become a member of a team whose purpose is to solve complex challenges and create unprecedented customer experiences. We're looking for (more...)
Company: Amazon
Location: Sun City West
Posted on: 09/28/2020

Log In or Create An Account

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

Phoenix RSS job feeds