Tech Valley Talent (TVT) we have an opening for a Data Validation Analyst.
DURATION: 2 years LOCATION: Onsite-West Sacramento, CA
The Data Validation Analyst shall ensure that data validation/quality strategy, processes, standards, and relevant technology trends are incorporated into a data conversion validation effort.
Qualifications
A four-year college degree (Bachelor) in Computer Science, Computer Engineering, or related fields from a government accredited/sanctioned college or university.
At least eight (8) years of experience comprehending and developing complex SQL queries; developing detailed SQL reporting specifications, analyzing, validating, and / or reconciling data from heterogeneous data sources such as mainframe, MS SQL Server, MS Access databases, csv files, text files.
At least eight (8) years of experience designing, developing, debugging and supporting complex data validation processes (including stored procedures, tables, user defined functions, views, indexes, relational database models) using various tools and technologies including SSRS, T-SQL and SQL Server technology. This experience must include full-time experience in developing reports and writing code from data model, dataflow diagram and technical design specifications.
At least six (6) years of experience performing data migration efforts including analysis, cleansing, conversion, verification and validation to ensure data quality and consistency.
At least five (5) years of experience analyzing functional and nonfunctional data conversion requirements, data conversion mapping code and transformation rules for translating them into technical requirements for data quality assurance purposes including but not limited to the performing validation using reconciliation methods of checking record counts between source and target systems.
At least five (5) years of experience in developing SQL Reports as part of the data validation strategy for a Pension Administration System desired.
At least five (5) years of experience with Microsoft.Net framework using languages such as C# and VB.Net to write utilities for validating data as well as source code management software such as TFS (Microsoft Team Foundation Server) desired.
At least five (5) years of experience in validating data being converted from legacy mainframe applications to SQL Server desired.
At least five (5) years of experience in producing the following documents: data verification & validation requirements, data validation strategy, data validation test cases and data validation reports desired.
At least two (2) years of experience handling Database Administrator (DBA) tasks using MS SQL Server desired.
Day-to-Day Tasks
Comprehend the data between legacy mainframe and target system to provide evidence that various record counts balance between source and target systems as well as ensuring that requirements identified by the business areas are properly translated by conversion code facilitating migration of data between the two systems.
Run joint application development sessions to facilitate requirements gathering from business users spanning multiple divisions.
Perform parallel data conversion in accordance with the conversion rules target system.
Perform tasks that will ensure the timely creation of reports to meet various business needs, as well as assist in defining processes, standards and best practices in reports development.
Responsible for helping establish an enterprise reporting framework that aligns with other areas of the overall enterprise architecture.
Work closely with Database Administrators and the Conversion Team to load and refresh data in the data harvesting tool used by staff to identify data for testing of the new system.
TVT is an Information Technology (IT) professional business leader providing IT services to the public sector. Our firm is founded on the values of high integrity, trust, honesty, and commitment. We take pride in providing exceptional value to our clients by supplying and delivering the best IT project-based and hourly talent across the nation. We are business partners with many technology solution providers such as IBM, AWS, Google, Microsoft, Oracle, Tableau, Salesforce, and others. Tech Valley Talent provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type protected by federal, state, or local laws. This policy applies to all terms and conditions of employment.
You could be the one who changes everything for our 28 million members. Centene is transforming the health of our communities, one person at a time. As a diversified, national organization, you’ll have access to competitive benefits including a fresh perspective on workplace flexibility.
