Data Warehouse Support and Enhancement Specialist
Join to apply for the Data Warehouse Support and Enhancement Specialist role at J&M Group
Job Description
Position Overview : We are seeking a skilled and proactive Data Warehouse Support and Enhancement Specialist to join our team. The ideal candidate will be responsible for maintaining, supporting, and enhancing our data warehouse environment. The role involves handling complex incidents, mentoring junior developers, and collaborating with various stakeholders to ensure seamless operations and improvements.
Key Responsibilities
- Technical Leadership and Mentorship : Mentor junior developers, provide guidance, share knowledge, and validate their work. Conduct code reviews and ensure adherence to best practices and coding standards.
- Incident Management : Act as the primary point of contact (SPOC) for critical incidents (P1 and P2). Resolve incidents beyond Level 1 support and escalate when necessary. Assist in building a knowledge base for future incident response.
- Problem Management : Analyze recurring issues, propose permanent solutions, conduct root cause analyses (RCA), and implement corrective measures.
- 3rd Party and Vendor Coordination : Coordinate support with third-party teams, manage support tickets, and serve as SME for technical escalations related to Change the Bank (CTB) and problem resolution.
- Operational Handover and Reporting : Provide daily updates, ensure shift handovers, and maintain documentation of processes and resolutions.
- Business Requirements Analysis and Development : Collaborate with business teams to analyze requirements, develop, and implement code changes ensuring quality and efficiency.
- Testing and Validation : Conduct thorough testing of code changes, including functional and non-regression testing, ensuring quality assurance.
Mandatory Technical Skills
Proficiency in PL / SQL and Sybase SQL for database development and troubleshooting.Expertise in Shell Scripting for automation and operational tasks.Hands-on experience with Control-M for batch job scheduling and monitoring.Proficiency in SQL development tools such as SQL Developer and Rapid SQL.Optional Skills
Familiarity with ETL tools (e.g., Informatica, DataStage, Talend) is an advantage.Qualifications and Experience
Proven experience supporting and enhancing data warehouse applications.Strong problem-solving and analytical skills.Excellent communication and collaboration abilities.Ability to work in a dynamic environment and handle multiple priorities.Preferred Attributes
Proactive mindset with a focus on continuous improvement.Ability to mentor and inspire team members.Experience coordinating with cross-functional teams and external vendors.Seniority Level
Entry levelEmployment Type
ContractJob Function
Information TechnologyIndustries
IT Services and IT Consulting#J-18808-Ljbffr