SQL Data Modelling + ETL Developer

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 efficient 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