Senior Database Engineer

Mitra AI; India; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

A technology firm in India is seeking a data analyst proficient in data modeling, advanced SQL, and Azure services. The role focuses on supporting analytics initiatives while ensuring data quality and optimizing performance. Ideal candidates will have experience with SSIS and version control concepts. This position offers opportunities for professional growth in a collaborative environment.

Qualifications

• Experience with data analysis and modeling, including ERD and cardinalities.
• Proficient in Azure services and integration techniques.
• Strong skills in performance tuning and data governance.

Responsibilities

• Support reporting and analytics initiatives.
• Ensure data quality and optimize performance.

Skills

Advanced SQL

Data Warehousing

Azure services

Performance Tuning

Version Control Concepts

Change Data Capture

Event-Based Integrations

APIs

Performance Tuning

MS Dynamics (Nice to have)

Tools

SSIS

MS Dynamics

Azure Data Lake (ADLS)

Job description

• Data Analysis and Data Models- ERD, Cardinalities, PF-FK Relationships, Indexes, Hints, Views,SPs,Functions
• Data Warehousing and Marts - Dimensions and Facts, Change Data Capture, Metadata etc
• Advanced SQL
• Azure services - ADLS, Containers, DataSets,Logic and Function Apps,Basic scripting knowledge,Event Based Integrations, Knowledge of APIs
• SSIS - Data Flow, Packages, Scheduling,
• Performance Tuning Techniques, Source to Target Mappings, Simple and Complex Data Sources like .txt,.csv,.xml,.json,.parquet,tables etc, Version Control Concepts, GitHub
• Nice to have:MS Dynamics

Typical activities include

• Supporting reporting and analytics
• Ensuring performance, scalability, and data quality