Mitra AI | ETL/DWH Test Engineer | india
1 week ago
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
-
Mitra AI | ETL/DWH Test Engineer | india
1 week ago
india Mitra AI Full timeAbout 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/DWH Test Engineer
1 week ago
India Mitra AI Full timeAbout 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/DWH Test Engineer
1 week ago
India Mitra AI Full timeAbout 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 timeAbout 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 | DWH API Automation Engineer
1 week ago
india Mitra AI Full timeAbout 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...
-
Mitra AI | DWH API Automation Engineer
1 week ago
india Mitra AI Full timeAbout 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 timeAbout 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
1 week ago
India Mitra AI Full timeAbout 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
6 days ago
India Mitra AI Full timeAbout 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
India Mitra AI Full timeAbout 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
India Mitra AI Full timeAbout 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 Software Engineer
3 weeks ago
india Mitra AI Full timeAbout Mitra Innovation ( 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...
-
Mitra AI | Senior Software Engineer
3 weeks ago
india Mitra AI Full timeAbout Mitra Innovation ( 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...
-
india Mitra AI Full timeAbout 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...
-
india Mitra AI Full timeAbout 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 | SAP Analyst | india
4 weeks ago
india Mitra AI Full timeAbout 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 | Site Reliability Engineer | india
2 days ago
india Mitra AI Full timeAbout the job About Mitra Innovation ( 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,...
-
india Mitra AI Full timeAbout 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 | Selenium Automation Tester
4 weeks ago
india Mitra AI Full timeAbout Mitra Innovation 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,...
-
Mitra AI | Appian
11 hours ago
india Mitra AI Full timeAbout 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...
