Data Warehouse Support and Enhancement Specialist

Overview

On Site
Accepts corp to corp applications
Contract - Long Term

Skills

Shell Scripting
PLSQL
Control-M

Job Details

Our client is looking Data Warehouse Support and Enhancement Specialist, for a long-term project; in Montreal, QC below is the detailed description of the requirement.

Job Title: Data Warehouse Support and Enhancement Specialist

Location: Montreal, QC

Duration: Long term

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:

1. Technical Leadership and Mentorship:

  • Mentor junior developers, providing guidance, knowledge sharing, and validation of their work.
  • Conduct code reviews and ensure adherence to best practices and coding standards.

2. Incident Management:

  • Act as the primary point of contact (SPOC) for critical incidents (P1 and P2).
  • Resolve incidents that cannot be addressed by Level 1 support and escalate to appropriate teams (CACIB or 3rd parties) when necessary.
  • Assist in building a comprehensive knowledge base (KB) to enable efficient incident response by Level 1 support in the future

3. Problem Management:

  • Analyze recurring issues and propose permanent solutions to address root causes.
  • Collaborate with stakeholders to complete root cause analyses (RCA) and implement corrective measures.

4. 3rd Party and Vendor Coordination:

  • Coordinate with 3rd party technical support teams and manage support tickets effectively.
  • Serve as the subject matter expert (SME) for technical escalations related to Change the Bank (CTB) and problem resolution.

5. Operational Handover and Reporting:

  • Provide detailed daily updates on activities, including shift handovers to ensure continuity.
  • Maintain thorough documentation of processes, changes, and resolutions.

6. Business Requirements Analysis and Development:

  • Work closely with business teams to analyze and understand requirements.
  • Develop and implement code changes to meet business needs, ensuring quality and efficiency.

7. Testing and Validation:

  • Conduct thorough testing of code changes, including functional changes and non-regression testing.
  • Ensure robust quality assurance processes are in place.

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, or Talend) is an added advantage.
Qualifications and Experience:
Proven experience in 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 effectively.
Preferred Attributes:
A proactive mindset with a focus on continuous improvement.
Ability to mentor and inspire team members.
Experience in coordinating with cross-functional teams and external vendors.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.