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

Y2N2eCtybUtUb1h1ckpzeHpST1JHdnlzb3c9PQ==
  • 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

WALGREENS

Senior Analyst HRIS Job at WALGREENS

Senior Analyst HRIS Location Deerfield, IL : Job Summary: The HR Information Systems Sr. Analyst is a member of the HRIS (Human Resources Information Systems) team within the HR Operations CoE (Center of Excellence) at Walgreens. The Sr. Analyst will partner with... 

TechFlow, Inc.

Cloud Engineer Job at TechFlow, Inc.

 ...is thrilled to offer an immediate opportunity for a visionary Cloud Engineer to join our team at Maxwell AFB-Gunter Annex, AL. This...  ...providers such as Microsoft Azure, AWS (Amazon Web Services), and Google Cloud Platform. Proficiency in managing, configuring, and optimizing... 

LaGuardia Community College

Assistant Professor - Political Science Job at LaGuardia Community College

 ...Resources Department at (***) ***-**** or email the Benefits Administration team at ****@*****.*** Assistant Professor - Political Science Date Posted: January 05, 2026 Job ID: 31564 POSITION DETAILS: Assistant Professor - Political Science... 

NTT DATA, Inc.

Helpdesk Senior Associate - French Job at NTT DATA, Inc.

 ...thinking organization, apply now. We are currently seeking a Helpdesk Senior Associate to join our team in Guadalajara, Jalisco,...  ...a Help Desk Senior Associate FRENCH - Full Time Location: Remote (candidate MUST LIVE IN GUADALAJARA) Requirements: Availability... 

Exciting Travel Now

Africa Safari Coordinator Job at Exciting Travel Now

 ...an Africa Safari and Cultural Experience Planner with Exciting Travel Now, youll create meaningful journeys that stay with travelers...  ...Responsibilities: Coordinate wildlife tours, guided safaris, and luxury lodge accommodations. Partner with trusted safari...