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 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 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
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 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 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 on-prem & cloud (i.e. hybrid) architecture.
- Familiarity with cloud computing and the data ecosystem on Snowflake.