We are seeking a skilled and experienced Informatica PowerCenter E1 Developer to join our team. The ideal candidate will be responsible for the design, development, testing, and implementation of ETL solutions using Informatica PowerCenter, specifically within an E1 (EnterpriseOne) environment. This role requires a strong understanding of data warehousing concepts, data integration best practices, and the ability to work effectively within a dynamic development lifecycle.
Roles and Responsibilities :
- Design, develop, and implement ETL (Extract, Transform, Load) processes using Informatica PowerCenter.
- Work with Informatica PowerCenter to extract data from various source systems, transform it according to business rules, and load it into target data warehouses or data marts.
- Specialize in integrating with E1 (EnterpriseOne) systems, understanding its data structures and integration points.
- Develop and maintain mappings, sessions, and workflows within Informatica PowerCenter.
- Perform data profiling, data quality checks, and data validation to ensure accuracy and consistency.
- Troubleshoot and resolve ETL job failures and data-related issues.
- Collaborate with business analysts, data architects, and other developers to understand requirements and deliver robust solutions.
- Participate in performance tuning and optimization of ETL processes.
- Create and maintain technical documentation for all ETL processes and data flows.
- Adhere to best practices for data integration, data governance, and security.
Required Skills and Qualifications :
Proven experience as an Informatica Powe rCenter Developer .Strong understanding and experience with Informatica Power Center tools and components.Experience with E1 (EnterpriseOne) integration and data structures.Solid understanding of data warehousing concepts, ETL methodologies, and relational databases .Proficiency in SQL for data querying and manipulation.Ability to analyze complex data sets and identify data quality issues.Strong problem-solving and analytical skills.Excellent communication and teamwork abilities.Skills Required
Data Warehousing Concepts, Relational Databases, Sql, Performance Tuning