Senior ETL Developer

Company Description

BETSOL is a cloud-first digital transformation and data management company offering products and IT services to enterprises in over 40 countries. BETSOL team holds several engineering patents, is recognized with industry awards, and BETSOL maintains a net promoter score that is 2x the industry average.

BETSOL’s open source backup and recovery product line, Zmanda (Zmanda.com), delivers up to 50% savings in total cost of ownership (TCO) and best-in-class performance.

BETSOL Global IT Services (BETSOL.com) builds and supports end-to-end enterprise solutions, reducing time-to-market for its customers.

BETSOL offices are set against the vibrant backdrops of Broomfield, Colorado and Bangalore, India.

We take pride in being an employee-centric organization, offering comprehensive health insurance, competitive salaries, 401K, volunteer programs, and scholarship opportunities. Office amenities include a fitness center, cafe, and recreational facilities.

Learn more at betsol.com

Job Description

Primary responsibilities:

• Design and implement ETL pipelines using Azure Data Factory to meet business requirements. This includes creating data flows, handling complex transformations, and automating data ingestion from various sources such as SQL databases, flat files, and cloud storage. 
• Manage structured and unstructured data by utilizing Azure Data Lake Storage and Azure SQL Database. Ensure data integrity and optimize data models based on business logic.
• Monitor and optimize the performance of ETL processes. Implement best practices for data processing and storage to enhance efficiency.
• Work closely with business stakeholders to gather requirements and translate them into technical specifications. Participate in design discussions and ensure timely delivery of solutions.

Primary Skills:

• 4–6 years of experience in building data warehousing applications using Microsoft BI
• 2–3 years of experience building ETL applications using Azure Data Factory and Data Lake
• Strong knowledge of SQL for writing complex queries, stored procedures, and triggers
• Good communication skills and the ability to give demos to the stakeholders
  

Secondary Responsibilities:

• Developing cubes using SSAS models and querying data using Excel and Power View
• Report and Dashboard Development (Microsoft Power BI)
• Hands-on administrative experience with SQL Server 2016
• Good understanding of Azure cloud services

Qualifications

BE/BTECH in Information Technology, Computer Science, or a related field