Senior Test Analyst

Senior Test AnalystWest Sacramento, CA24+ monthsMandatory Qualifications: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.Desired Qualifications:Experience working as a Test Analyst leading or participating in the technical implementation of pension/retirement-related software development projects.A Bachelor’s Degree in computer science, Computer Engineering, Management Information Systems or related fields from an accredited or government-sanctioned college/university.Experience working on the Microsoft SQL Server Platform as a developer writing SQL queries to fetch data and analyze results.