
Python Senior Technical Lead - Data Analysis, SQL
About the role
Job Summary
Data Engineer - Key Requirements
-
10+ years of experience in** Data Engineering**
-
Strong hands-on experience with the AWS ecosystem
-
Strong expertise in Python
-
Strong expertise in SQL
-
Strong expertise in Shell scripting
-
Proven experience building and maintaining end-to-end data pipelines
-
Strong experience with ETL/ELT development
-
Experience with data ingestion, transformation, and processing of large datasets
-
Strong understanding of data modeling,data warehousing, and data lake concepts
-
Experience with AWS data services such as** Glue, Redshift, Lambda, Step Functions, Kinesis, RDS, DynamoDB, and S3**
-
Experience with Apache Spark
-
Strong knowledge of data quality, data validation, and data integrity practices
-
Experience with performance tuning and optimization of data pipelines and queries
-
Experience designing scalable and reliable cloud-based data solutions
-
Good understanding of data analysis and supporting analytics/reporting use cases
-
Experience with automation and scripting for pipeline and platform operations
-
Familiarity with CI/CD, DevOps, and Infrastructure as Code in data engineering environments
-
Strong problem-solving and troubleshooting skills
-
Ability to work with business and technical stakeholders to translate requirements into data solutions
Key Responsibilities
-
Lead technical projects involving sql, data analysis, and python from inception to implementation.
-
Design and develop sql databases, queries, and stored procedures to support various applications.
-
Conduct data analysis to derive valuable insights and make data driven decisions.
-
Develop and maintain python scripts to automate tasks and streamline processes.
-
Collaborate with cross functional teams to integrate technical solutions and ensure compatibility.
-
Troubleshoot technical issues related to sql databases, data analysis, and python scripts.
-
Stay updated on emerging technologies and recommend enhancements to existing systems.
Skill Requirements
-
Proficient in sql to design and optimize databases, write complex queries, and create stored procedures.
-
Strong data analysis skills to extract, clean, and analyze data for business insights and decision-making.
-
Experience in python programming for automation, data manipulation, and scripting tasks.
-
Knowledge of data visualization tools to present findings in a clear and understandable manner.
-
Excellent problem-solving abilities and attention to detail to identify and resolve technical issues efficiently.
-
Strong communication skills to collaborate with team members and stakeholders effectively.
Other Requirements
null
Benefits and perks
•Learning Budget
Required skills
Python
SQL
Shell scripting
AWS
ETL/ELT
Spark
Data modeling
Data warehousing
About HCL Technologies
Chennai
Headquarters