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

Designer Brands (DSW, Camuto Group)

Asset Protection Agent Full-Time Job at Designer Brands (DSW, Camuto Group)

 ...General Summary: TheAsset ProtectionAgent is responsible for protecting the assets of DSW, helping to maintain a safe business environment and monitoring and enforcing associate compliance to Company policies and rules of conduct. You will be responsible for promoting... 

TrueCare

Licensed Acupuncturist Job at TrueCare

 ...Qualifications: Masters Degree from an accredited School of Acupuncture. Graduate of an Acupuncture Therapy, Oriental or Chinese Medicine college accredited by the Accreditation Commission for Acupuncture and Oriental Medicine (ACAOM). Completion of Acupuncture... 

Principle Health Systems

Pain Medicine Physician Job at Principle Health Systems

 ...PAIN MANAGEMENT PHYSICIAN The Pain Management Physician provides specialized medical care to patients experiencing acute or chronic pain, focusing on restoring function and improving quality of life through interventional procedures, rehabilitation, and medication... 

Trojan Roofing

Canvasser - Urgently Hiring Job at Trojan Roofing

 ...Responsibilities for Outside Sales Representative: Prospect, qualify, identify, and close sales opportunities (Territory canvassing, networking, referrals) Manage and maximize sales in assigned territories Perform exterior property inspections with photos... 

New York Life Insurance Co

Corporate Engagement Manager, Corporate Responsibility Job at New York Life Insurance Co

 ...Location Designation: Hybrid - 3 days per week Join Corporate Responsibility , where we are guided by our New York Life values of...  ...volunteer program management, community engagement, or corporate social responsibility. ~ Bachelors degree preferred. ~...