Lead Analyst - Knowledge Services (Bengaluru)

Lead Analyst - Knowledge Services (Bengaluru)

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

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: lead analyst - knowledge services (bengaluru) / bengaluru

Subscribe to this job alert:

Get the latest job offers by email for: lead analyst - knowledge services (bengaluru) / bengaluru