16 Nov
|
CitiusTech
|
Mumbai
Job Summary
As a Lead Engineer - ETL Testing role involves the validation of data pipelines and processes that extract, transform, and load data. Must be detail-oriented and experienced in data/DWH testing on large-scale data platforms, including Snowflake, Azure Data Services, and backend services.
Responsibilities
- Write test data scripts, based on ETL mapping artifacts.
- Execute data scripts and detailed analysis on the scripts.
- Create strategies and test cases for applications that use ETL components.
- Validate Mage AI pipelines, including orchestration, dependencies, failures, reruns, and incremental loads.
- Perform full-load, incremental/delta, historical-load, schema, and large-volume data validation.
- Define and track quality assurance metrics such as defects, defect counts, test results and test status testing backend, and focus on complex SQL queries.
- Experience analyzing ETL mapping documents
- Create SQL scripts based ETL mapping documents.
- Create and execute strategies and test cases for applications that use ETL components.
Experience
- 5 - 7 Years
Location
- Chennai
- Pune
- Bangalore
- Mumbai
Educational Qualifications
- Engineering Degree - BE/ME/BTech/MTech/BSc/MSc.
- Technical certification in multiple technologies is desirable.
Mandatory Skills
- Hands-on experience in ETL testing and data testing
- Experience with Snowflake, SQL, and DBT
- Experience in ADF (Azure Data Factory) and ETL/ELT pipeline testing
- Proficiency in Validator or similar data validation tools
- Strong understanding of ELT pipeline testing, data comparison, and validation
- Solid SQL skills for data validation and troubleshooting
- Excellent communication and interpersonal skills, and the ability to effectively present information and respond to questions from groups of managers and clients
- Strong experience in analyzing requirements
Valuable to Have Skills
- Experience of agile/Scaled Agile methodology, processes and tools such as Jira, ALM, and more
Disclaimer: This job posting and Location has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
Role: Data / Big Data Testing Engineer,
Industry Type: Medical Services / Hospital,
Department: Engineering - Software & QA,
Employment Type: Full Time, Permanent
Role Category: Quality Assurance and Testing
Education
UG: B.Tech / B.E. in Any Specialization, B.Sc in Any Specialization
PG: MS/M.Sc(Science) in Any Specialization, M.Tech in Any Specialization
Key Skills agileagile methodologyaialmanalyticsazureazure data factoryazure data servicesbusiness transformationcatalystcloudcloud computingcommunication and interpersonal skillsdata analyticsdata pipelinesdata platforms
📌 Lead Engineer - I_ETL Testing (Mumbai)
🏢 CitiusTech
📍 Mumbai