Data Analyst (ETL)

Overview

Position: Data Analyst (ETL)

Experience: 8+years

Work Mode: Hybrid

Notice Period: Immediate

Location: Pune/Mumbai

Budget: 20LPA

Shift: General Shift (But at times there will be over lapping of time as per client timings).

Must have key skills

ETL Tools (IICS, Talend, Hadoop etc.) AWS, with basic understanding of GCP & Azure , JIRA

Confluence,

MS Visio (SQL / PLSQL / Oracle)

Python, Shell script and Power BI

Good to have skills – Knowledge of R

Technical Skills

• Data Cleaning Tools & Libraries: Proficiency with tools and libraries to clean and preprocess data for example:
• Python
• R
• SQL
• Excel- emphasis on Familiarity with data cleaning functions, filters, and pivot tables.
• Data Management & Analysis Skills
• Data Validation & Consistency: Ability to identify data quality issues such as duplicates, missing values, outliers, and inconsistencies.
• Data Transformation: Experience in transforming raw data into usable formats, including reshaping, aggregating, or normalizing data.
• Handling Missing Data: Familiarity with imputation techniques or ways to deal with incomplete datasets.
• Data Normalization & Standardization: Ensuring uniformity in data formats, units of measurement, and naming conventions.
• Data Aggregation: Summarizing or grouping data for analysis and ensuring that it is consistent across all sources.
• Knowledge of Data Quality
• Data Integrity: Understanding the importance of maintaining accurate and consistent data over time.
• Data Profiling: Identifying patterns, anomalies, and key characteristics of the dataset.
• Error Detection: Ability to find and correct errors within datasets by checking for outliers, misclassifications, or missing values.

Soft Skills

• Attention to Detail: The ability to identify small inconsistencies and issues within large datasets.
• Problem-Solving: Being resourceful in resolving data issues and proposing solutions.
• Critical Thinking: Analyzing data in-depth and understanding its implications.
• Communication: Ability to explain data issues and cleaning steps to non-technical stakeholders.
• Experience with Data Formats
• Structured Data: Familiarity with both structured (tables, databases)
• Data Sources: Ability to clean data from various sources such as spreadsheets, databases, APIs, logs, etc.
• File Formats: Proficiency in working with common data file formats like CSV, XML, and Excel.

Statistical and Analytical Skills

• Basic Statistics: Understanding of basic statistical concepts to spot anomalies, outliers, or trends in
• data.
• Data Visualization: Ability to visualize the cleaned data to identify trends and patterns (e.g., with
• Power BI .

Automation and Scripting

• Automating Repetitive Tasks: Experience in automating data cleaning processes with scripts or workflow automation tools.
• Batch Processing: Capability to clean data in bulk, particularly when dealing with large datasets.
• Domain Experience preferably worked with product based can be an added advantage.
• Interview rounds – Total 3 rounds of interview

Job Types: Full-time, Permanent

Pay: ₹1,500,000.00 - ₹20,000,000.00 per year

Benefits:

• Health insurance
• Leave encashment
• Paid sick time
• Paid time off
• Provident Fund

Schedule:

• Day shift

Experience:

• Data Analyst: 8 years (Required)
• SQL/PLSQL/Oracle: 8 years (Required)
• ETL Tools (IICS, Talend, Hadoop etc): 8 years (Required)
• AWS/GCP/Azure: 6 years (Required)

Location:

• Viman Nagar, Pune, Maharashtra (Preferred)

Work Location: In person