Informatica Power Center - Consultant
Talent Worx
Posted: April 12, 2025
Interested in this position?
Create a free account to apply with AI-powered matching
Quick Summary
Design, develop, and maintain ETL processes using Informatica PowerCenter, with expertise in Informatica Intelligent Cloud Services, SQL, and AWS.
Required Skills
Job Description
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:
• Informatica PowerCenter
• IICS (Informatica Intelligent Cloud Services)
• SQL
• 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