QA Engineer

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