Python Senior Technical Lead - Data Analysis, SQL
India
Apply now
Job Description
Python Senior Technical Lead - Data Analysis, SQL
| Chennai, Tamil NaduBangalore, Karnataka

Job Summary

This position entails leading technical projects in the areas of SQL, data analysis, and Python. The Senior Technical Lead will be responsible for overseeing the development and implementation of technical solutions that leverage SQL databases, perform data analysis, and utilize Python programming for automation and data manipulation tasks.

Key Responsibilities

1. Lead technical projects involving sql, data analysis, and python from inception to implementation.
2. Design and develop sql databases, queries, and stored procedures to support various applications.
3. Conduct data analysis to derive valuable insights and make data driven decisions.
4. Develop and maintain python scripts to automate tasks and streamline processes.
5. Collaborate with cross functional teams to integrate technical solutions and ensure compatibility.
6. Troubleshoot technical issues related to sql databases, data analysis, and python scripts.
7. Stay updated on emerging technologies and recommend enhancements to existing systems.

Skill Requirements

 
JD for Data Analyst
1.    Business & Domain Understanding
o    Translating business requirements into data structures and mappings
o    Working with SMEs to define business terms and KPIs
o    Understanding how data is consumed (reports, dashboards, analytics, APIs) and designing models accordingly
2.    Data Modeling & Mapping
o    Conceptual, logical, and physical data models; Normalization & Denormalization and when to use each
o    Entity-relationship (ER) modelling; Dimensional modelling;Slowly Changing Dimensions (SCD types)
o    Understand existing data model and alignment; work experience in ERwin,Maintaining models as living artefacts (versioning, change tracking)
o   Source-to-target mapping (STM) / mapping specifications; Maintain Data Mapping & data dictionary document aligning standards.
o   Understanding of source systems: APIs, databases, flat files, messages
o   Mapping business concepts to data elements and attributes;Handling data transformations: cleansing, standardization, enrichment
o    Understanding how models and mappings are implemented in ETL;How mapping specs are handover docs for ETL developers / engineers
3.    SQL & Querying
o   Strong SQL for exploring data and validating models;Joins, aggregations, window functions
o   Strong data profiling to refine models and mappings
4.    Testing & Data Validation
o   Documenting validation rules, thresholds, and exception criteria;Translating business and technical requirements into test cases
o   Defining test scenarios, test data, expected results; Executing manual test cases, validating results, logging defects
o   Using or scripting automation (e.g., SQL scripts, Python, or test tools) for repeatable checks
o   Perform Data validation, Support UAT & UVT 
o   Test cases tracking and update in ADO; Incident Handling
5.    Data Quality, Standards & Governance
o   Data quality dimensions: accuracy, completeness, consistency, timeliness, uniqueness
o   Designing models that support data quality checks and constraints
o   Metadata: business glossary, data catalog, data lineage
o   Naming conventions, standards for keys, data types, and codes
6.    Documentation & Communication
o   Clear mapping &model documents: field-level mappings, transformation rules, validation rules
o   Communicating models and mappings to business stakeholders and technical teams
o   Participating in design and review workshops

Other Requirements

null
Apply now
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 227,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending December 2026 totaled $14.7 billion.
23 Benefits At HCLTech, we believe in empowering our employees with comprehensive benefits that support their professional growth and enhance their well-being. When you sign up for a career with us, you gain access to: https://rmkcdn.successfactors.com/147eb21f/a701dca9-f32d-4fc9-9447-6.svg Industry-benchmarked compensation https://rmkcdn.successfactors.com/147eb21f/b0c54381-ddcc-4a33-9b35-9.svg Best-in-class healthcare benefits https://rmkcdn.successfactors.com/147eb21f/b73027be-7aae-4d36-a090-4.svg Personal time off https://rmkcdn.successfactors.com/147eb21f/d5b4fdfd-2e99-4e26-9878-9.svg Maternity and paternity benefits https://rmkcdn.successfactors.com/147eb21f/3d42b0fc-4652-435a-9ece-c.svg Access to skills / higher education programs/resources https://rmkcdn.successfactors.com/147eb21f/aeddeaf2-9e25-4584-ad11-d.svg Discounts on products and services via Benefit Box https://rmkcdn.successfactors.com/147eb21f/a9609a3b-2700-4b3c-9d90-a.svg Participate in CSR programs and live life with a purpose https://rmkcdn.successfactors.com/147eb21f/c6e33851-710f-4634-bd69-f.svg Opportunities to grow and advance your career Note: The benefits listed above vary depending on the nature of your employment and the country where you work. Some benefits may be available in some countries but not in all.