The Role
Senior SDET responsible for ETL/Big Data manual and automation testing, validating data migrations between SQL/Oracle and modern databases (Snowflake/Postgres), building automation frameworks to compare APIs, JSON/files and RDBMS, writing SQL/Python/PySpark tests, implementing CI/CD pipelines, and working with AWS S3, Minio, Airflow, Tableau/SuperSet and Jira. Financial domain experience preferred.
Summary Generated by Built In
No# of Open position : 2
Location : Offshore
Job Description :
- Strong Background of ETL/Bigdata Manual and Automation Testing(8+ years)
- Good understanding of Data warehouse concepts – Fact / Dimensional modeling , Data Vault 2.0 modeling
- Having experience in migration of Data related projects , like validation of data from SQL / Oracle to modern databases like Snowflake / Postgres , etc
- Nice to have an experience in ETL Orchestration tools like Microsoft SSIS , Informatica , Talend , Apache-Airflow , etc and understanding its task flow .
- Expertise in writing SQL, Python and PySpark queries in Jupyter Notebook .
- Should have hands on experience to implement On-prem and cloud data connections to automate the data validations between heterogeneous sources.
- Should have hands on experience in build automation robust framework to read Rest API's, jsons, text, and CSV files and compare against RDBMS.
- implement and maintain CI/CD pipelines for automated testing and reporting.
- Should have worked on AWS S3, Minio, Airflow, Snowflake, Postgres, Tableau, SuperSet, and Jira.
- Proficiency in data automation using python, Pytest, BDD, Robot Framework, etc..
- Should be team player and supportive to the team members to upskill on automation implementation and maintenance.
- Preferred to have financial domain knowledge
Skills Required
- 8+ years ETL/Big Data manual and automation testing experience
- Strong understanding of data warehouse concepts (fact/dimensional modeling) and Data Vault 2.0
- Experience validating data migrations from SQL/Oracle to Snowflake/Postgres
- Experience with ETL orchestration tools (Microsoft SSIS, Informatica, Talend, Apache Airflow)
- Expertise writing SQL, Python and PySpark queries in Jupyter Notebook
- Hands-on experience automating data validations across on-prem and cloud heterogeneous sources
- Experience building automation frameworks to read REST APIs, JSON, text, and CSV and compare against RDBMS
- Experience implementing and maintaining CI/CD pipelines for automated testing and reporting
- Experience with AWS S3, Minio, Airflow, Snowflake, Postgres, Tableau, SuperSet, and Jira
- Proficiency in data automation using Python, Pytest, BDD, Robot Framework
- Team player, willing to upskill and support team members
- Financial domain knowledge
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Photon.com has emerged as one of the world’s largest and fastest-growing Digital Agencies. We work with 40% of the Fortune 100 on their Digital initiatives and are known for our ability to integrate Strategy Consulting, Creative Design, and Technology at scale. Please visit www.photon.com to learn more about us, how we work, and our customer case studies. Digital Transformation Starts Here.
