SQL Server & SSIS ETL developer Job at Cloud Analytics Technologies LLC, Warren, NJ

RmdHSGpQYldwdlhxbU9ER2EreWxEeElTa3c9PQ==
  • Cloud Analytics Technologies LLC
  • Warren, NJ

Job Description

Job Details

Title - SQL Server & SSIS ETL developer

Location -  Warren, NJ - Resource should be In person 3 days a week at client office (Hybrid)

Job Description -

Lead and guide developers responsible for ETL development, data pipelines, and data warehouse loads.

Design, develop, and optimize complex SQL queries, stored procedures, functions, and views.

Build and maintain workflows for data ingestion, cleansing, transformation, and transfer using SQL Server Integration Services (SSIS) and SQL.

Demonstrated Experience with Microsoft SQL Server 2019 and above including managing databases.

  1. Demonstrated experience working with Microsoft SSIS to create and deploy packages and deploy for ETL processes.
  2. Demonstrated experience around writing and troubleshooting T-SQL statements, creating stored procedures, views, and SQL functions.
  3. Understands different data models like normalized, de-normalized, stars, and snowflake models.
  4. Strong SQL coding experience with performance optimization experience for data queries.
  5. Ability to multi-task and thrive in fast paced, rapidly changing, and complex environment.
  6. Work with team members to identify and resolve technical issues in a timely fashion.
  7. Analyse problems and communicate with stake holders to assess needs and determine optimal solutions.
  8. Deep understanding of data warehousing concepts
  9. Experience using Azure Devops and CICD pipeline for deployments
  10. Strong understanding of data structures and formats such as JSON and XML and SSIS Scripting.

Job Tags

Work at office, 3 days per week,

Similar Jobs

Collins Mfg

CNC Maintenance Mechanic Job at Collins Mfg

Precision, contract machining business is looking for an experienced Maintenance Mechanic. The primary responsibility of the Maintenance...  ...suchas CNC mills, Lathes, Multi-Axis machine tools and manual shop equipment. DUTIES AND RESPONSIBILITIES: Install, maintain... 

REISS

Sales assistant Part-time BT Limerick Job at REISS

 ...Communicating precisely with customers about goods/services Updating customer information Monitoring inventory Operating cash register/scanner Sales Advisor requirements are: Experience as a Sales Advisor Able to handle customer inquiries and update... 

Vinyl Taco

EXPOs and Line Cooks Job at Vinyl Taco

 ...food, cervezas, margaritas and signature cocktails in a vibrant, music-themed space! We offer Flexible hours & scheduling...  ...Join our team to get your taco fill while filling your wallet! No experience, no problemo! We have an excellent on-the-job training program... 

Garver

Project Manager (Aviation) Job at Garver

Careers Project Manager (Aviation) Frisco, Texas For the last six decades, Garvers Aviation Team has been designing projects for more than 250 aviation clients. Through this experience, Garver understands the complexities of airport systems held together by runways... 

ARA

Administrative Assistant 3 Job at ARA

 ...an energetic, proactive, and detail-oriented Administrative Assistant for our Baton Rouge, LA office to support a multidisciplinary...  ...Canada provide a broad range of technical expertise in defense technologies, civil technologies, computer software and simulation,...