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

Assured Nursing

Travel Medical Laboratory Technician Job at Assured Nursing

 ...Job Description Assured Nursing is seeking a travel Medical Lab Technician for a travel job in Aspen, Colorado. Job Description & Requirements...  ...Type: Travel Assured Nursing is currently seeking a Laboratory for a contract position in Aspen Colorado . This is a 7a... 

Village Caregiving, LLC

Caregiver 15 Hours Per Week Job at Village Caregiving, LLC

 ...is looking for compassionate caregivers, STNAs, CNAs, and Home Health Aides to join our team in Omaha Nebraska and Council Bluffs 15 hours per week. Why Village Caregiving? We understand the importance of supporting our caregivers with more than just a paycheck. Here... 

Family Health Centers of San Diego

Family Practice - Without OB Physician Job at Family Health Centers of San Diego

 ...Family Practice - Without OB Physician at Family Health Centers of San Diego summary: The Family Practice Physician at Family Health...  ..., differential diagnosis, etc., in order to facilitate health promotion and disease prevention. Meets clinic site and organization... 

MCI

Inbound Customer Service Representative (Tolling) Job at MCI

 ...focus on innovation, we have established ourselves as a trusted partner in the industry. We are looking for Customer Service Representatives to support inbound customer service. In this role, you will handle inbound inquiries, troubleshoot customer disputes, process... 

HouseSitter.com

House Sitter Wanted - Am Hoping To Find Someone Ready To Work Heart To Heart, Committed. I'm Flexible. $175 Job at HouseSitter.com

 ...looking for a reliable, respectful, and trustworthy individual to house sit while am far away. This is a serious opportunity for someone...  ...they would their own.Duties include:931Keeping the home clean and secureBringing in mail/packages208Communicating with us...