Etl Tester

**(WORK FROM HOME)**

**Job Title**

OMNI Offshore ETL Tester

**Primary Skills**

Java,sql,Azure,Python,Databricks,azure data factory

**Essential Job Functions**:
Ø Create and execute scenarios to test various API. Preparing request block and analyzing the responses in JSON/XML formats.
Ø Validate the flow of data from disparate sources ingested into multiple databases inside MySQL/Databricks, post which data is transformed by workflows built inside Azure Data Factory followed by Azure Databricks (ETL process).
Ø Thoroughly test the ETL rules built for data transformation.
Ø Test different source and target tables available in MySQL and Azure Databricks that are sourced, cleansed, transformed, joined, aggregated and final data fed into Google and Facebook for targeted campaigns.
Ø Develop test queries using SQL or PySpark as per the user stories to validate the data inside various databases including Databricks.
Ø Automate recurring QA processes through the use of SQL scripts or advanced languages such as Java or Python.
Ø Help design and build out an automation framework and automation suite that continually validates data
Ø Experience building basic workflows or data pipelines inside Azure Data Factory would be a plus. This would be a great add as certain repeated testing of data flows will need to be automated.
Ø Create and execute detailed manual test cases from information as related to functional requirements and technical specifications documentation to assure quality and accuracy.
Ø Log appropriate defects within Jira when product does not conform to specifications.
Ø Participate in daily stand-ups with project team as part of the agile methodology.
Ø Coordinate with development team members regarding defect validation and assist development team members with re-creating defects.
Ø Create appropriate test cases within TestRail Test Management tool.
Ø Update tasks information in Jira as appropriate to communicate progress with onshore test lead.

**Other Responsibilities**:
Ø Maintain technology expertise, keeping current with evolving testing tools, techniques, and strategies to improve the overall testing efficiency, processes, and best practices.
Ø Maintain a focus on customer-service, efficiency, quality, and growth.
Ø Safeguard the company’s assets.
Ø Adhere to the company’s compliance program.
Ø Maintain comprehensive knowledge of industry standards, methodologies, processes, and best practices.

**Minimum Qualifications and Job Requirements**:
Ø Excellent SQL skills and the ability to write complex queries.
Ø 2+ years working with Azure Data Factory
Ø Experience building basic workflows or data pipelines inside Azure Data Factory would be a plus.
Ø Experience with Azure Databricks is a nice to have
Ø Good understanding of file formats including JSON, Parquet, Avro, and others
Ø Prior experience with data quality tools such as Talend would be a plus.
Ø Ability to program using either Java or Python
Ø Ability to learn new technologies quickly
Ø Excellent problem-solving skills
Ø Basic understanding of software development principles.
Ø Knowledge of Jira
Ø Ability to handle multiple tasks/projects concurrently and meet deadlines.
Ø Ability to work in a fast-paced team environment. Expectations include a high level of initiative and a strong commitment to job knowledge, productivity, and attention to detail
Ø Solid software engineering skills - participated in full lifecycle development on large projects.
**Years of experience - 5+Yrs exp**

**Salary**: ₹700,000.00 - ₹1,200,000.00 per year

**Benefits**:

- Provident Fund

Schedule:

- Day shift

Ability to commute/relocate:

- Mumbai, Maharashtra: Reliably commute or planning to relocate before starting work (required)

**Experience**:

- ETL: 5 years (preferred)

**Speak with the employer**
+91 8390889752