Job Description:
The support specialist will be a techno functional support team member for the Enterprise Datawarehouse (EDW) under IT BAU team.
He/she is responsible for ensuring system availability and timely deliverables for datamarts for various business unit like Finance, regulatory, Campaign.
The support specialist, as the analyst expert within the IT team, will be the support staff who needs to closely co-ordinate and work with various team like Tech Infra, application services, solutioning, project and business units in the bank. He/she follows up to resolve issues
Requirements:
Responsible to provide BAU support for Enterprise Datawarehouse
Responsible to provide operational support and ensure SLI of system availability, batch deliverables
Respond on time to the queries raised by various business units
Provide timely updates regarding production status and progress of issue resolution
Fine tune applications and systems for high performance and higher volume throughput
Conduct review of technical and functional solutions from enhancement/project team to ensure they conform to IT standards
Perform impact analysis of enhancements/projects that will impact supported systems
Identify the underlying problems, analyse the root causes, provide possible solutions/fixes, and respond to users within SLA
Support relevant software/platform/database upgrade for the systems
Work with delivery team for smooth transition from projects/enhancements to BAU Mode
Incident, problem, and service outage management experience
Participate in Disaster Recovery and Business Continuity exercises
Able to support relevant software/platform/database upgrade for the systems
Server Performance, capacity, utilization monitoring and Health monitoring
Collaborate with diverse cross functional teams within IT and Business to Independently drive outcomes
At least 3+ years of relevant experience in banking/financial services industry
Experience with Teradata FSLDM and data mapping
Hands-on technologist, strong in SQL, UNIX and Teradata tools and technologies
Experience in designing high throughput fault tolerant data pipelines for Batch (ETL/ELT)
Experience in GL Data reconciliation between systems, datamarts & report and Knowledge of the ledger balance reporting is an added advantage
Experience in Performance Tuning on Teradata or other MPP data pipeline.