Zigsaw

Ahmedabad Group Ahmedabad Negotiable

Job purpose :

Design & implement the best engineered technical solutions using latest technologies and tools.

Who you are :

Extensive database programming 3 years experience in writing T-SQL Stored procedures, Functions, Triggers, Constraints, and Indexes using various DDL and DML commands.
1-year Experience in Design, build and deploy effective SSIS packages.
Understanding Development of Mappings according to the ETL Specifications for the Staging Area Data Load & destination Data Load Developed and implemented ETL Processes by using SSIS to move data from different sources to targets
Experience with building development in Azure cloud environment, Azure data factory (ADF), and SQL Server integration service (SSIS).
Good Hands-on experience in developing SSAS tabular models.
In-depth understanding of database management systems, Online analytical processing (OLAP), and ETL (Extract, transform, load) framework.
Proficient understanding of database concepts, data profiling, and data validation, dimensional modeling.
Independently analyze and correct issues in real-time, providing end-to-end problem resolution.
Refine and automate regular processes, track issues, and document changes.
Important Skill Sets : T-SQL, SQL Server integration service (SSIS),Azure cloud environment, Azure data factory, SQL Server Analysis Service (SSAS),ETL (Extract, transform, load),Online analytical processing (OLAP),Functions, Triggers, Indexes, Stored procedures

What will excite us :

Proven working experience on working with various relational and non-relational databases
Experience with building database systems of high availability and quality
Design and implement database in accordance to end user’s information needs and views
Perform tests and evaluations regularly to ensure data security, privacy and integrity
Strong experience in various normalization techniques
Experience with third-party libraries and APIs
Proficient understanding of code versioning tools, such as Git

What will excite you :

Experience : 3 years