Send me more jobs like this

Senior ETL Test Analyst

Keywords / Skills : AML, TR, Oracle-FCCM, Oracle-Mantas, Clusters, ETL Testing, SQL, Netezza

3 - 6 years
Posted: 2018-11-15

Job Description
Job Description:

Key Skills : AML(Anti Money Laundering), TR (Cash Transaction reports), Oracle- MANTAS, Oracle-FCCM , CLUSTERS

• Create Test plans which insure that ETL batch perform the required data transformations and load as per requirements specification.

• Test case preparation with SQL queries based on Technical design or mapping document

• Review test cases and SQL queries

• DB level checking (Tables, procedures, data loading etc.) Data bases : Oracle , SQL , Netezza

• ETL (Tool: Data Stage ) programs checking ( Transformation and loading data)

• ETL (Tool: Data Stage )functional and logic testing

• Execute test cases and RUN ETL jobs (Data Stage)

• KYC( Know your customer) data loading

• Raise defects and tracking defects in HPQC and Participating in defect triage call

• Arrange meetings with users and tech team as and when necessary

• Preparation of closure reports , reports reviews and Closure reports walk through with users.

• Giving Sign off

• BAU support to Oracle AML daily batch run and data loading

• ETL Production fixes

• SLA-Raising ticket in AM1center and attending SR's and ACR's

• Guiding and training team in technical and testing related matters.

• Attending and arranging regular meetings with Senior management

• MOM preparation

• Creation of FSD's for Tech team as and when necessary

• Document version controlling.

• MCS ( Multi Channel Switch) data load and Test

• CTR data load and testing

• Attending frequent tele Conference calls with offshore Oracle team in India.

Location : KL

Salary Budget : 7-8 K (incl of visa and other charges if any)

Joining : 1st Week of Jan 2019

About Company

The One Stop IT Solution Provider
Established in the year 1999 MSP Hitect (M) Sdn. Bhd. is one of the fast growing providers of Consulting, Technology and Outsourcing services. With the philosophy of " Total Customer Satisfaction " catering to small and medium size business houses, MSP has grown into a successful and leading corporate in the highly dynamic and compatitive IT sector.
Similar Jobs
View All Similar Jobs

Walkin for you