What are the responsibilities and job description for the Informatica PowerCentre - Fulltime position at Pioneer Corporate Services Inc?
Title: Informatica PowerCentre
Location: Pittsburgh, PA (Onsite)
Exp: 8-14 years
Skill: Informatica Developer
Must Have Technical/Functional Skills:
- Proficiency with Informatica tools (e.g., PowerCenter).
- Strong knowledge of ETL processes.
- SQL and database concepts
- Scripting (Unix, Python).
- Troubleshooting and debugging.
- Data warehousing principles
Roles & Responsibilities:
- ETL development: Design, build, test, and maintain data integration workflows using Informatica PowerCenter or other Informatica products.
- Data integrity and accuracy: Ensure data is accurate, consistent, and reliable by implementing quality checks and troubleshooting issues.
- Performance tuning: Optimize ETL processes and data storage systems for efficiency and high availability.
- Collaboration: Work closely with business analysts, data architects, and other stakeholders to understand and implement data requirements.
- Documentation: Create and maintain technical documentation for all developed processes.
- Problem-solving: Troubleshoot and resolve issues related to data integration, data quality, and performance.