EDW QA Manager/Engineer- Remote - The Dignify Solutions, LLC
New York, NY 10001
About the Job
- 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.
Source : The Dignify Solutions, LLC