Lead SQL Server SSIS ETL developer - Basking Ridge, NJ (Onsite) Job at SMART CALIBER TECHNOLOGY, Basking Ridge, NJ

ZnZvRnNvazBZVzJySmNlQWhvZ1pZeVRQeUE9PQ==
  • SMART CALIBER TECHNOLOGY
  • Basking Ridge, NJ

Job Description

Role Name: Lead SQL Server ETL developer

Location: Basking Ridge, NJ (Onsite)

Duration: 6+ Months



JOB DESCRIPTION:
1. Lead and guide developers responsible for ETL development, data pipelines, and data warehouse loads.
2. Design, develop, and optimize complex SQL queries, stored procedures, functions, and views.
3. Build and maintain workflows for data ingestion, cleansing, transformation, and transfer using SQL Server Integration Services (SSIS) and SQL.
4. Demonstrated Experience with Microsoft SQL Server 2019 and above including managing databases.
5. Demonstrated experience working with Microsoft SSIS to create and deploy packages and deploy for ETL processes.
6. Demonstrated experience around writing and troubleshooting T-SQL statements, creating stored procedures, views, and SQL functions.
7. Understands different data models like normalized, de-normalized, stars, and snowflake models.
8. Strong SQL coding experience with performance optimization experience for data queries.
9. Ability to multi-task and thrive in fast paced, rapidly changing, and complex environment.
10. Work with team members to identify and resolve technical issues in a timely fashion.
11. Analyse problems and communicate with stake holders to assess needs and determine optimal solutions.
12. Deep understanding of data warehousing concepts
13. Experience using Azure Devops and CICD pipeline for deployments
14. Strong understanding of data structures and formats such as JSON and XML and SSIS Scripting.

Best Regards,

Vishal

vishal@smartcaliber.com

Truth Lies in Heart

Job Tags

Similar Jobs

K'Far - Brooklyn

AM Server Job at K'Far - Brooklyn

 ...professional to join the team with K'Far! Meaning village in Hebrew, KFar is an Israeli restaurant, bar, and caf inspired by the food, energy and warmth of Israeli bakeries. Following the smashing success of their first collaboration, Laser Wolf - Brooklyn,... 

Acadian Ambulance Service

Contracts Manager Job at Acadian Ambulance Service

 ...Acadian Companies JOB DESCRIPTION Job Title: Contracts Manager Alternate Job Title(s): N/A Division/Department: Risk Management Status: Exempt Performance Appraisal Type: Support JOB SUMMARY: Engage directly with EVPs, VPs, RVPs,... 

Banner Health

Physician Recruitment Coordinator Job at Banner Health

**Department Name:**Provider Recruitment-Corp**Work Shift:**Day**Job Category:**Human Resources**Estimated Pay Range:**$23.16 - $...  ...fun collaborative environment focused on finding and onboarding Physician and APP's.In this position you will be working with high... 

Wells Fargo

2026 Corporate & Investment Banking Associate Program (California) - Early Careers Job at Wells Fargo

2026 Investment Banking Associate ProgramWells Fargo Corporate & Investment Banking delivers a comprehensive suite of capital markets, banking, and financial products and services to over 12,000 clients around the world, including over 90% of the S&P 500.A trusted partner... 

Sony Music Entertainment

Manager, Strategy & Initiatives Job at Sony Music Entertainment

About Sony Music EntertainmentAt Sony Music Entertainment, we fuel the creative journey. We've played a pioneering role in music history, from the first-ever music label to the invention of the flat disc record. We've nurtured some of music's most iconic artists and...