ETL Test lead

Key Responsibilities:

• Extensive experience in ETL Testing and Data Warehouse Testing
• Expertise in SQL with the capability to formulate complex queries, joins, stored procedures, and data validation scripts
• Practical experience with ETL tools including Informatica, Talend, DataStage, SSIS, Ab Initio, or comparable technologies
• Solid understanding of Data Warehousing Concepts such as Fact Tables, Dimension Tables, Star Schema, and Snowflake Schema
• Experience in verifying source to target mappings
• Familiarity with data migration and data reconciliation methodologies
• Proficient with relational databases like Oracle, SQL Server, MySQL, PostgreSQL, or Teradata
• Strong grasp of SDLC, STLC, and Agile methodologies
• Experience using defect management tools such as JIRA
• Preferred Skills
• Experience with Cloud Data Platforms including AWS Redshift, Snowflake, Azure Synapse, or Google BigQuery
• Exposure to Big Data Testing utilizing Hadoop, Spark, or Databricks
• Knowledge of ETL automation tools and scripting with Python or Shell scripting
• Experience with data quality tools such as Informatica DQ or Great Expectations
• Familiarity with BI tools like Power BI, Tableau, or Qlik
• Understanding of CI/CD pipelines and DevOps practices

Technical Requirements:

• Core skills include Technology, Data Services Testing, Data Warehouse Testing, ETL, and Data Quality

Preferred Skills:

Technology->ETL & Data Quality->ETL - Others, Technology->Data Services Testing->Data Warehouse Testing