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

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

Christian Park Village

Certified Nursing Assistant (CNA) Job at Christian Park Village

 ...others. At Ciena Healthcare, we take care of you too, with an attractive benefit package including: ~ Competitive pay ~ Life Insurance ~401K with matching funds ~ Health insurance ~ AFLAC ~ Employee discounts ~ Tuition Reimbursement ~ You will join an... 

Sephora USA, Inc

Beauty Store Leader Inspire Teams & Guest Experience (San Francisco) Job at Sephora USA, Inc

A leading beauty retail company is seeking an Assistant Store Manager for their location in San Francisco, CA. In this full-time role, you will inspire and lead your team while ensuring exceptional client experiences and operational excellence. The ideal candidate should...

Phipps Neighborhoods

SYEP Project Based Learning Facilitator Job at Phipps Neighborhoods

 ...curriculum and activities for 14 and 15-year-old students. Model positive youth development principles in facilitating workshops...  ...communication skills. Must be flexible, enjoy working with teens, and have strong initiative to work in a team. Equal Opportunity... 

McDonald's

Night Shift Managers Job at McDonald's

 ...motivated Restaurant Shift Managers for night shifts, 18 years old and older! Pay range $17.50-$23.00 DOE Boselli & Sons' LLC DBA McDonald's is an Equal Opportunity Employer. Start moving forward safely today McDonald's corporate-owned and franchise restaurants have...