Sênior SQL/Python (4807)

JOB DESCRIPTION

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.

RESPONSIBILITIES AND ASSIGNMENTS

Key Responsibilities:

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

REQUIREMENTS AND QUALIFICATIONS

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.

• 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.

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.

ADDITIONAL INFORMATION

Modelo de contratação:

• PJ.

Forma de atuação:

• 100% Remoto.

SEJAM BEM VINDOS A KEEP SIMPLE 👇🏽

Somos uma empresa de consultoria em TI com mais de 10 anos no mercado e contamos com um time de especialistas em recrutamento tech. Nosso processo é 100% focado na experiência de quem tanto importa, o candidato.

Optamos por fazer a diferença e temos orgulho em dizer que todos que passam pela Keep Simple se sentem especiais. Possuímos um ambiente descontraído, colaborativo, e adotamos o ágil de verdade.

Faça parte da nossa história, #vemprakeep 💙🚀