Etl Tester

1 week ago

Pune Maharashtra, India Rosemallow technologies Full time

EDW source to target testing (SQL scripting - manual and automation)
- Data transformation/manipulation testing (SQL scripting - manual and automation)
- Data quality/completeness validation (SQL scripting - manual and automation)
- Working knowledge and testing experience of ETL
- Experience in running the processes through the scheduler
- Quality Assurance, Process Improvement and Collaboration:

- Develop and execute comprehensive test plans to validate data within on-prem and cloud data warehouses.
- Conduct thorough testing of ETL processes, dimensional data models, and reporting outputs.
- Identify, document, and track data quality issues, working closely with data engineers to resolve them.
- Validate data loading, transformation, and aggregation processes.
- Ensure data consistency and integrity across different data sources and systems.
- Collaborate with the Data Quality and Data Engineering team to define quality benchmarks and metrics.
- Continuously improve QA testing strategies and methodologies.
- Implement best practices for data validation and error handling.
- Assist in the design and implementation of data quality assurance tools and frameworks.
- Work closely with BA, data architect, data engineers, QA and stakeholders to understand data requirements and deliverables.
- Work closely with the Lead Data QA Engineer to design, develop, maintain and support testing infrastructure
- Provide detailed reports on data quality findings and testing outcomes.
- Contribute insights and recommendations to enhance data quality and processing efficiency.

**Requirements**:

- Bachelors or master’s in computer science or equivalent.
- Strong understanding of Data Warehouse & Data Quality fundamentals.
- 2 to 3 years of experience in data warehouse development/testing.
- 2 to 3 years of experience with SQL Server and SSIS/SSAS/SSRS testing
- Must be experienced in Data Warehousing Projects with good knowledge of ETL testing.
- Strong in SQL, RDBMS, ETL, and DW concepts.
- Experience in validating Reports/Dashboards on tools like Tableau, MS Power BI, etc.
- Great attention to detail with a result-driven test approach.
- Self-starter; strong drive, bias-to-action, commitment with solid work ethics
- Willingness to take on big challenges and own the results from brainstorming to execution.
- Excellent written and verbal communication skills - Able to influence others effectively.
- Willingness to provide off-hour support as needed or on a rotation basis.

**You’re a Great Fit If You Have**:

- Minimum 2 to 3 years of Quality Assurance experience (manual/automated testing) with a proven track record ofimproving Data Quality by implementing QA best practices within organization
- SSIS & MSSQL experience (intermediate or senior level)
- Experience with the Snowflake and DBT is a plus
- Experience in using QA automation tools
- ETL process knowledge; Knowledge of data warehouse testing procedures

**Desirable qualifications/pluses**:

- Knowledge of Insurance Data & its processes
- Data validation experience between on-prem & cloud (i.e. hybrid) architecture.
- Familiarity with cloud computing and the data ecosystem on Snowflake

**Job Type**: Permanent

Pay: Up to ₹1,700,000.00 per year

**Benefits**:

- Health insurance
- Life insurance
- Provident Fund

Schedule:

- UK shift

Application Question(s):

- Are you an immediate joiner?

**Experience**:

- Data warehouse: 3 years (required)
- ETL Testing: 3 years (required)
- SQL: 3 years (required)

Work Location: In person

  • Etl Tester

    2 weeks ago

    Pune District, Maharashtra, India Purple Drive Technologies Full time

    **Job Description: ETL Tester** **Company**: Purple Drive Technology **Position**: ETL Tester **Experience**: 5+ Years of Relevant Experience **Location**: Pune **Salary**: Up to 6.5 LPA **Notice Period**: Immediate to 30 Days **Key Responsibilities**: - Conduct ETL testing by validating data extraction, transformation, and loading processes. - Design and...

  • ETL Tester

    2 weeks ago

    Pune, India Dataceria Full time

    Position: Software ETL Tester Location: Pune Work mode: Hybrid (2 days in office) Timings: 1 Pm to 9 PM Experience: 5 to 8 years Immediate joiner : send your resume : Company : Dataceria Software solutions We have an exciting opportunity in the Data Services team for an ETL Tester to develop and maintain test, data validation frameworks. The Test Engineer...

  • ETL Tester

    2 weeks ago

    pune, India Dataceria Full time

    Position: Software ETL Tester Location: Pune Work mode: Hybrid (2 days in office) Timings: 1 Pm to 9 PM Experience: 5 to 8 years Immediate joiner : send your resume : Company : Dataceria Software solutions We have an exciting opportunity in the Data Services team for an ETL Tester to develop and maintain test, data validation frameworks. The Test Engineer...

  • ETL Tester

    2 weeks ago

    Pune, India Dataceria Full time

    Position: Software ETL Tester Location: Pune Work mode: Hybrid (2 days in office) Timings: 1 Pm to 9 PM Experience: 5 to 8 years Immediate joiner : send your resume : Company : Dataceria Software solutions We have an exciting opportunity in the Data Services team for an ETL Tester to develop and maintain test, data validation frameworks. The Test Engineer...

  • ETL Tester

    1 week ago

    Pune, India Dataceria Full time

    Position: Software ETL Tester Location: Pune Work mode: Hybrid (2 days in office) Timings: 1 Pm to 9 PM Experience: 5 to 8 years Immediate joiner : send your resume : Testing@dataceria.com Company : Dataceria Software solutions We have an exciting opportunity in the Data Services team for an ETL Tester to develop and maintain test, data validation...

  • ETL Tester

    2 weeks ago

    Pune, India Dataceria Full time

    Position: Software ETL Tester Location: Pune Work mode: Hybrid (2 days in office) Timings: 1 Pm to 9 PM Experience: 5 to 8 years Immediate joiner : send your resume : Testing@dataceria.com Company: Dataceria Software solutions We have an exciting opportunity in the Data Services team for an ETL Tester to develop and maintain test, data validation frameworks....

  • Etl Testers

    1 week ago

    Pune, India Bultaminds Venture Full time

    Job Title ETL testers Work Experience 4years -7years **Skills**: ETL testing Location pune - Maharashtra, India **Skill Set: - ** - 4+ years of experience. - Experience in ETL testing, Strong in SQL queries - Hands on experience in Automated Test development; C# preferred - Agile concepts with JIRA knowledge

  • ETL Tester

    1 day ago

    Pune, India Dataceria Full time

    Position: Software ETL TesterLocation: PuneWork mode: Hybrid (2 days in office)Timings: 1 Pm to 9 PMExperience: 5 to 8 yearsImmediate joiner : send your resume : : Dataceria Software solutionsWe have an exciting opportunity in the Data Services team for an ETL Tester to develop and maintain test, data validation frameworks.The Test Engineer will...

  • Etl Tester

    21 hours ago

    Pune, Maharashtra, India Capgemini Full time

    1. Applies scientific methods to analyse and solve software engineering problems. 3. His/her work requires the exercise of original thought and judgement and the ability to supervise the technical and administrative work of other software engineers. 4. The software engineer builds skills and expertise of his/her software engineering discipline to reach...

  • ETL Tester

    2 weeks ago

    Pune, India Dataceria Full time

    Position: Software ETL TesterLocation: PuneWork mode: Hybrid (2 days in office)Timings: 1 Pm to 9 PMExperience: 5 to 8 yearsImmediate joiner : send your resume : : Dataceria Software solutionsWe have an exciting opportunity in the Data Services team for an ETL Tester to develop and maintain test, data validation frameworks.The Test Engineer will ensure...