Senior Database Engineer

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
• Ensuri...