ETL Developer
Bengaluru, India
Company Description
BETSOL is a cloud-first digital transformation and data management company offering products and solutions to both enterprises and consumers. BETSOL’s Data Management product lines include Rebit (Rebitgo.com) and Zmanda (Zmanda.com). BETSOL Global IT Services (BETSOL.com) builds and supports end-to-end enterprise solutions, reducing time-to-market for our customers. Our engineering team, with its several patents, delivers award-winning products and solutions in over 40 countries. Our work locations are set against the vibrant backdrops of Broomfield, Colorado and Bangalore, India. We take pride in being an employee centric organization. Learn more at betsol.com
Job Description
Candidate Must Have:
- 4-6yrs Experience in Business Intelligence along with database design and integration experience with SQL Server databases
- Strong experience of SQL Server 2016/Azure databases
- Data Marts / Data Warehouse Solution Design, Dimensional Modeling (Kimball Methodology)
- ETL/ELT (Extraction, Transformation and Loading) Design & Development (Microsoft SSIS & T-SQL, Talend, SQL, SOQL)
- Ability to connect to heterogenous sources like Salesforce, Oracle, Anaplan, SQL Server, MySQL etc to perform data migration
Preferred Skills:
- Azure Data Factory & Data Lake
- Analytics/ OLAP Cube Development (Microsoft SSAS/AAS, MDX - Multidimensional Model, DAX - Tabular Model)
- Report and Dashboard Development (Microsoft SSRS and Microsoft Power BI)
Primary responsibilities:
- Demonstrate advanced knowledge and skills in designing and implementing Data Marts, Data Warehouse, ETL and BI solutions
- Expertise / Handson skills in data modelling, ETL and data components development using: SQL Server T-SQL, SQL stored procedures, triggers and views, SSIS, Talend, SQL, SOQL and SQL agent jobs
- Designing, developing and testing data transformations for reporting and interfaces between systems
- Understanding of database architecture, security and deployment strategies
Secondary Responsibilities:
- Developing Cubes using SSAS Models and querying data using Excel and Powerview
- Developing Reports using SSRS / PowerBI
- Helping business with Self-service BI and Analytics
- Hands on administrative experience with SQL Server 2016
Soft Skills:
- Ability to read, analyze, and interpret general business documentation, technical specifications and project management documentation
- Data gathering, research and analytical abilities so as to develop insightful conclusions and generate solutions to address user needs
- Good analytical, logical reasoning and problem-solving skills
- Good interpersonal, written, and oral communication skills
- Self-motivated and directed, with keen attention to detail
- Able to prioritize and execute tasks in a high-pressure environment
- Experience working in a team-oriented, collaborative environment
Qualifications
BE/BTECH in Information Technology, Computer Science, or related field
Additional Information
All your information will be kept confidential according to EEO guidelines.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Architecture Azure Business Intelligence Computer Science Data management Data warehouse ELT Engineering ETL Excel MySQL OLAP Oracle Power BI Research Salesforce Security SQL SSIS Talend Testing T-SQL
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Manager jobs
- Open Principal Data Engineer jobs
- Open Marketing Data Analyst jobs
- Open Power BI Developer jobs
- Open Data Science Manager jobs
- Open Lead Data Analyst jobs
- Open MLOps Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Business Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Product Data Analyst jobs
- Open Sr Data Engineer jobs
- Open Junior Data Scientist jobs
- Open Data Analyst Intern jobs
- Open Senior Data Architect jobs
- Open Sr. Data Scientist jobs
- Open Research Scientist jobs
- Open Big Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Data Quality Analyst jobs
- Open Azure Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Data Product Manager jobs
- Open GCP-related jobs
- Open Data quality-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Business Intelligence-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Data visualization-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open NLP-related jobs
- Open Finance-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open LLMs-related jobs
- Open Consulting-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open Snowflake-related jobs
- Open Hadoop-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open Databricks-related jobs
- Open Data warehouse-related jobs