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

New Mexico Gas Co - Peoples Gas - Tampa Electric

Lighting Field Inspector Job at New Mexico Gas Co - Peoples Gas - Tampa Electric

 ...Title: Lighting Field Inspector Company: Tampa Electric Company State and City: Florida- Tampa Shift: 8 Hr. X 5 Days POSITION CONCEPT Responsible for monitoring and evaluating newly constructed, converted, and maintained lighting services... 

Dignity Health

Nutrition Assistant Job at Dignity Health

**Job Summary and Responsibilities**As our Nutrition Assistant, you will interact daily with patients, families, visitors, and staff. You understand that most guests at our facility dine with us for a reason, and take great pride in giving them one less thing to worry... 

Advanced Functional Medicine

Lead Acupuncturist Job at Advanced Functional Medicine

 ...Senior Acupuncturist Advanced Functional Medicine of Austin / 360 Jasmine Acupuncture & Wellness Center Position Overview We are seeking an exceptional Senior Acupuncturist with extensive clinical experience and advanced expertise in traditional Chinese medicine... 

GreatAuPair LLC

Nanny Job at GreatAuPair LLC

 ...looking for someone to look after him while he is not in school, in addition to cleaning and maintaining the household. 3+ years of experience with children is mandatory. Duties include: Feeding our son Walking him to school (to and from) Playing with him Bathing him... 

J&J Family of Companies

Senior Sales Consultant - North Chicago - Johnson & Johnson MedTech, Orthopaedics Job at J&J Family of Companies

At Johnson & Johnson,we believe health is everything. Our strength in healthcare innovation empowers us to build aworld where complex diseases are prevented, treated, and cured,where treatments are smarter and less invasive, andsolutions are personal.Through our expertise...