Sênior SQL/Python (4807)

Descrição da vaga

Come work for a large global financial and insurance products company! This is your chance !!

Start a successful career in a renowned company in the international market! Great opportunity!

Global insurance and asset management company seeks a responsible, organized, dynamic and team-oriented person.

Responsabilidades e atribuições

Key Responsibilities

• Development and support of code on SSIS and write new code on Python for Klondike teams.

Requisitos e qualificações

Required Qualifications / Skills

• Database: MS SQL, Azure,AWS;
• Tools : SSIS, SSRS, AI Tools;
• Languages: SQL, T-SQL,Python;
• Desired Experience Range 5+ years.

Data Development (Must have)

• SQL Server 2017/2019/2022 DBA/Developer 5+ years;
• Strong development background in SQLserver and some SSIS ,stored procedures, Python - this is mostly a development role;
• AWS/Azure Cloud experience considered a plus;
• Work with operational and data warehouse systems;
• Strong communication skills;
• Self-Starter and flexibility with work hours and work direction;
• Experience with AI code generators for PowerShell and SQL ,oracle databases considered a plus.

Data Development - SQL Server Developer with extensive familiarity with data management principles including:

• Development of high quality database solutions;
• Develop, implement and optimize stored procedures and functions using T-SQL;
• Understand data dimensional models;
• Write or troubleshoot Stored Procedures, Functions, Views, Triggers etc;
• Review and interpret ongoing business report requirements;
• Research required data;
• Build appropriate and useful reporting deliverables;
• Analyze existing SQL queries for performance improvements;
• Suggest new queries;
• Develop procedures and scripts for data migration;
• Provide timely scheduled management reporting;
• Investigate exceptions with regard to asset movements.

Development and QA Support -

• Detailed knowledge of T-SQL, SSIS packages and knowledge of SQL Server Reporting Services;
• Experience with Python coding;
• Develop and analyze SQL Server Code objects such as Stored Proc, View, Function , Trigger etc and identify defects and recommend for performance tuning;
• Experience of Transactional SQL, and SSIS Package;
• Code version management, Code deployment to various databases.

Problem-solving skills – SQL Server Developer should be skilled creative and technical problem-solvers, able to isolate and resolve database issues in real time to maintain access and data integrity.

Communication Skills

• Respond to issues in timely manner, clearly elaborate problem and propose solution;
• Communicate with application teams, listen and respond to their queries and concerns.

Knowledge to additional technologies (Good to Have)

• AWS exposure (S3, RDS, EC2);
• Oracle PL/SQL;
• Informatica Development;
• Workload automation;
• Service Now and Change Management Process.

Informações adicionais

Modelo de contratação

• PJ.

Forma de atuação

• 100% Remoto.