Data Analyst- Teradata

Job description

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)