Jobs
H

Senior Developer

HCLTechIN1d ago
Full-timevia indeed

Required Skills

sql

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.

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.

  • *Must Have Skill**
  • ------------------

Informatica Intelligent Cloud Services (IICS)

  • *Good to Have Skill**
  • ---------------------
  • *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.

Similar Jobs

Browse all jobs

Job Overview

Job type
Full-time
Work mode
On-site
Location
IN
Posted
1d ago
Source
Indeed