Fulcrum Digital - QA Engineer

QA Engineer is needed in Pune City, India.

Client: Fulcrum Digital

Location: Pune City, MH, in

Contract: Freelance

Job Description

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.

Additional Information

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 the organization.
• Experience with SSIS & MSSQL is a plus.
• Experience with 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.