ETLSQL with Automation
ETL / SQL with Automation
TorontoON
Skills andResponsibilities :
46 Years of ETL / SQLTesting with Python / PySpark / Cucumber. Solid understanding of ETLconcepts Prior experience with ETL testing
Ability towrite complex SQLs Ability to use existing automation framework.
Must understand DW concepts and have tested aDatawarehouse (Natural Keys Surrogate Keys Slowly ChangingDimensions).
Impact on Parent and Child tables due toIncremental and History loads.
ETL Testing (Schema testMandatory columns test Count test Transformation test ReferentialIntegrity) along with negative scenarios.
Workingexperience with SQL is must specially (Analytical functions Complexjoins Aggregation functions).
Must have Experience withDefect and Test cases management tool experience (ALM orJTMF).
Usual testing concepts
Defecttriaging.
Understanding of STTM (Source to TargetMapping).
Automation (ETL)10. Python11. Cucumber