Senior Developer

Technology, Data & Digital · Data, AI & Analytics · Data Engineering

In short

Senior Developer role in Chennai, India, focusing on application support and ETL development using IDMC/IICS, SQL Server, Oracle, and Unix. The position requires proficiency in data integration, database management, and technical consulting, with a required shift coverage in IST.

Responsibilities

Provide business and technical application support, troubleshooting, and resolution.
Develop ETL mappings and scripts using IDMC/IICS.
Work with SQL Server, Sybase, or Oracle databases.
Deploy code across environments and maintain proper documentation.
Configure security domains, scheduling, and user/group synchronization with LDAP services.
Rotation of MST (9 PM to 6:30 AM IST) shift coverage.

Requirements

Proficiency in IDMC/IICS for ETL tasks.
Ability to design ETL mappings, workflows, and transformations.
Knowledge of SQL Server, DB2, and Teradata.
Understanding of data warehousing concepts and data quality.
Familiarity with Unix operating systems and XML data formats.
Experience tuning mappings, optimizing transformations, and managing workflow efficiency.
Implementing upgrades, security patches, and server maintenance.
Familiarity with Informatica Designer Components: Source Analyzer, Mapping Designer, Mapplet Designer, and Transformation Developer.
Provide senior-level consulting and advisory services.
Experience designing and constructing databases.
Share knowledge, consult, and communicate effectively with the team.
Minimum 2+ years of experience in IDMC/IICS.
Minimum 2+ years of experience in Data Integration and Transformation.
Minimum 1+ years of experience in Oracle and PL/SQL.
Proficiency in IDMC/IICS, SQL, and data warehousing concepts.

Desired Qualifications

A relevant degree (Bachelor's or Master's) in Computer Science, Engineering, or related fields.
Consider certifications related to Informatica (e.g., IDQ).

Benefits

Consolidated revenues as of 12 months ending September 2026 totaled $14.8 billion.

Skills

IDMC/IICSETLSQL ServerSybaseOracleSQLPL/SQLUnixXMLLDAPDB2Teradata

#Informatica#ETL#SQL Server#Oracle#Unix#XML#IDMC/IICS#Data Integration#PL/SQL#Data Warehousing

About HCLTech

Supercharging progress through technology and innovation

HCLTech is a global technology company, home to 219,000+ people across 54 countries, delivering industry-leading capabilities centered around digital, engineering and cloud, 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 September 2022 totaled $12.1 billion. To learn how we can supercharge progress for…

See all open jobs at HCLTech Read more about HCLTech Website