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

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

Instacart

Technical Recruiter Job at Instacart

 ...Technical Recruiter Get a Taste of Instacart Instacart is a hybrid remote team. Most of our roles are open to in-office, flex, or remote work. No matter what you bring to the potluck, theres a seat at the table for you. We celebrate the unique and diverse paths... 

Zaxby's

Cashier Job at Zaxby's

Hungry For A Great Career? To our guests, Zaxbys is more than just a place to eat its a place to have fun, spend some time with friends and experience great food. To our team members, Zaxby's is a family. So come on in! We're saving a seat for you. Cashiers...

Maxlink IT Solutions Pvt. Ltd.

Front End Developer Job at Maxlink IT Solutions Pvt. Ltd.

 ...APIs and JSON # Knowledge of UI/UX design principles and tools (Figma, Adobe XD, Sketch)# Basic understanding of SEO and web performance optimization # Debugging and problem-solving skills using Chrome DevTools or similar # Awareness of frontend build tools... 

Mayflower Cruises & Tours

International Tours Operations Coordinator Job at Mayflower Cruises & Tours

 ...Position Description Job Title: International Tour Operations Coordinator Reports To: International Tour Operations Manager Location: In the Mayflower Cruises & Tours Lisle Office General Overview: Build a career with a global company, with a supportive... 

New York University

Part-Time Associate Research Scientist Job at New York University

 ...an understanding of current topics and debates in technology policy. *** CTP is a practitioner-oriented tech policy think tank at NYU. We work across three main areas: state technology policy, online expression and online safety, and infrastructure and hardware...