ETL Testing

Total Years of Experience : 4 to 10 years
Relevant years of Experience: 4 +
Mandatory Skills for screening: Azure Data Factory, Azure Synapse, Azure Databricks, and Azure SQL DB, SQL, Spark SQL. Scala, Python Good to have (Not Mandatory): Agile methodologies and DevOps would be added advantage

Detailed Job Description :

ETL Testing, Azure Data Platform
1. Working experience in ETL testing including Data Completeness and Data Quality for various data feeds coming from the source
2. Good experience in Azure Data Factory, Azure Synapse, Azure Databricks, and Azure SQL DB.
3. Good hands-on exp on CICD pipeline (Azure Deveops) to move test code to a higher environment and have knowledge of Pipelines to run the notebooks via pipeline
4. Must possess good programming skills with SQL, Spark SQL. Scala, Python, etc.
5. Good knowledge Data Warehousing concepts & Data Modelling
6. Manage, monitor, and ensure the security and privacy of data to satisfy business needs
7. Experience in database testing, data comparison & data transformation scripting
8. Should be able to provision and set up data platform technologies and Test environment in the cloud.
9. Well versed with relational databases, nonrelational databases, data streams, and file stores.
10. Must have good hands-on experience in creating Stored Procedures, Functions, Tables, Cursors, Hash tables and handling large data types.
11. Should know about working of Joins, Subqueries, CTEs and complex query writing skills
12. Experience in testing of reports, BO Universe and Power-BI
13. Experienced in structured test methods and processes 14. Experience in Agile methodologies and DevOps would be added advantage