Python ETL Data Tester

• Experience in Data/ETL Testing. Experience in Python-based ETL test automation. Experience in ETL Testing, Data Warehouse Testing, and Data Migration Testing. Develop automation solutions using Python/Shell scripting for ETL and data validation activities. Experience in SQL and database validation across Oracle, SQL Server, PostgreSQL, Snowflake, AWS Redshift, or BigQuery. Validate source-to-target mappings, transformation rules, data lineage, and business logic as per mapping documents. Perform data reconciliation, completeness checks, referential integrity, duplicate detection, and data quality validations. Experience in ETL tools such as Informatica, Ab Initio, ODI, SSIS, DataStage, Azure Data Factory, or Databricks. Strong understanding of Data Warehousing concepts including Facts, Dimensions, Star Schema, and SCD validations. Experience validating cloud-based data platforms on AWS, Azure, Databricks, Snowflake, or Google Cloud Platform. Hands-on experience with batch job validation, workflow monitoring, and scheduling tools such as Autosys, Control-M, or Airflow. Implement test strategies, prepare and execute test cases, analyze results, and coordinate defect resolution to ensure data quality. Collaborate with business, development, and data engineering teams to ensure accurate and reliable data delivery. Maintain detailed documentation of test scenarios, SQL validations, automation assets, and testing processes.

Preferred Skill and Experience

• Experience in BI Reporting validation using Power BI, Tableau, Qlik, or MicroStrategy. Experience in Big Data technologies such as Hadoop, Spark, Hive, and Kafka. Knowledge of AI-enabled Data Quality and Data Governance solutions. Banking, Capital Markets, Wealth Management, or Mortgage domain experience.