ETL Tester

Job Details : ETL Tester

• Job Location: Pune or Nagpur (May have to travel to Dubai for a few months)
• Year of Experience- 2-3 years
• Job Type: Full Time

Job Description:

• 2+ Years of Software Quality Assurance experience on enterprise level applications, which includes Data Warehouse Testing.
• Experience in writing complex SQL queries, ability to determine the types of testing that must be conducted (i.e., data validation, regression, etc.), including evaluating the testability of requirements and create a comprehensive test plan that supports the business and technological solutions being delivered.
• Should have experience testing multiple test phases in medium to large projects.
• Should have adequate experience and clear understanding of data warehouse and data mart testing.
• Identification and Test Data Preparation Techniques.
• Thorough knowledge of Software Test Life Cycle, Test Case Life Cycle, Defect Life Cycle etc. Proficiency with Test Case Preparation and Execution.
• Extensive exposure to Back-end ETL testing with high-level of SQL skills is required.
• Possess experience in using Informatica suite of tools.
• Should have exposure to large data sets and understand Data Quality Framework.
• Must have Talend Open Studio Experience
• Experience in data analysis, including profiling, auditing, balancing, and reconciliation, in an information technology-operating environment.
• Defect tracking experience (i.e. Jira, Bugzilla, etc.)
• Experience in tuning SQL queries, Stored Procedures, Views, etc. for performance improvements.
• Knowledge of data models and entity relationship diagrams.
• Knowledge and experience in data masking methodologies
• Familiar with Metadata Management tools.
• Expertise in Functional Regression Testing of Data Processing Pipelines · Quality Assurance: Conduct thorough testing of reports to ensure accuracy, reliability, and adherence to business requirements.

Requirement and Skills :

• 2+ years of professional experience as a ETL Tester.
• Strong proficiency in Manual testing.
• Experience in either Talend Enterprise Edition or Informatica tools is required.
• Familiarity with Data Warehousing and Data Visualizations.
• Knowledge of database systems (SQL, NoSQL) and ORM frameworks.
• Ability to write clean, efficient, and reusable code.
• Strong problem-solving and analytical skills.

Excellent communication and teamwork abilities