27 Sep
|
Hucon Solutions
|
Bengaluru
27 Sep
Hucon Solutions
Bengaluru
JD:
Role Overview:
We are seeking an experienced and highly skilled SQL(Data Modelling) + ETL Developer with Cloud experience to join our Reporting COE team. The ideal candidate will have extensive hands-on experience with SQL database development, ETL processes, and cloud platforms, enabling scalable and effective data solutions.
Key Responsibilities:
- Data Modelling:
- Strong proficiency in SQL (queries, procedures, views, functions, indexing).
- Hands-on experience in data modelling using tools like ER/Studio, ERWin, SQL Server Management Studio, Lucidchart, etc.
- Solid understanding of database normalization, relational modelling, and schema design principles.
- Experience working with large datasets and optimizing database performance.
- Familiarity with star schema, snowflake schema, and dimensional modelling principles.
- ETL Development:
- Design, implement, and manage Extract, Transform, Load (ETL) processes to move and transform data from various source systems into target data warehouses or databases.
- Develop, monitor, and troubleshoot ETL workflows to ensure smooth and accurate data integration.
- Work with business and technical teams to understand data requirements and ensure seamless integration of systems.
Cloud Data Engineering
- Design and implement data solutions using cloud platforms such as AWS, Azure, or GCP
- Develop and manage data pipelines using cloud-native tools (e.g., Azure Data Factory, AWS Glue, etc.).
- Work with cloud storage solutions like Data Lakes, Blob Storage, or S3.
- Ensure scalability, reliability, and security of cloud-based data solutions.
- Monitor and optimize cloud data workflows for performance and cost efficiency.
Required Skills:
- Data Modelling: experience in creating Dimensional Modeling, Data Base Normalization and writing complex SQL queries, stored procedures, and optimizing database performance
- ETL Tools: f Strong experience with ETL tools (such as SSIS or ADF) for data extraction, transformation, and loading.
- Cloud Experience: At least hands-on experience in cloud platforms (Azure/AWS/GCP),including: Data pipeline development, Data lake and warehouse concepts , Cloud-based ETL tools
📌 SQL Data Modelling + ETL Developer (Bengaluru)
🏢 Hucon Solutions
📍 Bengaluru