ETL Tester

Job description

**Role: ETL Tester** Exp : 4- 6 years Location: Pune Required Skill Sets: ETL Testing, SQL, Databricks, Database, AWS Cloud Virtual Interview: 30th July Job Description: **Must-Have** * Must have ETL understanding, Database Views to understand the logic, different data sources, data flow in ETL. * Strong understanding of SQL is essential so that candidate can be proficient in writing moderately complex SQL queries. * Review and understand DDD, Technical Artifacts, Architectural Diagram * Ability to transform complex Business logic into SQL or PL/SQL queries * Strong in Testing Concepts, able to Generate Test scenarios / Test case, Perform Data Validation in Multiple Databases -- Redshift, MDM, Oracle * Ability to run, read from, debug batch processes -- AWS-Glue/Lambda, Informatica, Databricks * Works closely with the Software development team (Business Analysts, Developers \& other testers) to ensure timely and effective testing effort * Creating Test Execution logs along with screenshots, analyze data records, review table structures, table relationships, and understand overall data flow. * Write Advanced SQL queries to validate data quality and integrity in Snowflake and Azure , Cosmos , SQL Server etc. * Write Scala, Python and SQL code in Azure Data bricks to ensure data quality and integrity in discrete data stores like Azure Cosmos DB and Azure Blob. **If you are interested and available for the virtual Interview (30th July). Kindly apply at the earliest. Post receiving your application, I will connect with you for the data collection and the further steps. Looking forward to your responses.**