EDSO Data Operation Developer

Responsible for the day-to-day maintenance of the application systems in operation, including tasks related to identifying and troubleshooting application issues and issues resolution or escalation. Responsibilities also include root cause analysis, management communication and client relationship management in partnership with Infrastructure Service Support team members. Ensures all production changes are made in accordance with life-cycle methodology and risk guidelines. Responsible for coaching and mentoring less experienced team members and or acting as a subject matter expert. In depth Functional knowledge of the application(s) supported and inter dependencies.

Key Responsibilities 

This includes but are not limited to:

• Knowledgeable in SQL ANSI
• Knowledgeable in deployment, stabilization, supporting 1 of the following.

- ETL Tools (Informatica, DBT and like)

- Dashboard (Tableau, AWS Quicksight and like)

- Messaging Tool (Confluent, Kafka and like)

- Machine Learning (CDSW, CML and like)

- Database (Snowflake, RDBMS and like)

• Can create processes and procedures to improve manual processes by operationalization.
• Has good documentation skills for Root Cause Analysis (RCA)

Scope and responsibilities:

1. Advanced Troubleshooting: L2 support teams possess a deeper understanding of ETL systems and processes, allowing them to investigate and resolve more complex issues that may arise. This includes analyzing log files, examining database performance metrics, and tracing data flow to identify root causes of problems.

2. Incident Resolution: L2 support teams are responsible for resolving incidents that cannot be addressed at the L1 level. They may work closely with development teams or external vendors to implement fixes or workarounds for issues affecting ETL processes.

3. Performance Tuning: L2 support teams focus on optimizing the performance of ETL jobs and processes to ensure efficient data extraction, transformation, and loading. This may involve tuning database queries, optimizing ETL workflows, or recommending infrastructure upgrades to improve system throughput and reduce processing times.

4. Capacity Planning: L2 support teams monitor resource utilization and system capacity to anticipate and mitigate potential bottlenecks in ETL processing. They may provide recommendations for scaling infrastructure or adjusting job schedules to accommodate growing data volumes or changing business requirements.

5. Change Management: L2 support teams participate in the change management process to review and approve proposed changes to ETL systems and configurations. They assess the potential impact of changes on production environments and ensure that proper testing and validation procedures are followed before implementing updates.

6. Knowledge Sharing and Training: L2 support teams contribute to the development of knowledge base articles, best practices, and training materials to empower L1 support teams and other stakeholders with the skills and information needed to effectively manage and support ETL processes.

High level Requirements

This includes but are not limited to:

• Excellent problem-solving skills and documentation skills.
• Proven customer service skills.
• Familiarity with Information Technology Infrastructure Library (ITIL) methodologies.
• Good communication skills (verbal and written) and the ability to work within a 24x7 support environment.