Job Openings
(B) ETL Consultant
About the job (B) ETL Consultant
Job Spec
Qualifications
Degree in Computer Science, Engineering Disciplines or equivalent technical certification or experience
Professional Qualification and/or Regulatory, Licensing requirements
-
Required Competencies and Skills
Competencies/Skills
(Essential to succeed in this job)
• Required Skill set:
• SQL
• Familiar with mainstream relational database such as SQL Server, Oracle, PostgreSQL, MySQL, Teradata
• Unix, Shell Scripting
• ODI & Informatica Tool experience: (Good to Have)
• BI Tool experience (Good to Have)
• Business Intelligent (BI) working experience in Hadoop BigData platform and familiar of Hive, Impala, Spark and etc components is preferable.
• More than 1 year working experience in ETL and BI related projects is preferable.
• Familiar with SQL Performance Tuning
• Experience in Data Warehouse ETL architecture design.
• Good communication skill and teamwork.
Key Responsibilities
• Participate in the software development life-cycle
• Gather and analyse user requirements and prepare technical design specifications
• Perform system analysis, design, testing and documentation.
• Develop and test the ETL/ELT program
• Performance Tuning
• Program deployment
• Provide post-production support