Sênior SQL/Python (4807)
Vaga nacionalContratação no Brasil (CLT/PJ)Sobre a 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.
Key Responsibilities:
* Development and 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;
* 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.
Modelo de contratação:
* PJ.
Forma de atuação:
* 100% Remoto.
