Job Description
JOB SPECIFIC DUTIES & RESPONSIBILITIES
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
Analyzing Salesforce data models
Designing Dynamics-compatible schemas
Building ETL pipelines (SSIS + Azure)
Handling incremental syncs
Supporting reporting and analytics
Ensuring performance, scalability, and data quality
Integrating CRM with downstream systems
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
Analyzing Salesforce data models
Designing Dynamics-compatible schemas
Building ETL pipelines (SSIS + Azure)
Handling incremental syncs
Supporting reporting and analytics
Ensuring performance, scalability, and data quality
Integrating CRM with downstream systems