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

Challenges:
 Understanding of business demand and target objectives
 Familiarity to the DWH data model and data mapping document

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 equivalen