ETL Tester (SQL)

Makati City, National Capital Region

Posted more than 30 days ago

Company:: Nityo Infotech Services Philippines Inc.
Company Description:: Nityo is a global provider of IT services and end-to-end solutions designed to help clients improve their competitiveness and efficiency. Nityo has operations in 11 countries across the Globe (North America, Canada, United Kingdom, South Africa, Australia, Japan, Singapore, India, Malaysia, Thailand and Philippines). Its portfolio of solutions and services would include: Outsourcing; System Integration; Application Software Development; Consulting; Quality Assurance and Training. Nityo provides services to several local and multinational clients including those coming from Fortune-Global 1000 companies on Commercial, Industrial and Government sectors with key vertical markets such as: financial, life sciences, healthcare, telecommunications, utilities and independent software vendors.
Contract Type:: Full Time
Experience Required:: 2 years
Education Level:: Bachelor’s Degree
Gender:: Any
Number of vacancies:: 1

Job Description

Location: Taguig (Onsite)
Schedule: Dayshift

Qualifications:
- At least 2 - 3+ years of relevant experience.
- Intermediate to Advanced SQL knowledge
Can write SQL queries based on design requirements/business logic
Can write SQL queries for testing validation/extracting data for test case data comparison
Can analyze SQL scripts with multiple joining conditions (inner joins, left joins, etc) – this is critical
Validates data by running queries in the database to verify expected results
- SFTP knowledge/skills
- AWS background, knowledge on Airflows, job run validations, configurations, etc
- Can review and understand ETL requirements (source-to-target mappings), design documents, and similar technical documentation
- Writes detailed and appropriate test cases/test scripts for ETL process that loads data from files to SQL database
- Has solid documentation skills (good written and oral communication skills)
- Actively participates in meetings, status calls, testing updates
- Has JIRA background, test upload, test execution, bug tracking and reporting