Job Description

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.

1. Database Management Systems (DBMS):

• Knowledge of SQL Server, DB2, and Teradata.
• Understanding of data warehousing concepts and data quality.

1. Unix and XML:

• Familiarity with Unix operating systems and XML data formats.

1. 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.

1. Technical Consulting: Provide senior-level consulting and advisory services.
2. 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.