Strong Background of ETL/Bigdata Manual and Automation Testing(8+ years)
Good understanding of Data warehouse concepts – Fact / Dimensional modeling , Data Vault 2.0 modeling
Having experience in migration of Data related projects , like validation of data from SQL / Oracle to modern databases like Snowflake / Postgres , etc
Nice to have an experience in ETL Orchestration tools like Microsoft SSIS , Informatica , Talend , Apache-Airflow , etc and understanding its task flow .
Expertise in writing SQL, Python and PySpark queries in Jupyter Notebook .
Should have hands on experience to implement On-prem and cloud data connections to automate the data validations between heterogeneous sources.
Should have hands on experience in build automation robust framework to read Rest API's, jsons, text, and CSV files and compare against RDBMS.