Python Technical Specialist - Data Analysis, SQL

Experience: Not Available to Not Available years

Location: Chennai, India

Skills: Python, AWS, TypeScript, RESTful, SQL, PLSQL, data analytics, Git, CI/CD, data processing, ETL, Lambda, Glue, S3, Step Functions, Node.js, unit testing, integration testing, regression testing, data quality, data governance, data documentation, data manipulation, data workflows, data integrity, data analysis techniques

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
Robust 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. Develop and maintain SQL databases and queries for data storage and retrieval.
2. Conduct data analysis to identify trends, patterns, and insights that will drive business decisions.
3. Create scripts and programs using Python to automate processes and optimize data workflows.
4. Collaborate with cross-functional teams to understand technical requirements and provide solutions.
5. Implement data quality measures and ensure data integrity across different systems.
6. Stay updated on industry trends and best practices in SQL, data analysis, and Python to suggest improvements and optimizations.

Skill Requirements
1. Proficiency in SQL for database management and query optimization.
2. Strong skills in data analysis techniques to interpret complex datasets.
3. Experience in programming with Python for data manipulation and automation.
4. Excellent problem-solving skills with a strategic mindset.
5. Ability to communicate technical information effectively to non-technical stakeholders.
6. Attention to detail and strong analytical skills for accurate data interpretation.

Other Requirements
1. Relevant certifications in SQL, data analysis, or Python are a plus.

📌 Python Technical Specialist Data Analysis, SQL (Chennai)
🏢 HCL Technologies
📍 Chennai