Etl Tester

3 days ago

Mumbai, India Testriq QA Lab LLP Full time

**(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

  • Senior ETL Tester

    4 weeks ago

    Mumbai, India Virtusa Full time

    Senior ETL Tester - CREQ190390 Description Sr ETL Tester with special emphasis and experience of 6 to 10 years on ETL Testing, good experience in understanding requirement related to extraction, transformation and loading (ETL) of data using Informatica. Primary Location Mumbai, Maharashtra, India Job Type Experienced Primary Skills ETL Years of Experience...

  • Senior ETL Tester

    3 weeks ago

    Mumbai, India Virtusa Full time

    Senior ETL Tester - CREQ190390 DescriptionSr ETL Tester with special emphasis and experience of 6 to 10 years on ETL Testing, good experience in understanding requirement related to extraction, transformation and loading (ETL) of data using Informatica.Primary Location Mumbai, Maharashtra, India Job Type Experienced Primary Skills ETL Years of Experience 8...

  • Senior ETL Tester

    1 week ago

    Mumbai, Maharashtra, India Virtusa Full time

    Senior ETL Tester - CREQ190390 Description Sr ETL Tester with special emphasis and experience of 6 to 10 years on ETL Testing, good experience in understanding requirement related to extraction, transformation and loading (ETL) of data using Informatica. Primary Location Mumbai, Maharashtra, India Job Type Experienced Primary Skills ETL Years of Experience...

  • Senior ETL Tester

    3 weeks ago

    mumbai, India Virtusa Full time

    Senior ETL Tester - CREQ190390 Description Sr ETL Tester with special emphasis and experience of 6 to 10 years on ETL Testing, good experience in understanding requirement related to extraction, transformation and loading (ETL) of data using Informatica. Primary Location Mumbai, Maharashtra, India Job Type Experienced Primary Skills ETL Years of...

  • Senior ETL Tester

    3 weeks ago

    Mumbai, India Virtusa Full time

    Senior ETL Tester - CREQ190390 Description Sr ETL Tester with special emphasis and experience of 6 to 10 years on ETL Testing, good experience in understanding requirement related to extraction, transformation and loading (ETL) of data using Informatica. Primary Location Mumbai, Maharashtra, India Job Type Experienced Primary Skills ETL Years of Experience...

  • Etl Tester

    4 weeks ago

    Mumbai, India HTC Global Services, Inc. Full time

    **About the Role**: We are looking for multiple ETL Testers with 4 years of experience in ETL Testing and experience working in migration/ conversion projects. **Requirements**: - Prepare test cases, build SQL queries for testing Data warehouse ETL process and enable walkthrough sessions for stakeholders for reviewing the same. - Prepare test cases, build...

  • Etl Testing

    3 weeks ago

    Mumbai, Maharashtra, India Virtusa Full time

    Role: Senior ETL Tester 1) Minimum 8+ years of work experience in ETL testing with SQL hands-on 2) Preferred technical knowledge on PySpark and Cloud experience 3) Extensive data analysis skills and Good communication skills 4) Good to have knowledge in Healthcare Insurance **About Virtusa** Teamwork, quality of life, professional and personal...

  • Etl QA Tester

    3 weeks ago

    Navi Mumbai, India QualityKiosk Technologies Pvt Ltd Full time

    **Job Location**:Work from Office (Mumbai) Base Location Navi Mumbai Ghansoli (Client location can be anywhere in central Mumbai or western Mumbai or harbour Mumbai line or Onsite or within India) Job Summary: **Responsibilities**: - Develop a detailed project plan, including timelines, resource allocation, and deliverables Manage a team of data...

  • ETL Tester

    3 weeks ago

    Chennai/Mumbai, India VY Systems Pvt Ltd. Full time

    Job Description Skills : ETL Testing, Data Warehousing, MongoDB/No SQL, SQL Queries, JIRA/HP ALM/qTest, ETL & Reporting Tool (Preferably Informatica, Talend & Tableau) - Must have 4 to 8 years of experience in ETL testing and Data Warehousing. - Must have good working experience in MongoDB/No SQL. - Expert in SQL Queries and familiar to work with...

  • ETL Tester

    2 months ago

    Chennai,Mumbai, India VY Systems Pvt Ltd. Full time

    Job Description Skills : ETL Testing, Data Warehousing, MongoDB/No SQL, SQL Queries, JIRA/HP ALM/qTest, ETL & Reporting Tool (Preferably Informatica, Talend & Tableau) - Must have 4 to 8 years of experience in ETL testing and Data Warehousing. - Must have good working experience in MongoDB/No SQL. - Expert in SQL Queries and familiar to work with...

  • ETL Tester

    4 weeks ago

    Chennai/Mumbai, IN VY Systems Pvt Ltd. Full time

    Job Description Skills : ETL Testing, Data Warehousing, MongoDB/No SQL, SQL Queries, JIRA/HP ALM/qTest, ETL & Reporting Tool (Preferably Informatica, Talend & Tableau)- Must have 4 to 8 years of experience in ETL testing and Data Warehousing. - Must have good working experience in MongoDB/No SQL. - Expert in SQL Queries and familiar to work with Snowflake,...

  • ETL Tester

    2 months ago

    Chennai/Mumbai, IN VY Systems Pvt Ltd. Full time

    Job Description Skills : ETL Testing, Data Warehousing, MongoDB/No SQL, SQL Queries, JIRA/HP ALM/qTest, ETL & Reporting Tool (Preferably Informatica, Talend & Tableau)- Must have 4 to 8 years of experience in ETL testing and Data Warehousing. - Must have good working experience in MongoDB/No SQL. - Expert in SQL Queries and familiar to work with Snowflake,...

  • BI Tester

    2 months ago

    Mumbai, Maharashtra, India ScatterPie Analytics Full time

    **Skills Required**: - Ensure data credibility and correctness of insights derived from BI process via testing. - Evaluate the staging data, ETL process, and BI reports for accuracy and adherence to business requirements. - Testing of dashboard / report based on the business requirements / design specification. - Validate / create test cases and scripts...

  • BI Tester

    1 week ago

    Mumbai, Maharashtra, India ScatterPie Analytics Full time

    **Skills Required**: - Ensure data credibility and correctness of insights derived from BI process via testing. - Evaluate the staging data, ETL process, and BI reports for accuracy and adherence to business requirements. - Testing of dashboard / report based on the business requirements / design specification. - Validate / create test cases and scripts...

  • BI Tester

    1 day ago

    Mumbai, Maharashtra, India ScatterPie Analytics Full time

    **Skills Required**: - Ensure data credibility and correctness of insights derived from BI process via testing. - Evaluate the staging data, ETL process, and BI reports for accuracy and adherence to business requirements. - Testing of dashboard / report based on the business requirements / design specification. - Validate / create test cases and scripts...

  • BI Tester

    3 weeks ago

    Mumbai, India Techknomatic Services Private Limited Full time

    **Skills Required**: - Ensure data credibility and correctness of insights derived from BI process via testing. - Evaluate the staging data, ETL process, and BI reports for accuracy and adherence to business requirements. - Testing of dashboard / report based on the business requirements / design specification. - Validate / create test cases and scripts...

  • BI Tester

    2 weeks ago

    Mumbai, Maharashtra, India ScatterPie Analytics Full time

    **Skills Required**: - Ensure data credibility and correctness of insights derived from BI process via testing. - Evaluate the staging data, ETL process, and BI reports for accuracy and adherence to business requirements. - Testing of dashboard / report based on the business requirements / design specification. - Validate / create test cases and scripts...

  • Etl Tester

    2 weeks ago

    Mumbai, India Planit Testing Full time

    Experience - 2-4 Year - Percentage required - at least 60% (10th/12th/Graduation) - Knowledge of STLC and SDLC, should have worked on regression testing, smoke testing, functional testing, usability testing, system integration testing and UAT. - **Knowledge of Database testing is must.(Joins, SQl Queries)**: - Notice Period - Immediate Joinee - 15...

  • Data Tester

    1 week ago

    Mumbai, Maharashtra, India Coforge Ltd. Full time

    Well versed with SQL. Good at solving complex SQL Queries. Knowledge on Joints, table arrays, data profilingInsurance Concepts (Policy, Claims, Billing), ETL ConceptsPrimary Technical - ETL/(Data Warehousing/Data Migration/Data Conversions Concepts)/SQL/ MSBI (SSIS and SSRS), Azure data factory/ SnowflakeKnowledge on Datainsights

  • Data Tester

    2 weeks ago

    Mumbai, India Coforge Ltd. Full time

    Well versed with SQL. Good at solving complex SQL Queries. Knowledge on Joints, table arrays, data profilingInsurance Concepts (Policy, Claims, Billing), ETL ConceptsPrimary Technical - ETL/(Data Warehousing/Data Migration/Data Conversions Concepts)/SQL/ MSBI (SSIS and SSRS), Azure data factory/ SnowflakeKnowledge on Datainsights