IN
Job Description
Key Responsibilities:
- Demonstrated expertise in ETL Testing and Data Warehouse Testing
- Advanced proficiency in SQL, capable of crafting complex queries, executing joins, developing stored procedures, and creating data validation scripts
- Practical experience with ETL tools such as Informatica, Talend, DataStage, SSIS, Ab Initio, or equivalent
- Thorough understanding of Data Warehousing principles, including 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 in working with relational databases such as Oracle, SQL Server, MySQL, PostgreSQL, or Teradata
- Solid grasp of SDLC, STLC, and Agile development methodologies
- Experience utilizing defect management tools such as JIRA
- Preferred Skills
- Experience with Cloud Data Platforms like 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 capabilities using Python or Shell scripting
- Experience with data quality tools such as Informatica DQ or Great Expectations
- Familiarity with Business Intelligence tools like Power BI, Tableau, or Qlik
- Understanding of CI/CD pipelines and DevOps methodologies
Technical Requirements:
- Core skills include Technology Data Services Testing, Data Warehouse Testing, ETL, and Data Quality