Informatica Powercentre

Teamware Solutions is seeking a skilled Informatica PowerCenter Developer / Administrator to design, develop, and manage robust ETL solutions. You'll play a crucial role in extracting, transforming, and loading data from diverse sources into target systems, ensuring data integrity, quality, and availability for business intelligence and reporting. This position is ideal for a professional with hands-on experience in the full lifecycle of Informatica PowerCenter implementations.

Key Responsibilities

• ETL Development & Design :
• Design, develop, and implement complex ETL mappings, Mapplets, Transformations (e.g., Source Qualifier, Aggregator, Joiner, Router, Lookup, Expression, Filter), and Sessions using Informatica PowerCenter .
• Create and manage workflows, worklets, and tasks within Informatica Workflow Manager .
• Develop and optimize SQL queries for source / target systems and transformation logic.
• Ensure data quality, consistency, and integrity throughout the ETL process.
• Administration & Support :
• Install, configure, and maintain Informatica PowerCenter environments (Repository Service, Integration Service, Web Services Hub, Node).
• Perform user and group management, folder permissions, and security configurations.
• Monitor ETL job executions, troubleshoot failures, and ensure timely data loads.
• Manage code deployments across development, QA, and production environments.
• Performance Tuning & Optimization :
• Identify and resolve performance bottlenecks in ETL mappings and workflows.
• Implement performance tuning techniques at the source, target, and transformation levels to optimize data load times.
• Conduct capacity planning and ensure the scalability of the Informatica environment.
• Troubleshooting & Debugging :
• Provide expert-level support for Informatica PowerCenter-related issues, including debugging complex mappings and workflows.
• Analyze session logs and workflow logs to diagnose and resolve data integration problems.
• Collaboration & Documentation :
• Work closely with data architects, business analysts, and report developers to understand data requirements and deliver effective solutions.
• Create and maintain comprehensive technical documentation for ETL processes, data lineage, and system configurations.

Qualifications

Preferred Skills

Skills Required

Etl Development, Informatica Powercenter, Performance Tuning, Troubleshooting, Relational Database