Senior Developer
India
Apply now
Job Description
Senior Developer
Chennai, Tamil Nadu

Job Summary

Roles & Responsibilities: -

Service Lead for Informatica role involves managing and maintaining critical applications within the ASM framework. Here are the key responsibilities and qualifications:

1.Application Support: Provide business and technical application support, troubleshooting, and resolution.

2.ETL Development: Develop ETL (Extract, Transform, Load) mappings and scripts using IDMC/IICS.

3.Database Skills: Work with SQL Server, Sybase, or Oracle databases.

4.Deployment and Documentation: Deploy code across environments and maintain proper documentation.

5.Security Configuration: Configure security domains, scheduling, and user/group synchronization with LDAP services.

6.Shift Coverage: Rotation of MST (9 PM to 6:30 AM IST)

Key Responsibilities

Roles & Responsibilities: -

Service Lead for Informatica role involves managing and maintaining critical applications within the ASM framework. Here are the key responsibilities and qualifications:

1.Application Support: Provide business and technical application support, troubleshooting, and resolution.

2.ETL Development: Develop ETL (Extract, Transform, Load) mappings and scripts using IDMC/IICS.

3.Database Skills: Work with SQL Server, Sybase, or Oracle databases.

4.Deployment and Documentation: Deploy code across environments and maintain proper documentation.

5.Security Configuration: Configure security domains, scheduling, and user/group synchronization with LDAP services.

6.Shift Coverage: Rotation of MST (9 PM to 6:30 AM IST)

Skill Requirements

1. IDMC/IICS.

- Proficiency in using IDMC/IICS for ETL (Extract, Transform, Load) tasks.

- Ability to design ETL mappings, workflows, and transformations.

2. Database Management Systems (DBMS):

- Knowledge of SQL Server, DB2, and Teradata.

- Understanding of data warehousing concepts and data quality.

3. Unix and XML:

- Familiarity with Unix operating systems and XML data formats.

4. Performance Optimization:

- Experience tuning mappings, optimizing transformations, and managing workflow efficiency.

5.Security and Maintenance:

- Implementing upgrades, security patches, and server maintenance.

6.Informatica Designer Components: Familiarity with Source Analyzer, Mapping Designer, Mapplet Designer, and Transformation Developer.

7. Technical Consulting: Provide senior-level consulting and advisory services.

8. Data Warehousing: Experience designing and constructing databases.

9.Collaboration:Share knowledge, consult, and communicate effectively with the team.

Other Requirements

Desired Experience :- Overall 5 years in managing and maintaining critical applications within the ASM framework , including:-

1.Minimum 2+ yrs of experience in IDMC/IICS: Showcase hands-on experience with designing, developing, and debugging ETL workflows using Informatica Cloud.

2.Minimum 2+ yrs of experience in Data Integration and Transformation: Demonstrate expertise in data integration and transformation tools.

3.Minimum 1+ yrs of experience in Oracle and PL/SQL: hands-on experience with Oracle and PL/SQL.

4.Education:A relevant degree (Bachelor's or Master's) in Computer Science, Engineering, or related fields.

5.Certifications:Consider certifications related to Informatica (e.g., IDQ).

6.Experience: Proficiency in IDMC/IICS, SQL, and data warehousing concepts.
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 230,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 September 2026 totaled $14.8 billion.