ETL Tester

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.