Python ETL Data Tester

Python Etl Data TesterWork Location: Raleigh, NC, Richardson, TX, Tempe, AZJob Type: Full time/PermanentJob description: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 GCP.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 ExperienceExperience 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.Additional Required QualificationsBachelor's degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.