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

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

Unger Construction

Construction Project Superintendent Job at Unger Construction

 ...include close vision, distance vision, peripheral vision, and depth perception. Reasonable accommodations may be made available to individuals with disabilities. Reporting to this Position ~ May oversee Apprentices, Laborers, and Field Personnel as required.... 

DeSanti

Electrical Engineer IV - Sustainability Job at DeSanti

 ...sustainability projects in accordance with District and program policies and procedures for College construction bond operations....  ...electrification initiatives. Apply knowledge of energy and environmental sustainability approaches, such as LEED credits, and its related... 

The Planet Group

Waste Project Manager Job at The Planet Group

 ...Title: Waste Project Manager Location: Chicago, IL 60633 Direct Hire Starting Pay: Up to 80k depending on experience Excellent...  ...dental, vision, 401k match Our client is looking for a entry level Project Manager to manage a large quantity waste generator facility... 

Slab Concrete

Lead Carpenter Job at Slab Concrete

Company Description We suggest you enter details here. Role Description This is a full-time, on-site Concrete Lead Carpenter role located in Salt Lake City Utah. The Lead Carpenter will be responsible for overseeing and executing carpentry projects, including ...

BlackRock Resources LLC

LNG Project Manager Job at BlackRock Resources LLC

Job Title: LNG Project Manager Location: Bridgeport, WV Type: Contract + (W-2 benefits, PTO, 401(k), paid holidays) Industry: Oil & Energy Travel: Up to 25% Summary The Project Manager will lead and support capital projects across interstate natural...