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

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

Factory Direct Marine & RV - GA

Fiberglass Boat Manufacturing Manager Job at Factory Direct Marine & RV - GA

 ...planning, resource allocation and human resources)Familiarity with industry standard equipment and technical expertiseBe knowledgeable of...  ...50+ year old manufacturer of fiberglass and aluminum runabout, fishing, deck and performance boats, located in Southwest GA. We pride... 

Warren Transport, Inc.

FLEET MANAGER Job at Warren Transport, Inc.

SUMMARY The Fleet Manager is responsible for balancing the needs of drivers and maximizing production, by being held accountable for all aspects of service once dispatched on a load. To ensure high quality and profitable operation of the division by coordination the personal... 

DATTCO

RIDE Van Driver Job at DATTCO

 ...Additional hours may be available.~Weekend and holiday breaks.~No long distance trips. Be home every night.~401k with company match.~...  ...vehicle inspections.Requirements:~21+ years old~Valid driver's license~3 years driving experience~Read and speak... 

Mains'l

Onboarding and Credentialing Specialist Job at Mains'l

 ...Mainsl is seeking an Onboarding and Credentialing Specialist . This role will play a crucial role in supporting the setup and ongoing credentialing...  ...applicants. Salary: $53,560 annually Work schedule: Remote/Hybrid- there will be in office training, work time, and... 

BOEING

Associate Manufacturing Operations Analyst Job at BOEING

 ...Candidates must live in the immediate area or relocate at their own expense. Travel: Position may require travel up to 10% of the time. Drug Free Workplace: Boeingis a Drug Free Workplace where post offer applicants and employees are subject to testing for...