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

Vantage

Technical Recruiter Job at Vantage

 ...Job Title: Technical Recruiter Location: Greater Toronto Area (Remote) Reports To: Head of People and Employee Experience About the Role As a Technical Recruiter at Vantage, youll play a crucial role in scaling our world-class team thats building the... 

Contemporary Staffing Solutions

Contract Recruiter Job at Contemporary Staffing Solutions

 ...based on performance and business needs.About Us:Contemporary Staffing Solutions (CSS) is a trusted leader in providing contract,...  ...solutions. With decades of experience, weve grown from a staffing agency to a nationwide provider of workforce management solutions. Our... 

Wyndy

Near 08003 family seeking a reliable nanny for their children. Job at Wyndy

Pay: $17 - $33 per hour Start Date: In 5-7 Days Location: Cherry Hill, NJ Job Description This job is from Sittercity. You'll receive a link to the original job listing when you express interest. We are seeking a reliable babysitter for our toddler as backup...

Senior Helpers - League City

Caregiver/CNA Job at Senior Helpers - League City

 ...interested in personal and professional growthMust have: * At least 6 months experience working as a paid caregiver * Be willing to travel 5-25 miles to League City and other surrounding areas for work * Drivers license Senior Helpers is the nation's premier provider... 

WHO WE ARE AND WHAT WE DO:

Historic Housekeeper Job at WHO WE ARE AND WHAT WE DO:

 ...are required, other days and times vary but will be Monday Friday between 9am and 5pm.WHO WE ARE AND WHAT WE DO:The American Swedish Institute (ASI) is a gathering place for all people to share experiences around themes of culture, migration, the environment, and...