ETL Testing Engineer

Develop and execute ETL test cases to validate data extraction, transformation, and loading processes.
- Write complex SQL queries to verify data integrity, consistency, and correctness across source and target systems.- Automate ETL testing workflows using Python, PyTest, or other testing frameworks.- Perform data reconciliation, schema validation, and data quality checks.- Identify and report data anomalies, performance bottlenecks, and defects.- Work closely with Data Engineers, Analysts, and Business Teams to understand data requirements.- Design and maintain test data sets for validation.- Implement CI/CD pipelines for automated ETL testing (Jenkins, GitLab CI, etc.).- Document test results, defects, and validation reports.

ETL Testing: Strong experience in testing Informatica, Talend, SSIS, Databricks, or similar ETL tools.
- SQL: Advanced SQL skills (joins, aggregations, subqueries, stored procedures).- Python: Proficiency in Python for test automation (Pandas, PySpark, PyTest).- Databases: Hands-on experience with RDBMS (Oracle, SQL Server, PostgreSQL) & NoSQL (MongoDB, Cassandra).- Big Data Testing (Good to Have): Hadoop, Hive, Spark, Kafka.- Testing Tools: Knowledge of Selenium, Airflow, Great Expectations, or similar frameworks.- Version Control: Git, GitHub/GitLab.- CI/CD: Jenkins, Azure DevOps, or similar.Soft Skills:- Strong analytical and problem-solving skills.- Ability to work in Agile/Scrum environments.- Good communication skills for cross-functional collaboration.Preferred Qualifications:- Experience with cloud platforms (AWS, Azure).- Knowledge of Data Warehousing concepts (Star Schema, Snowflake Schema).- Certification in ETL Testing, SQL, or Python is a plus.

• Data Warehousing
• MS SQL Server
• Python