Note: Please Submit only SDET Profiles
Python/ Pyspark /AWS S3/Redshift /Informatica/ Strong Complex SQL skills mandatory
Good to have Kafka Shell scripting Healthcare experience ETL knowledge
Skill Matrix
Skills | Years of Exp | Year lastly Used | Rating Out of 10 |
MDM SAAS | | | |
Python | | | |
Pyspark | | | |
AWS S3 | | | |
Redshift | | | |
Informatica | | | |
Strong SQL Skill | | | |
Kafka | | | |
Shell scripting | | | |
Healthcare experience | | | |
ETL | | | |
Position Details | Requirement |
Role | MDM SDET with Strong Development Experience |
Location | Canada (Remote) |
Type of Hire Contract/ C2H | Longterm |
Duration | C2H |
Number of Interviews | L1HRClient |
In person interviews Yes/No | No |
Client Interview Yes/No | Yes |
Job Description | SDET Position Summary: The SDET (Software Development Engineer in Test) is responsible for ensuring the quality and reliability of ETL processes and data integration workflows. This role involves designing and implementing automated tests to validate data transformation and migration as well as collaborating with data engineers and developers to identify and resolve data quality issues. The ideal candidate will leverage their expertise in ETL testing and data validation to enhance the overall data pipeline performance and integrity. Minimum Qualification: - At least 10 years of IT experience with minimum 6 to 7 years of MDM QA experience in below skills:
- Proficiency in ETL Testing and developing automation framework & testcases in atleast one scripting language.
- Informatica MDM SaaS 360 experience.
- Informatica MDM experience in version 10.x or higher.
- Demonstrated experience in Master Data Management (MDM) functional and/or QA experience with thorough understanding of data modeling physical schema properties triggers and stored procedures.
- Strong SQL skills with experience in handling big data using ETL tools (e.g. Informatica).
- Mandatory work experience with PySpark
- Testing experience in cloud environment (AWS)
- S3 SSS Glue EMR Data Catalog Crawler SQS ETL Jobs Event Bridge.
- Athena Redshift Spectrum Databases.
- AWS Commands for running the jobs file process and movements.
- Experience with Test Automation and DevOps practices in ETL and Cloud Systems.
- Experience with Test Automation and DevOps practices in ETL and Cloud
- Experience providing testing oversight in Agile team.
- Should have excellent business communication to interact with Business teams and crossfunctional teams.
Responsibilities: - Review requirements specifications and technical design documents to understand and feedback.
- Experience in developing and implementing test strategies for complex initiatives.
- Estimate prioritize plan and coordinate testing activities.
- Create automation test framework.
- Design develop and execute automation scripts.
- Identify record document thoroughly and track bugs.
- Strong problemsolving skills troubleshooting and root cause analysis skills.
- Perform thorough regression testing when bugs are resolved.
- Develop and apply testing processes for new and existing features to meet client needs.
- Liaise with cross functional teams to identify system requirements.
- Track quality assurance metrics like defect densities and open defect counts.
- Stay up to date with new testing tools and test strategies requirements.
- Support and guide junior team members.
|