Etl Tester

7 months ago

Kuala Lumpur, Malaysia Kamlax Global Technologies SDN BHD Full time

**Job Description (JD)**
- **Minimum of 7-9 years of overall working experience with 2 to 3 years of experience in Banking domain.**:

- Must have relevant experience in data warehousing, Data Lake and RDBMS concepts and able to write complex SQL queries to perform validations.
- Must have knowledge on writing SQL queries in SQL server, Netezza and Oracle SQL developer.
- Able to perform End to End testing on Extract/Transform/Load (ETL) data transformations and other data processing needs like data cleansing, data, data profiling, data lineage analysis, root cause analysis, and data issue remediation.
- Must have experience on working complex transformation logics and data validations.
- Responsible to produce test strategy, test closure and test plans for i) individual streams ii) End to end testing by integrating all streams
- Able to prepare effective test design such as processes and procedures for test case design, test case construction, test case execution, test results compilation, defects tracking and test analysis.
- Plan, monitor and manage testing activities including daily test cases execution planning and batch jobs scheduling if any.
- Must be able to work on test data preparation planning and arrangement.
- Good to have experience on Linux/UNIX shell script programming
- Ensure all SIT/UAT defects are logged, tracked (using the Testing Tracking System) and resolved within agreed SLA’s.
- Manage all defects logged, analyse the reported defect, fixes, retesting, deliberate with stream leads on results, seek approval to migrate of defects.
- Produce daily SIT/UAT status report to Project stakeholders.
- Conduct and chair daily SIT defect triage meetings with vendors and other internal project stakeholders.
- To highlight issue, risk severity, business impact (if any) and assumption in regular project leadership meeting.
- Provide SIT/UAT closure report and walkthrough with Business.

**Key Skills / Knowledge and Behaviors (if applicable)**
- Experience in Oracle SQL / PLSQL
- Linux/UNIX shell script programming.
- IBM DataStage Server & Client Edition version 8.7 and above
- OR other ETL tools will be considered.
- Banking domain with AML knowledge is an added advantage
- HPALM(QC), JIRA, Fogbugz
- MSSMS(MSSQL), Oracle sql server management, Netezza, Mongo DB
- Working on any job scheduler like Zena / Tivoli is an added advantage

Contract length: 12 months

**Salary**: RM2,583.10 - RM13,000.00 per month

Schedule:

- Day shift
- Monday to Friday

Ability to commute/relocate:

- Kuala Lumpur: Reliably commute or planning to relocate before starting work (required)

Application Question(s):

- How many years of experience do you have as an ETL Tester?
- How many years of experience do you have with ETL?
- How many years of experience do you have with SQL?

  • Etl Tester

    2 days ago

    Kuala Lumpur, Malaysia Power IT Services private limited Full time

    Job Description: **Test Lead/Manager - Grade Level : SA/M** MANDATEREQUIREMENTS: ETL TESTING + Strong SQL GOOD TO HAVE: TERADATA/BIG DATA - Should possess strong knowledge in ETL Testing and should be able to lead and manage the end to end testing activities. - Strong knowledge in delivering test plan/test strategies for the project and Designing and...

  • Etl Tester

    7 months ago

    Kuala Lumpur, Malaysia Skill quotient Full time

    Bachelor or Master’s degree in Engineering, Computer Science, Information Technology or equivalent. - 4+ years of experience with ETL and SQL queries and experience in all testing phases and activities. - Experience in AWS cloud server is desirable. - Good hands-on experience with Data Warehousing. - Knowledge on Ingestion and extraction framework. -...

  • Etl Developer

    7 months ago

    Kuala Lumpur, Malaysia Verinon Technology Solutions Sdn Bhd Full time

    **Role**: ETL Junior Developer - **Years of Experience**: 2-3 years - **Nationality**: Priority for Local Malaysians **Functional Tester Responsibilities** Creating new transformation object or modifying existing transformation object using SQL Server/ SSIS/ Wherescape. Development tasks will involve: - extracting data from a staging area - transferring...

  • Etl Testing

    1 week ago

    Kuala Lumpur, Malaysia Power IT Services Full time

    Job Description Test Lead/Manager - Grade Level : SA/M MANDATE REQUIREMENTS: ETL TESTING + Strong SQL GOOD TO HAVE: TERADATA/BIG DATA - Should possess strong knowledge in ETL Testing and should be able to lead and manage the end to end testing activities. - Strong knowledge in delivering test plan/test strategies for the project and Designing and building...

  • Etl Tester

    2 days ago

    Kuala Lumpur, Malaysia Pan Asia Software Solutions Sdn. Bhd. Full time

    3-5 years’ experience in testing in banking/financial system Experience in test case preparation, test execution, raise & track defect Experience in agile project Experience in data space platform, SQL (ETL, database migration proj and etc) Experienced HP ALM (optional) Knowledge in Talend, Cloudera **Required language**: English Pan Asia, founded in 1994...

  • Etl Tester

    1 week ago

    Kuala Lumpur, Malaysia Capgemini Full time

    **Roles and Responsibilities**: Requirements Analysis, Test case design, test data creation, test execution reporting to test managers, defect reporting in defect management tools, leading a small team of 2-5 members, if need be, mentoring junior team members. - Active participation in Test Strategy / Test plan preparation - Task allocation and monitoring -...

  • Etl Tester

    4 days ago

    Kuala Lumpur, Malaysia Optimum Infosolutions (M) Sdn Bhd Full time

    Job Description (JD) - Minimum of 7-9 years of overall working experience with 2 to 3 years of experience in Banking domain. - Must have relevant experience in data warehousing, Data Lake and RDBMS concepts and able to write complex SQL queries to perform validations. - Must have knowledge on writing SQL queries in SQL server, Netezza and Oracle SQL...

  • Salesforce Solution Architect

    7 months ago

    Kuala Lumpur, Malaysia BAE Systems Full time

    BAE Systems Digital Intelligence is home to 4,500 digital, cyber and intelligence experts. We work collaboratively across 10 countries to collect, connect and understand complex data, so that governments, nation states, armed forces and commercial businesses can unlock digital advantage in the most demanding environments. **Role Description** **Core...

  • Salesforce Solution Architect

    7 months ago

    Kuala Lumpur, Malaysia BAE Systems Full time

    **Location(s): Asia-Pacific & Middle East : Malaysia : Kuala Lumpur** BAE Systems Digital Intelligence is home to 4,500 digital, cyber and intelligence experts. We work collaboratively across 10 countries to collect, connect and understand complex data, so that governments, nation states, armed forces and commercial businesses can unlock digital advantage...