ETL Consultant

Intermediate (3-6 years)

Technical Skills

  • Apache Hadoop
  • Data Warehousing
  • Java
  • Perl Programming
  • Python
  • Shell Script

Job Description

ETL Consultant

Location: Asia Pacific/Japan-Hong Kong-Hong Kong

Teradata Professional Services Role Description

Data Warehouse Consultant

Key Areas of Responsibility

                     Understand the client’s business goals, information needs, application requirements, IT plans, and architectures and application designs.

                     Capture ETL requirements, design and develop architecture for integration of the Data Architecture components into the client’s enterprise.

                     Design, develop, and test processes for validating and conditioning data prior to loading it into a Teradata Warehouse or Hadoop platform.

                     Design and develop the architecture, roadmap that will align with the customer business and IT objectives.

                     Design, develop, and test processes for extracting data from legacy systems, production databases, Teradata and Hadoop platforms.

                     Review and analyze systems and program. Draft and help implement recommended improvements to process and procedures for handling customer data and product data.

                     Support sales motions, demonstrations, and scoping of solution offers.




                     4+ full phase implementation experience with Informatica or DataStage ETL tool

                     3+ years of Data warehouse and ETL design, build, test experience  including requirements assessment, ownership of data integration architecture and ETL scheduling using Informatica

                     Experience with data quality or master data management solutions

                     Experience in Unix Shell Script, Perl, Python and JAVA would be an advantage.

                     Experience with banking, mobile industry experience preferred

                     Knowledge of Architecture Principles, Advocated Positions, Design Patterns, and Implementation Alternatives.

                    Strong consulting skills supported by good communication practices, the ability to facilitate consensus building, and the ability to support the customer in trade-off analysis.




Employment TypeFull-time
Career LevelIntermediate (3-6 years)
Education LevelMaster
TeradataInformation Technology

2109-10, Millenium City 2 378 Kwun Tong Road Kwun Tong, Kowloon Hong Kong

directions_walk6 mins walk from Ngau Tau Kok Station