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

NBC Universal

NEWS Podcast Producer Job at NBC Universal

NBCUniversal is one of the world's leading media and entertainment companies. We create world-class content, which we distribute across...  ...and news brands, including NBC, NBC News, MSNBC, CNBC, NBC Sports, Telemundo, NBC Local Stations, Bravo, USA Network, and Peacock,... 

CORA Physical Therapy

Athletic Trainer - Clinical Job at CORA Physical Therapy

 ...Athletic Trainer (Full-Time/Part-Time/PRN) Grow Your Career. Make a Difference. Thrive in Outpatient Care. Looking to build a meaningful career as an Athletic Trainer (ATC)? At CORA Physical Therapy , we empower our clinicians with tools, support, and flexibility... 

Hagan Staffing

Sales Assistant & Amazon Support Job at Hagan Staffing

 ...communication. As a proactive member of our team, youll deliver timely follow-ups, while building strong relationships to create a...  ...via phone and email. Oversee customer support activities on Amazon or comparable e-commerce platforms, ensuring timely resolution of... 

Airtasker

General Worker Job at Airtasker

General Tasker Earn extra income on your terms! Join Airtasker, the community platform connecting people ready to work with those who need jobs done. With Airtasker, you decide when and where you work-choose tasks that match your skills, set your own rates, and work... 

Knox College

Head Football Coach Job at Knox College

 ...Knox College invites applications for the full-time position of Head Football Coach a 12-month benefits-eligible position reporting to the Director of Athletics. Anticipated start date is January 2025. The Head Football Coach will be an essential leader in advancing...