Etl/dwh test engineer

1 week ago

Delhi, India Mitra AI Full time
About Mitra
Mitra AI is a global technology company that specializes in AI-driven solutions, cloud engineering, enterprise integration and workflow automation. Headquartered in the UK, Mitra has been serving global clients for the last 12 years in the US, UK, EU and APAC, across industries such as BFSI, telecommunications, healthcare, and retail, helping businesses modernize and optimize their operations.
Job Overview:
We are seeking an ETL, DWH & BI experienced Test Engineer to join our team. The ideal
candidate will have hands-on experience in testing ETL jobs, DWH application & BI. Automation experience around this would be an advantage. You will work closely with cross-functional teams to validate business requirements, perform system integration testing (SIT), support user acceptance testing (UAT), and support the overall software implementation lifecycle.
Job Specific Duties & Responsibilities
● Ability to understand requirements and technical reference documents and be able to
understand business requirements
● Prepare test Plan and test strategy documents for data warehousing applications
● Create test scenarios and test cases for data warehousing applications
● Identifying/creating test data to cover identified test scenarios
● Managed lower environments for testing availability and test data preparation
● Perform the Back-End testing to verify and validate data consistency by writing and
executing Oracle PL/SQL queries on the database.
● Perform extensive data validation against data warehouse using automation
● Ability to write PL/SQL queries and validate PL/SQL stored procedures
● Handled SCD Type 1/ Type 2 to populate current and historical data to dimensions and
fact tables in the data warehouse.
● Responsible for browser compatibility testing on different platforms and data validations
for all reports
● Testing of data validation jobs developed in the Data Stage environment.
● Validate ETL processes to load data through the Staging layer into DWH
● Ability to write UNIX / PERL scripts
● Perform system testing, regression testing, integration testing and produce test reports
● Validate graphs for extracting, cleansing, transforming, integrating, and loading data
using ETL Tool.
● Conducted variance management by analyzing and verifying test results, providing
status and progress reports.
● Work with release coordinators in ensuring timely delivery of test environments and test
results.
● Execution of automation scripts during testing cycles
● Responsible for reporting defects found during testing and retest of defects
● Ability to understand, troubleshoot and differentiate defects, data issues and
requirement gaps
● Responsible for on-time delivery and timely escalations/update of risks, issues, status
and exemptions to leadership
● Effective communication with the team, leadership, internal and external customers
covering all aspects of team needs
● Collaborate with business users and technical teams to validate defect fixes and re-test
impacted areas
● Facilitated UAT readiness meetings and Production readiness meeting to mitigate
issues and outline defect deferral process to facilitate progress.
● Assist business users during UAT and other testing phases by providing support and
providing feedback for improvement.
● Awareness of different software development and QA methodologies
● Stay up to date with the latest automation tools, technologies and trends
Required Skills & Competencies
● Experience in Agile/Scrum methodologies
● Experience in using IBM Data Stage, Quality Stage
● Experience in Teradata database
● Experience in Win SP or Putty or similar UNIX command tools
● Knowledge and Familiarity using TOSCA
● Familiarity with Data Stage, Quality Stage and Teradata
● Experience in SOAP services testing
● Good Knowledge of PL/SQL and hands on experience writing complex SQL queries and
SP’s
● Experience in banking/fintech applications testing is a plus
● Good analytical skills, troubleshooting and resolution skills
● Excellent communication and documentation skills
● Ability to self-learn and grasp the knowledge quickly
Required Qualifications & Experience
● 7+ years of experience in the quality assurance industry, along with relevant tertiary
qualifications
● 3+ years of hands-on testing experience in ETL, DWH & BI areas
● More than 1 year of automation testing experience in ETL, DWH & BI areas is a plus
● Certification in ISTQB (International Software Testing Qualifications Board) is a plus
● Certification in TOSCA is a plus

  • ETL/DWH Test Engineer

    1 week ago

    Delhi, India Mitra AI Full time

    About MitraMitra AI is a global technology company that specializes in AI-driven solutions, cloud engineering, enterprise integration and workflow automation. Headquartered in the UK, Mitra has been serving global clients for the last 12 years in the US, UK, EU and APAC, across industries such as BFSI, telecommunications, healthcare, and retail, helping...

  • Mitra AI | ETL/DWH Test Engineer | delhi

    1 week ago

    delhi, India Mitra AI Full time

    About MitraMitra AI is a global technology company that specializes in AI-driven solutions, cloud engineering, enterprise integration and workflow automation. Headquartered in the UK, Mitra has been serving global clients for the last 12 years in the US, UK, EU and APAC, across industries such as BFSI, telecommunications, healthcare, and retail, helping...

  • Senior TOSCA Automation Engineer

    7 days ago

    Delhi, India Mitra AI Full time

    About MitraMitra AI is a global technology company that specializes in AI-driven solutions, cloud engineering, enterprise integration and workflow automation. Headquartered in the UK, Mitra has been serving global clients for the last 12 years in the US, UK, EU and APAC, across industries such as BFSI, telecommunications, healthcare, and retail, helping...

  • Senior TOSCA Automation Engineer

    1 week ago

    Delhi, India Mitra AI Full time

    About MitraMitra AI is a global technology company that specializes in AI-driven solutions, cloud engineering, enterprise integration and workflow automation. Headquartered in the UK, Mitra has been serving global clients for the last 12 years in the US, UK, EU and APAC, across industries such as BFSI, telecommunications, healthcare, and retail, helping...

  • Senior tosca automation engineer

    7 days ago

    Delhi, India Mitra AI Full time

    About MitraMitra AI is a global technology company that specializes in AI-driven solutions, cloud engineering, enterprise integration and workflow automation. Headquartered in the UK, Mitra has been serving global clients for the last 12 years in the US, UK, EU and APAC, across industries such as BFSI, telecommunications, healthcare, and retail, helping...

  • Senior TOSCA Automation Engineer

    1 week ago

    Delhi, India Mitra AI Full time

    About MitraMitra AI is a global technology company that specializes in AI-driven solutions, cloud engineering, enterprise integration and workflow automation. Headquartered in the UK, Mitra has been serving global clients for the last 12 years in the US, UK, EU and APAC, across industries such as BFSI, telecommunications, healthcare, and retail, helping...

  • Mitra AI | Senior TOSCA Automation Engineer

    1 week ago

    delhi, India Mitra AI Full time

    About MitraMitra AI is a global technology company that specializes in AI-driven solutions, cloud engineering, enterprise integration and workflow automation. Headquartered in the UK, Mitra has been serving global clients for the last 12 years in the US, UK, EU and APAC, across industries such as BFSI, telecommunications, healthcare, and retail, helping...

  • DWH API Automation Engineer

    1 week ago

    Delhi, India Mitra AI Full time

    About MitraMitra AI is a global technology company that specializes in AI-driven solutions, cloudengineering, enterprise integration and workflow automation. Headquartered in the UK, Mitrahas been serving global clients for the last 12 years in the US, UK, EU and APAC, across industries such as BFSI, telecommunications, healthcare, and retail, helping...

  • Dwh api automation engineer

    1 week ago

    Delhi, India Mitra AI Full time

    About MitraMitra AI is a global technology company that specializes in AI-driven solutions, cloudengineering, enterprise integration and workflow automation. Headquartered in the UK, Mitrahas been serving global clients for the last 12 years in the US, UK, EU and APAC, across industries such as BFSI, telecommunications, healthcare, and retail, helping...

  • Sr Testing Analysts

    3 weeks ago

    delhi, India Black Panda Enterprises Full time

    We are excited to offer an opportunity for anSr Testing Analysts (ETL+SQL)to join our client,Taliun Solutions, a Silicon Valley-based company known for its expertise in data-driven software innovation, with a focus on the healthcare domain. If you're passionate about ensuring quality through rigorous testing of ETL processes and SQL-based data validation,...

  • Sr Testing Analysts

    3 weeks ago

    Delhi, India Black Panda Enterprises Full time

    We are excited to offer an opportunity for anSr Testing Analysts (ETL+SQL)to join our client,Taliun Solutions, a Silicon Valley-based company known for its expertise in data-driven software innovation, with a focus on the healthcare domain. If you're passionate about ensuring quality through rigorous testing of ETL processes and SQL-based data validation,...

  • Sr Testing Analysts

    3 weeks ago

    delhi, India Black Panda Enterprises Full time

    We are excited to offer an opportunity for an Sr Testing Analysts (ETL+SQL) to join our client, Taliun Solutions , a Silicon Valley-based company known for its expertise in data-driven software innovation, with a focus on the healthcare domain. If you're passionate about ensuring quality through rigorous testing of ETL processes and SQL-based data...

  • Etl test engineer

    6 days ago

    Delhi, India ValueLabs Full time

    Note: We are looking for only Immediate Joiners or who can join within 15 days.Job Title: ETL TesterJob Summary:We are seeking an experienced ETL Tester to join our team immediately. The ideal candidate will have a strong background in testing Extract, Transform, and Load (ETL) processes, including data extraction, data transformation, and data loading. The...

  • ETL Test Engineer

    1 week ago

    Delhi, India ValueLabs Full time

    Note: We are looking for only Immediate Joiners or who can join within 15 days.Job Title: ETL TesterJob Summary:We are seeking an experienced ETL Tester to join our team immediately. The ideal candidate will have a strong background in testing Extract, Transform, and Load (ETL) processes, including data extraction, data transformation, and data loading. The...

  • Sr Testing Analysts

    3 weeks ago

    Delhi, India Black Panda Enterprises Full time

    We are excited to offer an opportunity for an Sr Testing Analysts (ETL+SQL) to join our client, Taliun Solutions , a Silicon Valley-based company known for its expertise in data-driven software innovation, with a focus on the healthcare domain. If you're passionate about ensuring quality through rigorous testing of ETL processes and SQL-based data...

  • Sr Testing Analysts

    3 weeks ago

    delhi, India Black Panda Enterprises Full time

    We are excited to offer an opportunity for an Sr Testing Analysts (ETL+SQL) to join our client, Taliun Solutions , a Silicon Valley-based company known for its expertise in data-driven software innovation, with a focus on the healthcare domain. If you're passionate about ensuring quality through rigorous testing of ETL processes and SQL-based data...

  • Sr testing analysts

    3 weeks ago

    Delhi, India Black Panda Enterprises Full time

    We are excited to offer an opportunity for an Sr Testing Analysts (ETL+SQL) to join our client, Taliun Solutions , a Silicon Valley-based company known for its expertise in data-driven software innovation, with a focus on the healthcare domain. If you're passionate about ensuring quality through rigorous testing of ETL processes and SQL-based data...

  • Mitra AI | DWH API Automation Engineer

    1 week ago

    delhi, India Mitra AI Full time

    About MitraMitra AI is a global technology company that specializes in AI-driven solutions, cloudengineering, enterprise integration and workflow automation. Headquartered in the UK, Mitrahas been serving global clients for the last 12 years in the US, UK, EU and APAC, across industries such as BFSI, telecommunications, healthcare, and retail, helping...

  • ETL Testing

    3 weeks ago

    delhi, India Tata Consultancy Services Full time

    Greetings from TCS! TCS is hiring for ETL Testing Desired Experience Range: 5 to 10 Years Job Location: Hyderabad Must have: • Good testing and analytical skill • Good writing and communication skills • Good understanding and experience in projects • Proficient in SQL Queries • Proficient in ETL Testing • Minimum 8 years of test experience...

  • ETL Testing

    3 weeks ago

    delhi, India Tata Consultancy Services Full time

    Greetings from TCS!TCS is hiring for ETL TestingDesired Experience Range: 5 to 10 YearsJob Location: HyderabadMust have:• Good testing and analytical skill• Good writing and communication skills• Good understanding and experience in projects• Proficient in SQL Queries• Proficient in ETL Testing• Minimum 8 years of test experience is...