Python Senior Technical Lead - Data Analysis, SQL
India
Job Description
Python Senior Technical Lead - Data Analysis, SQL
Chennai, Tamil Nadu

Job Summary

  • Required Skills & Experience
  • Strong hands-on experience with Python for ETL and data processing
  • Practical experience with AWS services relevant to data engineering
  • Solid experience in TypeScript and building RESTful endpoints
  • Strong SQL skills and experience with PLSQL (functions, procedures, performance tuning)
  • Experience in testing (unit/integration tests) for code and data pipelines
  • Exposure to data analytics and working with large datasets
  • Familiarity with version control (e.g., Git) and CI/CD practices
  • Good communication skills and ability to work in cross-functional teams
  • About the Role
    We are looking for a hands-on developer to design, build, and maintain scalable ETL processes and data solutions using Python, AWS, TypeScript, and SQL/PLSQL. This role will work closely with data analysts, architects, and business stakeholders to ensure high-quality, reliable data pipelines and APIs.

  • Key Responsibilities (10)
  • Design, develop, and maintain ETL pipelines using Python to extract, transform, and load data from multiple source systems into target data stores.
  • Implement and optimize data workflows on AWS (e.g., Lambda, Glue, S3, Step Functions, or similar services) to ensure scalability, reliability, and cost efficiency.
  • Develop and maintain RESTful endpoints in TypeScript (e.g., using Node.js frameworks) to support data access, integration, and analytics use cases.
  • Write and optimize complex SQL queries and PLSQL functions for data transformation, validation, and reporting.
  • Implement testing strategies (unit, integration, regression) for ETL jobs, APIs, and data transformations to ensure data accuracy and system reliability.
  • Monitor, troubleshoot, and improve data pipelines and services, including performance tuning, error handling, and root-cause analysis.
  • Collaborate with data analysts and business stakeholders to understand data requirements and translate them into technical solutions and data models.
  • Ensure data quality, governance, and documentation by maintaining clear technical documentation for ETL jobs, APIs, schemas, and data flows.
  • Apply data analytics concepts to validate data, support reporting needs, and help derive insights from datasets.
  • Follow best practices for security, coding standards, and DevOps in 

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

1. Proficient in sql to design and optimize databases, write complex queries, and create stored procedures.
2. Strong data analysis skills to extract, clean, and analyze data for business insights and decision-making.
3. Experience in python programming for automation, data manipulation, and scripting tasks.
4. Knowledge of data visualization tools to present findings in a clear and understandable manner.
5. Excellent problem-solving abilities and attention to detail to identify and resolve technical issues efficiently.
6. Strong communication skills to collaborate with team members and stakeholders effectively.

Other Requirements

null
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 226,300 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 2025 totaled $14.5 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.