Visa Independent - Sr. Automation Engineer - Data Warehouse Support
Octans Group Llc
29 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
Tech stack
API
Agile Methodologies
Automation of Tests
Azure
Google BigQuery
Data Validation
Data Profiling
Data Warehousing
Python
Cloud Services
SQL Databases
Strategies of Testing
Freeform SQL
Postman
Snowflake
GIT
Pytest
Real Time Data
Kafka
Data Management
Amazon Web Services (AWS)
Jenkins
Redshift
Databricks
Job description
We are looking for a Sr. Automation Engineer with strong Data Warehouse (DWH) and automation expertise to support large-scale cloud migration and modernization initiatives. The ideal candidate will lead end-to-end testing efforts including data validation, API, and automation testing across enterprise platforms., * Define and execute test strategies for DWH migration and modernization
- Perform functional, integration, API, and data validation testing
- Develop automation frameworks using Python, PyTest, Postman/Newman
- Integrate automation into CI/CD pipelines (Git, Jenkins, Azure DevOps)
- Validate data using complex SQL queries and data profiling techniques
- Work with cloud/data platforms (Snowflake, Databricks, BigQuery, Redshift, etc.)
- Support real-time data testing (Kafka, SQS)
- Lead coordination with cross-functional teams and manage QE efforts
Requirements
- Strong experience in Data Warehouse testing & automation
- Hands-on Python and API automation
- Expertise in SQL and data validation
- Experience with cloud data platforms and CI/CD tools
- Familiarity with Agile/Waterfall environments