Responsibilities:
- Responsible for monitoring jobs, analyze root cause of any failures, responding to users queries on time with a solution.
- To handle production support – L1 , L2.
- Deploy fixes in production for failures.
- Analyze ITSC cases and deploy fixes for the same in production.
- Manage Incident, production tickets, determine priority and resolution from Level 1 escalation within defined SLA in compliance to client process.
- Perform in depth production incident troubleshooting, resolve any production failures.
- Provide Trend Analysis and root cause analysis on recurring defects.
- Build and update knowledge base from incident and problem tickets.
- Automate manual daily production activities.
- Provide Jobs Status update to management and clients.
- Responsible for End-to-End EDW Production batch support.
- Prepare roaster and manage batch support team.
- Able to study FSLDM Mapping documents and create Transformation rules in Teradata SQL.
- Prepare Test cases for Unit Testing/SIT/Regression.
Requirement:
- Bachelor’s/Master’s degree (or its equivalent) in Information Technologies or related course.
- 8-12 years of experience in relevant field.
- Good knowledge on Data warehouse Concepts.
- Hands on experience in Control M Scheduling tool, Propose design to create and schedule ETL jobs using Control M.
- Good in Unix Shell scripting, writing Teradata SQL, Teradata Utilities.
- Sound knowledge of financial service logical data model (Teradata FSLDM).
- Sound knowledge of Core Banking Domain.
- Able to work in shifts based on roaster, should be available for on call support.
- Able to work 12 hours support, should be available 24/7 on call support.
- Willing to work in Shifts (Morning/Afternoon/Night).
- Good Communication, Flexibility, and commitment.
- Able to take ownership and deliver independently.
Technical Skills:
- Teradata
- FSLDM
- Unix shell script
- Control M
- Banking Domain
- Hadoop, Hive, Spark
Good to Have:
- Teradata Certification
- Cloudera Certification
