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
...Attention Metairie Truck Drivers! OTR CDL A Tank Truck Solo Drivers needed to haul liquid bulk general hazmat products across 48 states. Positions Available: Company = Up to $0.68 a practical mile (loaded and empty + supplemental pay) or Median $1,650 Per Week....
...American Generator Services is hiring Experienced Repair Technicians! Starting hourly rates from $23 - $38, depending on experience We specialize in repairing, maintaining, and installing backup generators for large organizations, including hospitals, commercial...
Overview How Youll Make an Impact The Senior Leader, Client Leadership will be responsible for cultivating strong client partnerships within the retail vertical, driving revenue growth, and delivering exceptional client experiences across Epsilon's data, tech...
...RUIAN YUEMEI (CH PPCN DANCE STUDIO) focuses on international dance education, creating opportunities for students to learn from world-class... ...kids (4-16 years old) Jazz or Hip-hop.2/ Dance, performing arts or similar major (if not in these majors, you should have professional...
...during our years working in assisted living facilities, home care agencies, home health agencies and skilled nursing facilities, we have a... ...(2+ years certified nurse, home health aid preferred)* CNA, HHA, or PCA certification preferred* Ability to lift and/or...