Etl Tester

1 day 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 weeks ago

    Kuala Lumpur, Malaysia POWER IT SERVICES Full time

    _Job Description : _ **Test**Lead/Manager - Grade Level : SA/M** MANDATEREQUIREMENTS: ETL TESTING + Strong SQL GOOD TOHAVE: TERADATA/BIG DATA - Should possess strong knowledge inETL Testing and should be able to lead and manage the end to end testingactivities. - Strong knowledge in delivering testplan/test strategies for the project and Designing and...

  • ETL Tester

    3 days ago

    Kuala Lumpur, Kuala Lumpur, Malaysia Tata Consultancy Services Full time 60,000 - 80,000 per year

    About TCS:Join Tata Consultancy Services, Asia Pacific and be part of an organization committed to sustainable development for our future. TCS follows the Tata group philosophy of building sustainable businesses that are rooted in the community and demonstrate care for the environment. Our unique values position us to combine a purpose-driven worldview with...

  • Etl Tester

    3 days ago

    Kuala Lumpur, Malaysia Power IT Services Full time

    **Required Technical Skill Set** Telecom Domain, SQL/PLSQL, Datawarehouse, ETL, Testing **Must-Have** - Data Validation: Verify the accuracy and completeness of data during extraction, transformation, and loading. - Test Case Design and Execution: Develop test plans, create test cases, and execute tests to validate the ETL process. - Defect Identification...

  • Etl Tester

    2 weeks ago

    Kuala Lumpur, Malaysia POWER IT SERVICES Full time

    **Required Technical Skill Set** Telecom Domain, SQL/PLSQL, Datawarehouse, ETL, Testing - _ **Data Validation: Verify the accuracy and completeness of data during extraction, transformation, and loading.** **Test Case Design and Execution: Develop test plans, create test cases, and execute tests to validate the ETL process.** **Defect Identification and...

  • Etl Testing

    1 day 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 Developer

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

  • Data Warehouse Tester

    3 days ago

    Kuala Lumpur, Malaysia Cognizant Full time

    **Role: Data Warehouse/ETL Tester** **Location: KL, Malaysia** **Required Skills**: SQL, all testing deliverable, experience in SCD types & SCD type 2 validation Basic understanding in any data model. - Knowledge of dimensional modelling and **data warehouse concepts, such as star schemas, snowflakes, dimensions, facts**. - Ability to transform complex...

  • Data Warehouse Tester

    1 day ago

    Kuala Lumpur, Malaysia Cognizant Full time

    **Role: Data Warehouse/ETL Tester** **Location: KL, Malaysia** **Required Skills**: SQL, all testing deliverable, experience in SCD types & SCD type 2 validation Basic understanding in any data model. - Knowledge of dimensional modelling and **data warehouse concepts, such as star schemas, snowflakes, dimensions, facts**. - Ability to transform complex...

  • Technical Test Analyst

    3 days ago

    Greater Kuala Lumpur, Malaysia Randall Full time 60,000 - 120,000 per year

    Budget at 9k.1 year contract.Roles: Test Analyst (Manual Tester) AND/OR Technical Test Analyst (e.g. ETL Specialist, Data MigrationTester, Automation Hybrid Tester, etc., )Summary of the Role:• Identifies flaws and uses measures to correct the Software, improving the overall result.• Test the products and systems after the developmental stage and before...

  • Automation Tester

    1 day ago

    Kuala Lumpur, Malaysia Tata Consultancy Services Full time

    - Proven experience as a data developer within the banking and finance industry or ideally asset - servicing. - Experience with technologies such as ETL tools (PlatformTalend Big data) - Minimum 8 years of relevant experience in a Quality Software Testing role - Experienced in automation tools (Selenium & QTP). - Experienced in programming language (Ruby,...