BI ETL Data stage 1 position, onsite Sukhumvit 42 (contract 6 – 12 months)

Start working : 01/09/2016

Responsibilities :

• Design and enhance database solutions to meet the customer requirements
• Develop and document system design specifics in a “Solution-in-Detail” to assure understanding and to gain agreement by user of specific system inputs, outputs and costs
• Conduct walk-throughs and develop specifications in sufficient detail to insure maximum system compliance with customer needs
• Design and develop limited changes to ETL solutions
• Design and develop reports, dashboards or other user interface solutions
• Performs testing (unit, integration, regression and support of user testing) to ensure code meets technical and business requirements
• Maintain expertise in data warehouse tools and technologies and coach team members

 

Qualification :

• Required Thai nationality only.

• Bachelor’s Degree in Computer Science or related field
• 5 – 7 years of experience in Information Technology with 5+ years in Business Intelligence ETL/DataStage
• Experience with ETL performance optimization techniques
• Extensive experience with BI user reporting and analysis tools and the overall user experience

 

ETL Datastage 2 positions, onsite Ratchayothin (contract period : 01/09/2016 – 31/12/2016)

Responsibilities :

• Responsible for Analysis, Design, Development and Implementation of ETL process using various Teradata utilities like TPT, BTEQ, FLOAD, MLOAD, TPUMP and FEXPORT
• Build and enhance ETL Software, data warehouse scripts, views, metrics and reports.
• Accommodate requests from business users and owners of other applications (e.g. CRM) for additional data sources, business rules and tables
• Provide production support for data warehouse applications.  
• Develop and execute unit test plans
• Other duties and appropriate or assigned.

 

Qualification :

• Required Thai nationality only.

• More than 3 years experience in Teradata
• Analysis and development experience using the following tool sets: DataStage (IBM) ETL tool, Teradata, Oracle database, SQL Server

 

 

SQL Teradata 2 positions, onsite Ratchayothin (contract period : 01/09/2016 – 31/12/2016)

Responsibilities :

• Responsible for table design, definition and maintenance
• Engage with team to administrate database environment
• Performance Tuning and problem determination on Teradata
• Developing scripts to copy files from various servers to local servers
• Bulk loading the data from source files using External table load concept of Teradata appliance
• Plan the scheduling of jobs to be run

 

Qualification :

• Required Thai nationality only.

• More than 3 years experience in Teradata
• Strong knowledge and experience with SQL/Stored procedure development
• Strong experiences in SQL/Stored procedure on oracle/DB2 or other DBMS
• Preferred Technical and Professional Experience