SQL Developer

Job Summary

A company is looking for a SQL Developer.

Key Responsibilities

• Analyze denormalized data in Salesforce.com and create a normalized data structure in SQL Server for reporting
• Design and build data loads using Salesforce UPSERT capabilities and create SQL Server stored procedures for data aggregation and cleansing
• Troubleshoot ETL processes and perform data quality analysis for consistency between Salesforce.com and on-premise systems

Required Qualifications

• Strong SQL development skills with experience in SQL Server
• Familiarity with Salesforce data conventions and APIs
• Experience in creating production-level code, including effective keys and constraints
• Knowledge of Salesforce concepts such as master/detail relationships and validation rules
• Ability to analyze business rules and write SQL statements for data quality checks