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
...Snap Inc. ecosystem.We're looking for a Senior Manager, Global Agency & Partner Marketing to lead our global B2B strategy for... ...on driving understanding, consideration and adoption of Snap advertising and emerging solutions.You'll lead a small but mighty team, and...
Pizzeria da Laura is expanding and we are looking for experienced pizza makers but more than anything a willingness to learn new techniques. The hours are Wednesday, Thursday and Sunday 1pm-8pm and Friday and Saturday 1pm-9pm The job requires some prep work as well as line...
...leadership for tomorrow. Scope And Responsibilities The Chief Marketing and Branding Officer (CMBO) is a visionary and creative leader... ...its digital and social media presence, and drive compelling content that resonates with diverse audiences. The CMBO will build and...
GUARDIAN ANGEL SENIOR SERVICES is looking for a compassionate Caregiver to join our team in the multiple locations for both shorter & longer hours. T &##128197; How to Apply :Submit your resume now for consideration &##128205; Visit us : 33 Boston Post Road...
...paySafe work environmentMultiple shifts are offered from early morning to night and no experience is needed.You will have adequate opportunity for growthPart-time available - choose the days you wish to workA dedication to promote from withinResponsibilities...