Senior MS SQL Database Developer

Job Title: - Senior MS SQL Database Developer

Location: - Alpharetta, Georgia

Duration: - 6+ months

Experience: - 8+ years

Responsibilities:

Data acquisition and ingestion - Identify data sources and build pipelines using various ETL tools such as but not limited to, SSIS, and Alteryx. Data sources including but not limited to SQL Server, SAP, Teradata, Hadoop\Hive, PostgreSQL, Oracle and flat files.

Identifying ways to improve data reliability, efficiency and quality by various data solution techniques.

Expertise in Data project management with JIRA stories.

Work as a liaison between business and IT to ensure successful and timely completion of the projects.

Assist in defining the data architecture framework, standards and principles, including modeling, metadata, security and reference data.

Create and optimize data models to support various business applications.

Reviewing modifications of existing data systems for cross-compatibility.

Automate and support workflows to ensure timely delivery. Must Have

5+ years of SQL Server development experience

3+ years ALTERYX Admin /User management experience and advance workflow management.

5+ years data modeling experience.

5+ years of ETL experience.

5+ years of experience in working on more than one database technologies Microsoft SQL server, Teradata.

2+ years big data experience, Hadoop, Hive, Spark

Expert knowledge of data warehousing.

DESIRED SKILLS

BI Lifecycle management

Working understanding of Microsoft VBA, HTML, Python

Data model development using ERWIN