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
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 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 Skills Required:
Good understan...