Data Analysis Data Warehouse ETL Process Analytical Skills SQL Query Development Q   Requirement id 119407 Job title Tester Job location in Bismark, ND Skills required Large Scale Environments, Complex Projects, System Interfacing, Data Analysis Data Warehouse ETL Process Open Date 27-Sep-2021 Close Date Job type Contract Duration 7 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Tester: Large Scale Environments, Complex Projects, System Interfacing, Data Analysis Data Warehouse ETL Process start date:10/11/2021 End date:05/13/2022 submission deadline:10/4/2021 client info : DHS Description: we are seeking a Data Quality Analyst to support the testing and implementation of enhancements to Self-Service Portal and Combined Eligibility System (SPACES). The analyst will support the functional areas, product and technology partners in testing and implement system modifications and new technology solutions that meet business needs as well as to prepare for new client implementations. This position examines complex data to optimize the efficiency and quality of the data being collected, resolve data quality problems within the data structure, data interfaces, reporting and collaborates with database developers to improve systems and database integrity. The primary responsibility includes developing and executing test cases and working collaboratively with business functional leads to ensure that the quality and accuracy of the data meets the requirements of the business programs, downstream customers, conforms to all applicable Federal and state laws. Job Responsibilities: • Participate in joint application design session with development team and policy stakeholders for program enhancements or defects • Collaborate with policy and business analyst leads on necessary approach for adequate testing coverage • Participate in project meetings such as defect triage and test case and/or requirements documentation reviews involving cross-functional teams, key business stakeholders and development managers. • Work with small teams of business analysts, implementation and operational managers, external vendors and consultants to support implementation activities. • Develop and execute test cases, document results and coordinate user acceptance test activities with subject matter experts. • Actively manage defects from inception through resolution, working with business SMEs, application designers, developers and testers to effectively prioritize and drive to resolution. • Create and execute test cases for an ETL process (for an ETL process that loads data from files to SQL database and vice versa). • Verification of data requirements including, source to target mapping, report outputs, interfaces, batch jobs, flat files, etc. • Writing SQLs to check record counts, data truncation, invalid datatypes, NULLs and data integrity • Assist in the development and maintenance of data standards, definitions, and models documentation (e.g. data dictionary, organizational data model. • Participate in larger teams as a team member, and/or work independently • Identify areas for process improvement to improve quality and optimize cost. Experience/Preferred Skills Required: • 8+ years of experience working on large scale, complex projects. • 5+ years of economic assistance program industry in a role centered around test case creation, technical acumen and experience with multiple systems interfaces expertise. • 3-5 years of experience with data analysis and validation including (data warehouse, ETL processes, large volume reports, • Exceptional analytical skills • Intermediate to advanced SQL query skills • Proven ability to validate test data preparation and verify all teams are aligned with what needs to occur to build/prepare the business functional tests, regression, and end to end testing. • Demonstrated strong cross-functional communication, problem-solving and collaboration skills. • Ability to summarize status, develop execution metrics and escalate issues as necessary to Management. • Knowledge of TQM / QA practices • Outstanding communication, interpersonal and rela   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 119407 while calling.   Other jobs in ND:    Large Scale Environments job openings in other states Jobs List NC-Meck County-ITS -Deployment And Desktop Support (737641) Create date: 07-Jun-2024 Onsite Max Submittals by Vendor: 1 Start date :07/01/2024 End Date : 09/27/2024 Submission deadline : 06/13/2024 Client Info : Mecklenburg County - Information Technology Services - Technical Services Description : ------------------------------------------------------ .... (This job is for - job Jobs in NC Charlotte Developer - (in Charlotte, NC)) PennDOT - Emerging PJM4 (659477) Create date: 10-Aug-2021 Start Date :08/30/2021 End Date :12/31/2021 Submission Deadline :08/15/2021 Client Info : PennDOT Description : ***This requisition will feature first round interviews via Teams or Skype. Final round may be in-person.*** ***Client would prefer candidates local to the Harris.... (This job is for - job Jobs in PA DauphinCounty Consultant - (in Dauphin County, PA)) Senior Build And Release Engineer - 21-00098 Create date: 01-Mar-2021 Description: Responsibilities Job Title: Senior Build and Release Engineer Location: Fremont, CA Duration: 6+ months contract with extension Summary: Headquartered in the San Francisco Bay Area, our client is leading the charge in sustainable transportation and green energy productio.... (This job is for - Kubernetes Jobs in CA Fremont Engineer - (in Fremont, CA)) SYSTEMS SOFTWARE PROGRAMMER-PROJECT LEAD - 9674-1 Create date: 11-Jan-2021 Start Date :02/02/2021 Submission Deadline :01/18/2021 Client Info : Department of Social Services Note : * INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)? Interview will be by phone and will be conducted by a team of 3 – 5 developers and or Pro.... (This job is for - Database Admin Jobs in SC COLUMBIA TechLead - (in Columbia, SC)) Software Architect - 4465 Create date: 28-Dec-2020 On-site/Remote: On-site Description: Responsibilities Are you energetic and enthusiastic, as well as uniquely talented? We have a 24-month project with our client in Schenectady, NY that requires a Software Architect, Expert Day-to-Day Tasks include, but not limited to: MUMPS / Cac.... (This job is for - job Jobs in NY Schenectady Architect - (in SCHENECTADY, NY))     (Tester: Large Scale Environments, Complex Projects, System Interfacing, Data Analysis Data Warehouse ETL Process in Bismark, ND)

Featured Jobs Developer (Jobs in Atlanta, Georgia) Data Architect ETL Specialist (Jobs in Raleigh, North Carolina) SQL Architect (Jobs in Richmond, Virginia) Business Analyst Financial Analyst (Jobs in Fredericksburg, Virginia) Cyber Architect (Jobs in Columbia, South Carolina) VxRails Consultant (Jobs in Boise, Idaho) Project Manager Microsoft Manager (Jobs in Raleigh, North Carolina) Agile Jira UAT Manager (Jobs in Atlanta, Georgia) - - Analyst (Jobs in Portland, Oregon) HTMLCSSJavaScript Developer (Jobs in Lincoln, Nebraska)