Junior Quality Assurance Engineer

Who are we

Fulcrum Digital is an agile and next-generation digital accelerating company providing digital transformation and technology services right from ideation to implementation. These services have applicability across a variety of industries, including banking & financial services, insurance, retail, higher education, food, healthcare, and manufacturing.

 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

Requirements

• Bachelors or master’s in computer science or equivalent.
  
• Strong understanding of Data Warehouse & Data Quality fundamentals.
  
• 2 to 3 years of experience in data warehouse development/testing.
  
• 2 to 3 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 off-hour support as needed or on a rotation basis.
  

You’re a Great Fit If You Have:

• Minimum 2 to 3 years of Quality Assurance experience (manual/automated testing) with a proven track record ofimproving Data Quality by implementing QA best practices within organization
  
• SSIS & MSSQL experience (intermediate or senior level)
  
• 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.