12 Sep
|
Infosys BPM
|
Bengaluru
12 Sep
Infosys BPM
Bengaluru
Job Description
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 productive data solutions.
Roles & Responsibilities
Data Modelling:
o Solid proficiency in SQL (queries, procedures, views, functions, indexing).
o Hands-on experience in data modelling using tools like ER/Studio, ERWin, SQL Server Management Studio, Lucidchart, etc.
o Solid understanding of database normalization, relational modelling, and schema design principles.
o Experience working with large datasets and optimizing database performance.
o Familiarity with star schema, snowflake schema, and dimensional modelling principles.
ETL Development:
o Design, implement, and manage Extract, Transform, Load (ETL) processes to move and transform data from various source systems into target data warehouses or databases.
o Develop, monitor, and troubleshoot ETL workflows to ensure smooth and accurate data integration.
o 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.
Technical Requirement
Required Skills and Experience:
Data Modelling: 8+ years of experience in creating Dimensional Modeling, Data Base Normalization and writing complex SQL queries, stored procedures, and optimizing database performance.
ETL Tools: 8+ years of Solid experience with ETL tools (such as SSIS or ADF) for data extraction, transformation, and loading.
Cloud Experience: At least 4 years of hands-on experience in cloud platforms (Azure/AWS/GCP),
including: Data pipeline development, Data lake and warehouse concepts , Cloud-based ETL tools
Educational Requirement
Graduate
Preferred Skills
Digital Business
Service Line
BPO Service Line
📌 Lead Analyst Knowledge Services Bengaluru
🏢 Infosys BPM
📍 Bengaluru