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

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

Total Fire Protection

Fire Sprinkler Inspector Job at Total Fire Protection

 ...As a Fire Sprinkler Inspector, you will play a crucial role in ensuring the safety and compliance of buildings and facilities by inspecting, testing, and maintaining fire protection systems. This position requires a strong understanding of fire codes, standards, and regulations... 

Apex Staffing, Inc.

Registered Nurse Clinic Job at Apex Staffing, Inc.

Busy Specialty clinic in North Little Rock has a current job opportunity for a Registered Nurse.Physicians pay for 95% of employee medical benefits!!! Other perks include: catered lunches, quarterly bonuses and 8:00-5:00 clinic hours. RESPONSIBILITIES Provide pre... 

Hickory Mechanical Inc.

Commercial Service HVAC Technician Job at Hickory Mechanical Inc.

 ...sites to perform service and customer support. Diagnose and correct malfunctions on equipment. Comprehensive knowledge of refrigerant troubleshooting. Provide technical feedback on equipment by submitting detailed field service reports. Communicate professionally... 

Desmond HVAC

Commercial Refrigeration Technician Job at Desmond HVAC

 ...Description Desmond Heating & Cooling Solutions is seeking an experienced Commercial Refrigeration Technician to join our team. This is a full-time position serving Delaware, Chester County, Philadelphia, and surrounding regions. Youll work with a locally owned company... 

United States Postal Service (USPS)

City Mail Carrier (CCA) Job at United States Postal Service (USPS)

As a City Mail Carrier, you will be responsible for delivering mail and packages to homes and businesses within designated urban routes. The position requires consistent attention to detail, public interaction, and the ability to work independently under varying weather...