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.

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.