Job Title

Greetings from ITC Infotech! Role - Transformation Lead (ETL+QE) Location - Vancouver, BC Start Date: Immediate Job Description: Data Tester with expertise in ETL, data pipelines, data validation, Snowflake, Power BI, Airflow, and data modeling. The ideal candidate will ensure data accuracy, integrity, and performance across our data systems. Must: 10+ Years experience working in ETL/Data Testing Projects bringing lever of Quality maturity transformation by bringing value-adds, Shift-left testing, implementing KPIs/Metrics, bringing innovation through automation and managing a large testing team of offshore-onsite by bringing productivity and ensuring client satisfaction by providing reports and coordinating with Project and Product Team to close GAP in Testing activities. Key Responsibilities: Validate ETL processes and data pipelines to ensure data accuracy and integrity. Perform data quality checks on large datasets before and after transformations. Develop and execute test cases, test scripts, and SQL queries for data validation. Work with Snowflake to verify data ingestion, transformation, and storage. Test Power BI dashboards and reports for data consistency and performance. Validate and test data models to ensure they meet business requirements. Automate data testing using tools and scripting languages. Identify data anomalies, discrepancies, and inconsistencies in datasets. Collaborate with data engineers and analysts to resolve data issues. Ensure Airflow DAGs execute as expected and handle failures efficiently. Validate data mapping, schema changes, and database migrations. Perform regression testing to ensure new changes do not impact existing data. Monitor data lineage and ensure traceability of data transformations. Conduct performance testing on ETL processes to optimize efficiency. Develop and maintain data validation frameworks and best practices. Verify dimensional and relational data models for accuracy and completeness. Ensure compliance with data governance, security, and regulatory requirements. Troubleshoot data pipeline failures and work on root cause analysis. Participate in agile development cycles, including sprint planning and reviews. Continuously improve testing methodologies and automation for data pipelines. Education Qualification: Bachelors degree in computer science, Information Technology, or a related field (or equivalent experience). About US: ITC Infotech is a leading global technology services and solutions provider, led by Business and Technology Consulting. ITC Infotech provides business-friendly solutions to help clients succeed and be future-ready, by seamlessly bringing together digital expertise, strong industry specific alliances and the unique ability to leverage deep domain expertise from ITC Group businesses. We provide technology solutions and services to enterprises across industries such as Banking & Financial Services, Healthcare, Manufacturing, Consumer Goods, Travel and Hospitality, through a combination of traditional and newer business models, as a long-term sustainable partner.