Informatica Power Center - Consultant

Technical Skill Set:

• Hands-on experience with Informatica PowerCenter as an ETL tool.
• Proficiency in AWS cloud services: RDS, Redshift, S3.
• Strong knowledge of Database Concepts – Indexing, Partitioning.
• Understanding of Data Warehousing concepts – Normalization, Denormalization, Star/Snow-flake schemas.
• Proficient in creating tables, DDL, DML, and TCL.

Requirements

Key Skills:

1. Informatica PowerCenter
2. IICS (Informatica Intelligent Cloud Services)
3. SQL
4. AWS

Responsibilities:

• Design, develop, and maintain ETL processes using Informatica PowerCenter.
• Manage and optimize AWS cloud services including RDS, Redshift, and S3.
• Implement database indexing and partitioning strategies to enhance performance.
• Develop and maintain data warehousing solutions, ensuring data integrity and efficiency.
• Create and manage database tables, and perform DDL, DML, and TCL operations.
• Collaborate with cross-functional teams to understand data requirements and deliver solutions.

Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 4 to 8 years of relevant experience in ETL development and data warehousing.
• Strong problem-solving skills and attention to detail.
• Excellent communication and teamwork abilities.

Benefits

Work with one of the Big 4's in India