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

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

ABB

Master Electrician, Compliance Qualifier, ABB Robotics US Job at ABB

 ...t always be easy, growing takes grit. But at ABB, you'll never run alone. Run what runs the world. This role sits within ABB's Robotics business, a leading global robotics company. We're entering an exciting new chapter as we've announced the plan for SoftBank Group... 

Providence Health and Services

Telemetry Technician Job at Providence Health and Services

 ...supervision of Registered Nurses in a hospital telemetry unit, serving as a critical communication link regarding cardiac rhythm changes. The role requires specialized training in medical terminology, basic ECG, and BLS certification, and offers comprehensive benefits... 

IDR

HRIS Analyst Job at IDR

 ...IDR is seeking an HRIS Analyst to join one of our top clients in Louisville, KY. This role offers a unique opportunity to work onsite...  ..., sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. IDR is subject to certain governmental... 

Aequor Allied

Travel Occupational Therapist - Critical Need Job at Aequor Allied

 ...Job Description Aequor Allied is seeking a travel Occupational Therapist for a travel job in Clackamas, Oregon. Job Description & Requirements ~ Specialty: Occupational Therapist ~ Discipline: Therapy ~ Start Date: ASAP ~ Duration: 13 weeks ~40 hours... 

Northeast Healthcare Recruitment

Urgent Care Nurse Practitioner/Physician Assistant - 4 day work week Job at Northeast Healthcare Recruitment

 ...Job Description Job Description Opportunity for a full time, employedUrgent Care Nurse Practitioner or Physician Assistant to join an established practice in Lincoln, NH.This practice has a strong patient following allowing the new provider theability to ramp up quickly...