Senior Data Scientist

HCL Technologies Limited; NTR; On-site; INR 900,000 - 1,300,000; Full time

Job summary

HCL Technologies Limited in India is seeking an ETL specialist to design, develop and deploy data pipelines using Informatica IICS, SQL on SQL Server and MySQL, and data warehousing concepts.

The candidate should understand legacy code, handle various source files (csv, xlsx, json), coordinate deployments across environments, and analyze business data issues while learning new skills in shell scripting and Python.

Qualifications

• Experience in Informatica IICS (Informatica Intelligent Cloud Services) design, development and deployment.
• Proficient in SQL across SQL Server and MySQL; able to design procedures, triggers, views, and tables.
• ETL design, development and data warehousing concepts.
• Ability to understand legacy code and provide solutions for IICS, shell scripting and Python.
• Ability to analyze business/user data issues and provide data-driven solutions.

Responsibilities

• Process data from source files (CSV, XLSX, JSON) and build multi-layer data pipelines using IICS.
• Coordinate with multiple teams to resolve non-production and production issues and manage deployments to higher environments.
• Understand problems, articulate approaches, and describe past projects with technical detail.

Skills

Informatica IICS

SQL

ETL Design

Data Warehousing

Shell Scripting

Python

Unix Commands

Tivoli Scheduling

Tools

Informatica IICS

SQL Server

MySQL

Shell

Python

Unix

Tivoli

Job description

• Experience in Informatica IICS(Informatica Intelligent Cloud Services) - Design, Development & Deployment
• Experience in SQL - SQL Server/MySQL - Procedures, Trigger, View , Tables - Design , Create.
• ETL Design, Development & Data Warehousing concepts
• Ability to understand legacy code and provide solution accordingly for IICS , shell scripting, python
• Should be able to understand the business/user data issue and provide the solution based on analysis.
• Work on different source files(csv, xlsx, Json) and process the data into different layers using IICS.
• Co-ordinate with multiple teams for non-production and production issues and complete the deployments to higher environments.
• Ability to understand and solve a problem/issue (pose a problem and understand their approach)
• Ability to describe past projects (technical details and how it was addressed)
• Ability to learn a new skill
• Ability to understand python code
• Experience on Unix commands and Shell Scripting
• Experience working with scheduling tools in Tivoli.

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 2026totaled $14.8billion.