ETLSQL with Automation
Posted on :
18-02-2024
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Monthly Salary
Not Disclosed
Salary Not Disclosed
Vacancy
1 Vacancy
Posted on :
18-02-2024
Job Description
Req ID : 2566735
ETL/SQL with Automation
TorontoON
Skills and Responsibilities:
46 Years of ETL/SQL Testing with Python/PySpark/Cucumber. Solid understanding of ETL concepts Prior experience with ETL testing
Ability to write complex SQLs Ability to use existing automation framework.
Must understand DW concepts and have tested a Datawarehouse (Natural Keys Surrogate Keys Slowly Changing Dimensions).
Impact on Parent and Child tables due to Incremental and History loads.
ETL Testing (Schema test Mandatory columns test Count test Transformation test Referential Integrity) along with negative scenarios.
Working experience with SQL is must specially (Analytical functions Complex joins Aggregation functions).
Must have Experience with Defect and Test cases management tool experience (ALM or JTMF).
Usual testing concepts
Defect triaging.
Understanding of STTM (Source to Target Mapping).
Automation (ETL)10. Python11. Cucumber
Ability to write complex SQLs Ability to use existing automation framework.
Must understand DW concepts and have tested a Datawarehouse (Natural Keys Surrogate Keys Slowly Changing Dimensions).
Impact on Parent and Child tables due to Incremental and History loads.
ETL Testing (Schema test Mandatory columns test Count test Transformation test Referential Integrity) along with negative scenarios.
Working experience with SQL is must specially (Analytical functions Complex joins Aggregation functions).
Must have Experience with Defect and Test cases management tool experience (ALM or JTMF).
Usual testing concepts
Defect triaging.
Understanding of STTM (Source to Target Mapping).
Automation (ETL)10. Python11. Cucumber
Employment Type
Full Time
Company Industry
Key Skills
- SQL
- Pentaho
- PL/SQL
- Microsoft SQL Server
- SSIS
- Informatica
- Shell Scripting
- T Sql
- Teradata
- Data Modeling
- Data Warehouse
- Oracle
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
