ETL/DWH Test Engineer

2 weeks 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 idealcandidate 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 tounderstand 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 andexecuting 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 andfact tables in the data warehouse.● Responsible for browser compatibility testing on different platforms and data validationsfor 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 datausing ETL Tool.● Conducted variance management by analyzing and verifying test results, providingstatus and progress reports.● Work with release coordinators in ensuring timely delivery of test environments and testresults.● 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 andrequirement gaps● Responsible for on-time delivery and timely escalations/update of risks, issues, statusand exemptions to leadership● Effective communication with the team, leadership, internal and external customerscovering all aspects of team needs● Collaborate with business users and technical teams to validate defect fixes and re-testimpacted areas● Facilitated UAT readiness meetings and Production readiness meeting to mitigateissues and outline defect deferral process to facilitate progress.● Assist business users during UAT and other testing phases by providing support andproviding 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 DataStage, QualityStage● Experience in Teradata database● Experience in WinSP or Putty or similar UNIX command tools● Knowledge and Familiarity using TOSCA● Familiarity with DataStage, QualityStage and Teradata● Experience in SOAP services testing● Good Knowledge of PL/SQL and hands on experience writing complex SQL queries andSP’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 tertiaryqualifications● 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

  • 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...


  • 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...


  • 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...


  • 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...


  • 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...


  • 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...


  • 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...


  • 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 Engineer

    9 hours ago


    Delhi, India Synechron Full time

    We have an immediate opportunity for ETL Testing Engineer - 4+ years.Synechron – PuneJob Role: - ETL Testing EngineerJob Location: - PuneAbout Company:At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital...


  • 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

    7 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...


  • 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...