Lead Assistant Manager/Service Delivery Engineer - Analytics - KPO

Responsibilities:

The Practitioner should be STRONG IN:

- Technical responsibility for maintaining the client Cloud Data Warehouses including data updates, bugs and data fixes

- ETL processes, architecture & working experience in ETL Tool or Similar

- Understanding of Azure Data Factory

- Technical concepts, Analytical and Problem solving skills, with ability to confidently interact with client's Technical Lead/Manager

- SQL queries & working experience in SQL code or Stored Procedures or Functions or Views or Similar

- Development of enhancements to existing client data warehouses such as addition of new data sources

- Potential to get involved with performance tuning, design or architecture of new solutions with Data Warehouse Architects

- Data warehouse working experience of concepts and development using SQL on single (SQL Server, Oracle or Similar) and parallel platforms (Azure SQL Data Warehouse Synapse or Snowflake)

- Database & working experience in any of the database like MS SQL, Oracle or Similar

- Communication (read & write in English), Collaboration & Presentation skills & working experience as team player or Similar

- Prioritizing support incident/request based on the priority/severity

The Practitioner should have BASIC knowledge of:

- Understanding of Spark or Hadoop or Hive (incl. derivatives like pySpark (preferred), SparkScala or SparkSQL) or Similar

- Code Management & working experience in GIT Hub, Azure DevOps or Similar

- Expertise in implementing DevOps practices such as infrastructure as code, continuous integration and automated deployment.

The Practitioner should have working experience of:

Application supports:

- On-call rotation

- Receiving and acknowledging tickets

- Incident triaging and priority assessment

- Assignment of incidents

- Incident resolution

- Application monitoring and preventive maintenance

- Weekly status and SLA reporting

- Incident and problem management:

- Analyse, troubleshoot and resolve complex production application defects

- Identify root cause and devise and implement permanent solutions to recurring defects

- Build and maintain application monitoring, optimisation and utilisation

- Devise or modify programs to solve complex problems considering computer equipment capacity and limitations, operating time, and form of desired results.

- Monitor production ADF jobs and environments