全职 Data Warehouse Consultant 工作, 薪水, Accord Innovations Federal Territory 公司招聘中 - Ricebowl

Job Purpose:

• Assume responsibility as data analyst to assist data management head for request coming through Project Support, URS and BAU fixes.
• Able to write, understand and troubleshoot complex business logics in SQLs/HQLs And provide RCA and also fixes to issues found.
• Write Stored Procedures, Functions SQLs and Teradata, Oracle , Hive HQLs
• Develop jobs in shell scripts in Unix/Linux
• Team player and strong communication skills in dealing with various departments or stakeholders

Accountability:

• All business requirements and necessary details for designing the solution have been capture
• All data requirements are mapped and translated to Functional Specification document (FSD) for delivery
• Supporting Activities:
• Review BRD to confirm data requirements
• Cross check against Data warehouse (DWH) to confirm data availability or data gaps
• Perform data mapping based on DWH data design and model
• Perform data profiling to identify data quality issues

Outcome/ deliverables:

• Business Requirement Document
• Updated DWH data mapping document and script
• Outputs as per business expectations

Skills Required:

• Good understanding of data warehousing, data modeling, reporting and other relevant technical skills i.e. SQL, HQL, UNIX, Data Warehouse, Teradata, informatica.
• Working experience in Financial & Banking sector

Qualifications:

• Bachelor Degree / Master in IT/Computer Science or related discipline
• 3 years – 5 years Working experience in Data Warehouse banking, BI, reporting tools, data modeling and design and etc or equivalent