11 Sep
|
Infosys BPM
|
Bengaluru
11 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 efficient 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 Strong 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