Lead Analyst - Knowledge Services
Infosys BPM · Bengaluru · onsite · Posted 47d ago
Undisclosed8–13 yrsfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
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 Strong 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
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
o Strong 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.
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
Technical Requirement
Required Skills and Experience:
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
Sourced from naukri
Skills
data extractionAws Gluedatabase performancecloud data engineeringcloud platformsamazon web servicesCloud StorageDimensional ModelingERwinBlob StorageData LakeCloud DatacloudData IntegrationAzure Data FactorybpoMicrosoft AzureData Pipeline
About Infosys BPM
Infosys BPM
BPO
12.9k+
employees
2002
24 years old
Bangalore/Bengaluru, Karnataka
India
About
Infosys BPM, the business process management subsidiary of Infosys Limited, provides end-to-end transformative Digital BPM services for global enterprises.
Industries
BPOFinancial Services
Employee ratings
12,063 reviews
3.5/ 5
Culture
3.6
Career growth
2.7
Work-life
3.5
Employees rate it well for
Salary2773Work Environment1236Job Security1220Work Culture1197Senior Management830
Find them on