ETL/DWH Test Engineer

1 week ago

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

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

  • Mitra AI | ETL/DWH Test Engineer | india

    1 week ago

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

  • Mitra AI | ETL/DWH Test Engineer | india

    2 weeks ago

    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

    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

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

  • Senior TOSCA Automation Engineer

    7 days ago

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

  • Mitra AI | Senior TOSCA Automation Engineer

    1 week ago

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

  • Etl Testing

    6 months ago

    India Novature Tech Full time

    Keywords: ETL Testing, SQL, AWS, PYSPARK **Experience**: 4 - 10 years Designation / Role: ETL Test Engineer **Location**: INDIA **Job Description**: Looking for Strong Experience in ETL Testing Skills Required: ETL Testing, SQL,AWS, PYSPARK Location: Chennai, Mumbai, Pune, Bangalore and Gurugram Work Mode: Hybrid Shift: General Note: PF Mandatory

  • BI Test Engineer

    5 days ago

    Anywhere in India/Multiple Locations HNM Solutions Full time

    Role : BI Tester Location : Remote Experience : 5+ years Description : Key Responsibilities : - Design, develop, and execute comprehensive test plans and test cases for Data Warehouse (DWH) systems and Power BI reports. - Validate the data in DWH, ensuring consistency, accuracy, and completeness from source systems to reports. - Perform ETL (Extract,...

  • DWH API Automation Engineer

    1 week ago

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

  • DWH API Automation Engineer

    1 week ago

    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

    2 months ago

    india LTIMindtree Full time

    Hi All Looking for Data testing/ ETL testing with below Skill Skill Combination SQL + ETL + Snowflake Cloud Data testing (Migration / Modernization) TDM Testing (Informatica / CA / DelPhix/ GenRocket…etc) + Good to have SQL & ETL SQL+ Python + ETL

  • ETL Testing

    2 months ago

    india LTIMindtree Full time

    Hi All Looking for Data testing/ ETL testing with below Skill Skill Combination SQL + ETL + Snowflake Cloud Data testing (Migration / Modernization) TDM Testing (Informatica / CA / DelPhix/ GenRocket…etc) + Good to have SQL & ETL SQL+ Python + ETL

  • Sr Testing Analysts

    3 weeks ago

    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

    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

    2 months ago

    india Luxoft Full time

    Project Description:We are partnering with a leading Australian company to support their Treasury projects, aiming to build a strong onshore testing team that will work closely with the client's existing team.We are seeking experienced Testers with over 6 years of relevant experience, particularly in transformation and integration projects within Treasury...

  • Mitra AI | DWH API Automation Engineer

    1 week ago

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

  • Mitra AI | DWH API Automation Engineer

    1 week ago

    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

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

  • Senior etl test analyst

    4 weeks ago

    India G10X Full time

    Primary Technology/skills: ETL, SQL, API Specific Skills: Looking for 6+ years experienced candidates Ability to assess and ensure data quality throughout the ETL process Experience in identifying and handling data anomalies, duplicates, and inconsistencies Familiarity with data warehousing concepts and practices Strong SQL skills for querying...