Log In
Sign Up
Job Description: Data Analyst – Teradata (FSDM Focus)
Location: Mumbai
Shift Time- General/Morning shift, 5 days a week
Experience-8 to 12 yrs
Role Overview
We are looking for a Data Analyst (5+ years) with strong SQL and data analysis expertise, preferably with exposure to Teradata and FSDM. The role is primarily focused on data exploration, analysis, and deriving insights from enterprise datasets, supporting data modelling and downstream consumption.
Key Responsibilities
Core Data Analysis
• Perform deep data analysis on large Teradata datasets to support business and modelling requirements
• Conduct data profiling, validation, and exploratory analysis to understand data patterns
• Identify:
o Data inconsistencies
o Missing or anomalous values
o Relationships across datasets
Requirement Understanding & Data Interpretation
• Work closely with business teams to:
o Understand reporting and analytical requirements
o Translate business questions into data queries and analysis outputs
• Provide data-driven insights to support decision-making
Advanced SQL Development
• Develop and optimize complex SQL queries involving:
o Multi-table joins
o Window functions
o Aggregations and analytical queries
• Perform query tuning using Teradata capabilities (Explain plans, stats awareness)
• Extract and transform datasets for analysis and consumption
Support to Data Modelling (Light-Touch, Analysis Driven)
• Assist data architects by:
o Validating source-to-target mappings
o Performing data comparison and reconciliation between datasets
• Support identification of:
o Key entities (Customer, Policy, Transactions, etc.)
o Attribute-level insights for modelling
Reporting & Insights Generation
• Generate analytical reports, summaries, and datasets for stakeholders
• Use tools like Excel / Power BI for:
o Data summarization
o Trend analysis
• Present findings in a clear and structured manner
Skills & Qualifications
SQL (Core Skill)
• Advanced SQL expertise:
o Complex joins, subqueries, CTEs
o Window / analytical functions
• Strong understanding of:
o Query optimization
o Handling large datasets efficiently
Data Analysis Skills (Primary Focus)
• Strong experience in:
o Data profiling & exploration
o Identifying trends, patterns, anomalies
• Ability to:
o Break down complex datasets into meaningful insights
o Perform reconciliation across multiple data sources
• Analytical thinking with problem-solving mindset
Teradata (Hands-on)
• Experience working on Teradata systems
• Understanding of:
o Data distribution
o Basic performance concepts (without deep admin-level expertise)
Preferred Skills
• Exposure to FSDM / Financial or Insurance domain data
• Knowledge of data warehousing basics
o Fact, dimension understanding (only conceptual grounding needed)
• Experience with:
o Talend or any ETL tool (for understanding data flows, not development-heavy)
• Basic familiarity with BI tools (Power BI / Tableau)