Job Description
ETL & Reporting QA Analyst Required Skills
1. Experience writing test plans, test cases, and executing tests, including tracing results back to requirements
2. Strong SQL skills, including complex queries, source to target validation, and reconciliation
3. Hands on ETL testing experience: full, incremental, integration, and regression loads; validating mappings, transformations, record counts, duplicates, and nulls
4. Experience testing reports and dashboards, including KPIs, calculations, filters, prompts, drill down and drill through functionality
5. Solid knowledge of data warehouse concepts, including fact and dimension tables, star and snowflake schemas, and Slowly Changing Dimensions (SCD Type 1 and Type 2)
6. Familiar with test management and defect tracking tools such as Azure DevOps (ADO) or Jira
Preferred Skills
1. Experience with batch job testing, file interfaces, error handling, and job recovery
2. Some exposure to performance, security, and access control testing
3. Experience with test environment setup and production verification after releases
4. Familiar with Agile QA practices and defect triage "
Responsibilities
1. Review business and technical requirements and develop test strategies, plans, scenarios, cases, and test data
2. Validate ETL workflows, source to target mappings, transformation rules, and full and incremental data loads
3. Execute SQL based reconciliation across source systems, staging areas, data warehouses, data marts, and reports
4. Test data warehouse structures, including fact and dimension loads, SCD processing, history, and referential integrity
5. Validate reports, dashboards, KPIs, filters, calculations, exports, drill down, and drill through functionality
6. Perform functional, integration, system, regression, smoke, negative, and end to end testing
7. Document, prioritize, track, retest, and close defects with clear evidence and reproducible steps
8. Collaborate with business analysts, data engineers, BI developers, and product owners to support releases and improve quality
1. Experience writing test plans, test cases, and executing tests, including tracing results back to requirements
2. Strong SQL skills, including complex queries, source to target validation, and reconciliation
3. Hands on ETL testing experience: full, incremental, integration, and regression loads; validating mappings, transformations, record counts, duplicates, and nulls
4. Experience testing reports and dashboards, including KPIs, calculations, filters, prompts, drill down and drill through functionality
5. Solid knowledge of data warehouse concepts, including fact and dimension tables, star and snowflake schemas, and Slowly Changing Dimensions (SCD Type 1 and Type 2)
6. Familiar with test management and defect tracking tools such as Azure DevOps (ADO) or Jira
Preferred Skills
1. Experience with batch job testing, file interfaces, error handling, and job recovery
2. Some exposure to performance, security, and access control testing
3. Experience with test environment setup and production verification after releases
4. Familiar with Agile QA practices and defect triage "
Responsibilities
1. Review business and technical requirements and develop test strategies, plans, scenarios, cases, and test data
2. Validate ETL workflows, source to target mappings, transformation rules, and full and incremental data loads
3. Execute SQL based reconciliation across source systems, staging areas, data warehouses, data marts, and reports
4. Test data warehouse structures, including fact and dimension loads, SCD processing, history, and referential integrity
5. Validate reports, dashboards, KPIs, filters, calculations, exports, drill down, and drill through functionality
6. Perform functional, integration, system, regression, smoke, negative, and end to end testing
7. Document, prioritize, track, retest, and close defects with clear evidence and reproducible steps
8. Collaborate with business analysts, data engineers, BI developers, and product owners to support releases and improve quality
Numbers & Facts
| Location | Harrisburg, PA |
| Industry | Other/Not Classified |
| Salary | $40–$50 |
| Company Size | 1 to 9 employees |
| Year Founded | 2016 |
| Website | http://www.prorecrs.com |
About Company
ProRec RS was founded in 2016 for one purpose... Help companies find the best talent with a reasonable fee solution to cut down on over spending for recruiters. We will work with all companies in multiple solutions to fit their budget.
Our team of recruiters have over 20 years of recruiting experience. They are all trained to work under the same recruiting process, follow the same steps and we all work together to review resumes and find the best talent for our clients.
We are also working with the Military to help Veterans find jobs. There are thousands of Veterans who cannot get a job and we are educating them on how to build their skills and get into a job that fits their background.
Skills
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesFree resume builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder