Back to Jobs
I

Data Analysts, ETL, SQL, Informatica

Infosys Hyderabad, Telangana, India

Apply for this Position

Job Description

"Unlock the power of data analysis and ETL development with Informatica, and take your career to new heights as a Data Analyst at Infosys."

As a Data Analyst at Infosys, you will play a critical role in analyzing complex data sets, designing and implementing ETL processes using Informatica, and providing actionable insights to clients.

With a strong foundation in SQL and experience with panel data analysis, you will be responsible for ensuring high-quality data delivery, resolving technical issues, and driving customer satisfaction.

Why you should learn this:

The demand for skilled Data Analysts with Informatica expertise is on the rise, with a projected 14% growth in the next 5 years.

Expected Salary: According to industry reports, the average salary for a Data Analyst at Infosys is between $80,000 and $110,000 per annum, depending on experience and location.

How it works:

  • Step 1: Gather and analyze data from various sources using SQL and Informatica tools.
  • Step 2: Design and implement ETL processes to extract, transform, and load data into target systems.

Core Concepts to Master

1

ETL Development with Informatica

Learn the fundamentals of ETL development using Informatica, including data mapping, data transformation, and data loading.

2

SQL Query Optimization

Understand how to optimize SQL queries for better performance, including indexing, caching, and query rewriting.

3

Panel Data Analysis

Learn how to analyze panel data using statistical techniques, including regression analysis, time-series analysis, and data visualization.

Interview Questions (Beginner)

  • What is ETL development, and how does it relate to data analysis?
  • Can you explain the difference between Informatica and other ETL tools?
  • How do you optimize SQL queries for better performance?

Job Overview

CompanyInfosys
Employment TypeFull-time
LocationHyderabad, Telangana, India
Experience LevelFresher
Apply Now

Advance Questions

  • • Design an ETL process using Informatica to extract data from a relational database and load it into a data warehouse.
  • • Explain the concept of data mart and its benefits in data analysis.
  • • Can you describe a scenario where panel data analysis would be useful, and how you would approach it?