You haven't searched anything yet.
Location: Remote
Duration: Long term
Key Objectives:
Hands-on experience with:
EDW source to target testing (SQL scripting - manual and automation).
Data transformation/manipulation testing (SQL scripting - manual and automation).
Data quality/completeness validation (SQL scripting - manual and automation).
Experience in running the processes through the scheduler.
Quality Assurance, Process Improvement and Collaboration:
Develop and execute (Develop) comprehensive test plans to validate data within on-prem and cloud data warehouses.
Conduct thorough testing of ETL processes, dimensional data models, and reporting outputs.
Identify, document, and track data quality issues, working closely with data engineers to resolve them.
Validate data loading, transformation, and aggregation processes.
Ensure data consistency and integrity across different data sources and systems.
Collaborate with the Data Quality and Data Engineering team to define quality benchmarks and metrics.
Continuously improve QA testing strategies and methodologies.
Implement best practices for data validation and error handling.
Assist in the design and implementation of data quality assurance tools and frameworks.
Work closely with BA, data architect, data engineers, QA and stakeholders to understand data requirements and deliverables.
Work closely with the Lead Data QA Engineer to design, develop, maintain and support testing infrastructure.
Provide detailed reports on data quality findings and testing outcomes.
Extensively used Task management and defect management tool (i.e. Jira and Confluence) to manage deliverable.
Well versed with the comprehensive QA testing methodology (i.e. functional, non-functional, system, regression, smoke test, performance testing, black box testing, etc.).
Contribute insights and recommendations to enhance data quality and processing efficiency.
Requirements
Bachelors or Masters in Computer Science or equivalent.
Experience with Insurance (industry domain) Data Warehouse, data and it's processes
Strong understanding of Data Warehouse & Data Quality fundamentals.
3 to 5 years of experience in data warehouse development/testing.
3 to 5 years of experience with SQL Server and SSIS/SSAS/SSRS testing.
Must be experienced in Data Warehousing Projects with good knowledge of ETL testing.
Strong in SQL, RDBMS, ETL, and DW concepts.
Experience in validating Reports/Dashboards on tools like Tableau, MS Power BI, etc.
Great attention to detail with a result-driven test approach.
Self-starter; strong drive, bias-to-action, commitment with solid work ethics.
Willingness to take on big challenges and own the results from brainstorming to execution.
Excellent written and verbal communication skills - Able to influence others effectively.
Willingness to provide occasional off-hour support.
You're a Great Fit If You Have:
Minimum 3 to 5 years of Quality Assurance experience (manual/automated testing) with a proven track record of improving Data Quality by
implementing QA best practices within organization.
SSIS & MSSQL experience (intermediate or senior level).
Experience with Insurance Data Warehouse, data and it's processes
Experience with the Snowflake and DBT is a plus.
Experience in using QA automation tools.
ETL process knowledge; Knowledge of data warehouse testing procedures.
Desirable qualifications/pluses:
Knowledge of Insurance Data & its processes.
Data validation experience between on-prem & cloud (i.e. hybrid) architecture.
Familiarity with cloud computing and the data ecosystem on Snowflake.
Why work with us:
Relationship ensures quickest traction and decision
We have been serving the industry for over 2 decades!
Full Time
Software & Cloud Computing
$133k-164k (estimate)
04/28/2024
05/16/2024
The job skills required for ETL Tester include SQL, Data Engineering, Data Warehouse, Computer Science, Insight, Data Quality, etc. Having related job skills and expertise will give you an advantage when applying to be an ETL Tester. That makes you unique and can impact how much salary you can get paid. Below are job openings related to skills required by ETL Tester. Select any job title you are interested in and start to search job requirements.
The following is the career advancement route for ETL Tester positions, which can be used as a reference in future career path planning. As an ETL Tester, it can be promoted into senior positions as a Database Engineer IV that are expected to handle more key tasks, people in this role will get a higher salary paid than an ordinary ETL Tester. You can explore the career advancement for an ETL Tester below and select your interested title to get hiring information.