Who are we
Fulcrum Digital is an agile and nextgeneration 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 Skills: Testing (manual Automation) SSRS SSIS SQL
Role & Responsibility
- 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 onprem 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
Requirement:
- Bachelors or Masters in Computer Science or equivalent.
- 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 resultdriven test approach.
- Selfstarter; strong drive biastoaction commitment with solid work ethics
- Willingness to take on big challenges and own the results from brainstorming to .
- Excellent written and verbal communication skills Able to influence others effectively.
- Willingness to provide offhour support as needed or on a rotation basis.
Youre 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 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 onprem & cloud (i.e. hybrid) architecture.
- Familiarity with cloud computing and the data ecosystem on Snowflake.