EDW QA Manager/Engineer- Remote

• Bachelor’s Degree or equivalent working experience • Minimum 5 years of experience in data warehouse management or operations. Proven QA experience in managing large-scale data warehouse projects • Minimum of 5 years' experience supporting a State Medicaid Agency • Must have domain experience in one or more of these areas in State Healthcare background. • MAR Reporting, SURS, Federal Reporting, Encounter Analytics • B) FADS, T-MSIS & Adhoc Reporting • Lead, mentor, and manage a team of data warehouse professionals, including data engineers and system analysts. • Experience in creation of detailed test cases to validate ETL processes, data pipelines, and the overall integrity of data and implementing test strategies. • Solid experience in ETL testing to ensure data is properly extracted, transformed, and loaded into the EDW as per business requirements. • Must have experience on ETL tools such as Informatica or SSIS. • Must have experience on reporting tools like Cognos, Tableau. • Solid experience in writing SQL statements for data validations. • Solid experience in Database, especially Oracle, and Batch Job testing. • Solid experience in using Toad and SQL Developer. • Experience in conducting performance and scalability testing for data pipelines and warehouse processes to ensure the EDW performs optimally under various loads. • Develop and maintain automated tests for data validation and ETL processes using appropriate tools and frameworks. • Ability to design, develop, test and debug tests cases/Scripts/plans/strategy documents. • Extensive experience in Test Management tools building Test Plans and Test Cases using tools like JIRA and Azure DevOps. • Strong and effective inter-personal and communication skills and the ability to interact professionally with a diverse group of clients and team members. Apply tot his job