SQL Developer

Skills:
SQL querying, ETL processes, Performance tuning, Data warehousing, Python (Programming Language), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Snowflake,

Company Overview

iDigilogic is a dynamic IT Company providing innovative solutions in Insurance & Healthcare, technology, and Banking globally. Headquartered in Bangalore, India, with offices in UAE and KSA, the company values inventiveness and serves the evolving global market.

iDigilogic is a dynamic and innovative Information Technology Company with a global presence providing state of the art solutions in the Insurance & Healthcare, technology and Banking industry. We champion the value of inventiveness coupled with a determination and grit to serve the rapidly changing global market.

Established in 2019, our headquarter lies in the IT Capital of India, in Bangalore. We have partnered and extended our services to the world with offices in UAE and KSA

Experience: 4-6 years as a SQL developer

Qualifications And Skills

• Strong knowledge of Advanced SQL Query Writing and Optimization
• Broad knowledge of various database technologies and platforms, such as Microsoft SQL Server, Oracle, MySQL, and PostgreSQL
• Proficiency in Programming languages like Python, Java or C#
• Understanding of data structures, Algorithms and software development principles in essential
• Experience in Database Design and Modeling Data Integration and ETL Processes
• Performance Tuning and Query Analysis
• Understanding of Indexing and Storage Structures
• Database Administration and Security
• Knowledge of SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
• Proficiency in Stored Procedures and Triggers
• Experience with Cloud Database Services (e.g., AWS RDS, Azure SQL Database)
• Knowledge of snowflakes is an added advantage
  
  

Roles And Responsibilities

• Create complex functions and stored procedures
• Analyze queries, develop security protocols, and resolve problems
• Design database architecture and create dashboards
• Write complex queries for applications and business intelligence reporting
• Develop and optimize SQL queries for efficient data retrieval
• Design and implement ETL processes for data integration
• Perform performance tuning on databases for better efficiency
• Create and maintain data warehousing solutions
• Collaborate with teams to analyze and solve data-related challenges