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

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

CBH Care

Partial Care Specialist Job at CBH Care

 ...bodies (Medicaid, NJ Division of Mental Health Services) Observes consumers self-administration of prescribed medication, as per agency procedures Qualifications: BSW in social work, BS/BA in psychology, or a related field Valid New Jersey drivers license... 

Manpower

Recruiter Job at Manpower

 ...career conversations, and other tools designed to guide self-discovery, we'll help you become an expert in the in-demand world of Recruiting and forge a career path that's right for you. All while: Working with our exceptional clients. From Fortune 500 clients to... 

MY DR NOW

Payroll Accountant Job at MY DR NOW

 ...Tired of companies that promise growth but never deliver? Welcome to MY DR NOW where ambition is rewarded, fun is mandatory, and stability is real. Why Youll Love It Here: This isnt corporate accountingits entrepreneurial accounting. We move fast, think big,... 

The Kasper Group

Colorist Job at The Kasper Group

 ...The Kasper Group is an apparel industry leader, offering women wardrobe solutions for their wear-to-work and special occasion dressing needs. Driven by excellence and exceptional talent, The Kasper Group has remained a forerunner in fashion for over 30 years. We are... 

LHH

Purchasing Manager Job at LHH

 ...LHH is supporting a long-standing Pacific Northwest based organization that is hiring a Purchasing Manager to lead a small team and elevate their company-wide purchasing function. This is a hands-on leadership position responsible for overseeing buying activities, improving...