Informatica PowerCenter developer

Job Description

Key Responsibilities : Informatica PowerCenter Development : Design and create Informatica mappings and workflows to efficiently extract, transform, and load (ETL) data. Perform end-to-end data integration from various sources into the data warehouse. Ensure best practices for data architecture and modeling are followed, optimizing for speed, scalability, and maintainability. SQL and PLSQL Optimization : Write SQL queries and PLSQL scripts for ETL processes, ensuring data transformation and loading are performed accurately. Optimize complex SQL queries for better performance. Troubleshoot and debug PLSQL queries, improving query performance and fixing issues. Data Warehousing & Modeling : Apply data warehousing concepts and data modeling principles to implement the best data structures. Ensure data consistency and integrity across the warehouse. Testing & Quality Assurance : Prepare test cases and execute Unit Testing (UT) and Quality Assurance (QA) testing for the developed solutions. Analyze large datasets to ensure data quality and make adjustments as needed. Unix Scripting & Automation : Write and optimize Unix scripts for automating tasks like file validation , FTP file transfers , and triggering Informatica workflows . Integrate Informatica workflows with other applications for seamless data flow. Collaboration with Third-Party Vendors : Collaborate with third-party suppliers and vendors to support, upgrade, and implement new solutions. Ensure smooth implementation of data integration solutions with minimal disruptions. Salesforce Development : Utilize Salesforce development skills to integrate data between Informatica and Salesforce applications. Ensure smooth data flow and integration between Salesforce and other data systems. Mandatory Skills : Informatica PowerCenter for data integration. Oracle PLSQL for writing and optimizing complex SQL queries. Salesforce development experience for data integration and transformation.