Senior Technical Consultant
India
Apply now
Job Description
Senior Technical Consultant
Noida, Uttar Pradesh

Job Summary

We are looking for a skilled 7-9 years experienced Senior Technical Consultant with expertise in O9 Integration,SQL, SSIS , python to join our team. 
The ideal candidate will have proficiency in building scalable Interfaces, performance tuning,a data cleansing and validation strategies by leveraging the defined tech stack for data processing and data movement. 

Key Responsibilities

We are looking for a skilled 7-9 years experienced Senior Technical Consultant with expertise in O9 Integration,SQL, SSIS , python to join our team. 
The ideal candidate will have proficiency in building scalable Interfaces, performance tuning,a data cleansing and validation strategies by leveraging the defined tech stack for data processing and data movement. 
Advanced Execution & Data Management: Oversee and manage intricate project tasks, providing insights and directions related to advanced data ingestion, transformation, validation, and publishing.  
Review and analyse the data provided by the customer along with its technical/functional intent and interdependencies.  
Engage proactively with functional teams, ensuring a thorough understanding of end-toend data flows as related to the technical integration.  
Build data Ingress or Egress pipelines, handling of huge volume of data and developing data transformation functions using languages such as SSIS, Python, SQL etc.  
Integration of various data sources definitions like Teradata, SAP ERP, SQL Server, Oracle, Sybase, ODBC connectors & Flat Files through API or Batch.  
Production Deployment and Hypercare: Assist with Production Deployment tasks; Assists with triage of issues, testing and identifying root cause;  
Carry out timely response and resolution of batch automation disruptions, in order to meet customer SLA’s with accurate and on-time results.  
Technical Leadership & Coding Oversight: Guide and review the code developed by junior consultants, ensuring alignment with best practices.  
Incorporate o9 ways of working and embed the industry standards for smoother project executions.

Skill Requirements

Experience in Data architecture, Data engineering, or a related field, with a strong focus on data modelling, ETL processes, and cloud-based data platforms. 
Handson experiences working with o9 platform is a good to have.  
Hands-on experience with SSIS Packages, Python, PySpark, SQL languages  
along with workflow management tools like Airflow, SSIS.  
Experience working with Parquet, JSON, Restful APIs, HDFS, Delta Lake and query frameworks like Hive, Presto  
Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases  
Working experience with version control platforms, e.g. GitHub, Azure DevOps  
Familiarity with Agile methodology  
Proactive mindset and the right attitude to embrace the agility of learning.  
Good verbal and written communication skills 

Other Requirements

INT3.0 Certification is good to have
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 223,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 June 2026 totaled $14.8 billion.