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

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

NCCF

Evenings & Weekend Trauma Crisis Counselor Job at NCCF

A youth support organization is seeking a Trauma Specialist to provide on-call interventions during evenings and weekends. The role requires responding to youths in crisis, employing trauma-informed practices, and maintaining communication with relevant teams. Candidates...

Ward Agency

Licensed Insurance Agent Job at Ward Agency

 ...Implementing strategies to sell insurance ~ Building rapport with customers ~ Getting details from customers to fully assist them ~...  ...Sales Representative requirements are: ~ Life Insurance License or willing to obtain ~ Experience within this field (... 

Woodfield Country Club

Housekeeping Attendant Job at Woodfield Country Club

 ...areas.The Attendant tends to industrial laundering machines to clean articles such as table linens, tablecloths, towels, wiping,...  ...clothes by performing the following duties. Must be able to work Weekends and Holidays. ESSENTIAL DUTIES & RESPONSIBILITIES include... 

Sigma Defense

1602 - Senior ATGPAC Training Requirements and Policy Analyst Job at Sigma Defense

 ...Defense is seeking a Senior ATGPAC Training Requirements and Policy Analyst to join our team at San Diego NB, CA. Equal Opportunity Employer...  ...afloat training and managing ships routine at a senior level. For example: Commanding Officer, Task Group/Squadron Staff position... 

Charlotte FC

Graphic Designer Job at Charlotte FC

 ...JOB TITLE: Graphic Designer DEPARTMENT/GROUP: Creative Content / Marketing Latest Videos next stay REPORTING RELATIONSHIP...  ...Charlotte Football Club is seeking a talented Graphic Designer with experience producing graphics for digital and printing publications....