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.