Job Details:
Job Title - QA Engineer
Job Location - Remote position (India)
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)
· Working knowledge and testing experience of ETL
· Experience in running the processes through the scheduler
Quality Assurance, Process Improvement and Collaboration:
· Develop and execute 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.
· Contribute insights and recommendations to enhance data quality and processing efficiency.
Requirements
· Bachelors or Masters in Computer Science or equivalent.
· Strong understanding of Data Warehouse & Data Quality fundamentals.
· 2 to 5 years of experience in data warehouse development/testing.
· 2 to 5 years of experience with Relational Database and ETL 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 off-hour support as needed or on a rotation basis.
Youʼre a Great Fit If You Have:
· Minimum 2 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
· Experience with the SSIS & MSSQL is a plus
· Experience with the Snowflake and DBT is a plus
· Experience in using QA automation tools is a plus
· 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
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
