Sênior SQL/Python (4807)

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.

Key Responsibilities:

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

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;
• Strongdevelopment background in SQLserver and some SSIS ,stored procedures, Python -this is mostly a development role;
• AWS/AzureCloud experience considered a plus;
• Workwith operational and data warehouse systems;
• Strong communication skills;
• Self-Starterand flexibility with work hours and work direction;
• Experience with AI code generators forPowerShell 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 reportingdeliverables;
• Analyze existing SQL queries for performanceimprovements;
• Suggest new queries;
• Develop procedures and scripts for datamigration;
• Provide timely scheduled management reporting;
• Investigate exceptions with regard to asset movements.

Developmentand QA Support -

• Detailed knowledge of T-SQL, SSIS packages and knowledge of SQL Server Reporting Services;
• Experience with Python coding;
• Develop and analyze SQL ServerCode objects such asStored Proc, View, Function , Trigger etc and identify defects andrecommend for performance tuning;
• Experience of Transactional SQL, and SSIS Package;
• Code version management, Codedeployment to variousdatabases.

Communication Skills:

• Respond to issues in timely manner, clearly elaborateproblem and proposesolution;
• Communicate with applicationteams, listen and respondto their queries and concerns.

Knowledge toadditional technologies (Good to Have):

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

Informações adicionais

Modelo de contratação:

• PJ.

Forma de atuação:

• 100% Remoto.