Data Analyst

Tekskills Inc.; Hyderabad, Pune District, Bengaluru; Hybrid; INR 800,000 - 1,500,000; Full time

Job summary

Tekskills Inc. in Hyderabad is seeking an experienced Data Analyst (5-7 years) with strong SQL and Databricks expertise to deliver scalable data solutions. You will design and optimize complex queries, validate data quality, and maintain source-to-target mappings to translate business requirements into technical specs.

Exposure to ETL/ELT processes, data warehousing concepts, and basic Python/PySpark is preferred. Experience in Oil & Gas or Energy domains is a plus.

Qualifications

• 5-7 years of experience in Data Analytics, Data Warehousing, or related data roles.

Responsibilities

• Build and optimize SQL queries for data transformations.
• Maintain STTM documents and translate requirements to specs.
• Validate data and ensure data quality across sources and targets.
• Trace data lineage across multiple tables and layers.
• Debug production data issues and reconcile discrepancies.
• Work with Python/PySpark basics in analytics tasks.

Skills

SQL

Databricks

STTM docs

Data quality

ETL/ELT

Python basics

Data lineage

Job description

Role & responsibilities

Description:

Data Analyst (5-7 Years Experience | SQL & Databricks)

• 5-7 years of experience in Data Analytics, Data Warehousing, or related data roles.
• Strong hands-on expertise in advanced SQL, including complex joins, CTEs, window functions, subqueries, and query optimization.
• Proven experience working with Databricks and large-scale data platforms.
• Experience creating and maintaining Source-to-Target Mapping (STTM) documents and translating requirements into technical specifications.
• Ability to write, review, and optimize SQL logic for complex data transformations and validations.
• Strong experience in data validation, reconciliation, and data quality analysis across source and target systems.
• Expertise in identifying and debugging logic errors, data discrepancies, and production issues.
• Experience analyzing data lineage and tracing issues across multiple tables, views, and transformation layers.
• Good understanding of ETL/ELT processes, relational databases, and data warehousing concepts.
• Basic Python/PySpark knowledge is preferred; Oil & Gas or Energy domain experience is an added advantage.