Data Engineer (EDW, Datawarehousing, Banking)

About the role

• The support specialist will be a techno functional support team member for the Enterprise Datawarehouse (EDW)
• 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 reported by users and performs impact analysis related projects/enhancements that will impact the EDW.
  

Responsibilities & 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
• Hands On Experience within the Hadoop Tool Sets Hive, Hue, Spark, Kafka is a plus