Database Developer - TSQL, Azure Data Factory,ETL, Python

Job Description

Experience (Years) : 6-8

Essential Skills :

A minimum of 5 years experience with large SQL data marts.

• Expert relational database experience, Candidate should demonstrate ability to navigate through massive volumes of data to deliver effective and efficient data extraction, design, load, and reporting solutions to business partners, Minimum 5 years of troubleshooting and Supporting large databases and testing activities
• Experience in TSQL programming along with Azure Data Factory framework and Python scripting ;
• Financial institution data mart experience is an asset.
• Experience in .net application is an asset
• Experience and expertise in Tableau driven dashboard design is an asset
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using frameworks like Azure Data Factory or Synapse or Databricks;

establishing the cloud connectivity between different system like ADLS ,ADF, Synapse, Databricks etc.

• Identifying reporting, and managing database security issues, user access / management; Designing database backup, archiving and storage, performance tunning, ETL importing large volume of data extracted from multiple systems, capacity planning
• Work well independently as well as within a team
• Proactive, organized, excellent analytical and problem-solving skills
• Flexible and willing to learn, can-do attitude is key
• Strong verbal and written communication skills
• Undergraduate Degree or Technical Certificate.

Requirements

Experience (Years) : 8-10 Essential Skills : Hands-on working experience architecting Guidewire ClaimCenter solutions, including customization and integration.

Guidewire certification is a plus.Other technologies of interest : Guidewire Cloud, Salesforce CRM, legacy modernization, and AWS.

Proven knowledge & architecture experience in, architecture (digital / digital marketing / micro / macro / monolithic services, APIs), application integration, service-oriented architecture, event-driven architecture, application architecture, distributed architecture, data architecture and modelling.

Proven experience with modelling languages & techniques. Can quickly comprehend the functions and capabilities of new technologies.

Can understand the long-term ("big picture") and short-term perspectives of situations. Strong technical background (platforms, languages, protocols, frameworks, open source, etc.

Experience with architecture frameworks (TOGAF) & architecture certifications a plus.Experience in engaging and supporting claims teams and understanding their day-to-day operations in the P&C insurance space.

Open and clear connect with the business, telecom, infrastructure, security, audit, vendors, and software engineering. Driven by challenges and results.

Organized, proactive and a motivation for change.Knowledge on security standard methodologies and understand the impacts it can have on a business.

Comfortable working in a constantly evolving technological environment.An excellent teammate who demonstrates leadership.

Comfortable speaking with all levels of the organization and different audiences.