We are seeking a Senior ETL-Informatica Developer with extensive experience in ETL development, specifically with Informatica PowerCenter, Informatica Cloud (IICS), and database technologies. This individual will play a key role in the design, implementation, and maintenance of ETL processes and data integration workflows. The ideal candidate will also have experience with performance tuning, SQL, PL/SQL, and Informatica Server administration. Exposure to cloud-based technologies and modern data architecture will be an added advantage.
Key Responsibilities
- Design, develop, implement, and optimize ETL workflows and processes using Informatica PowerCenter, Informatica Cloud (IICS), and other related ETL tools.
- Write complex SQL queries and develop PL/SQL procedures to transform, cleanse, and load data into data warehouses or target systems.
- Ensure the accuracy, efficiency, and scalability of ETL processes by conducting comprehensive testing and performance tuning.
- Integrate data from various sources (e.g., relational databases, flat files, APIs) and ensure seamless data flow across systems.
- Perform Informatica server configuration, monitor ETL jobs, and troubleshoot and resolve production issues related to the Informatica environment.
- Work closely with business analysts, data architects, and other developers to understand requirements, document solutions, and ensure that ETL processes meet business needs.
- Leverage Informatica Intelligent Cloud Services (IICS) for cloud-based ETL implementations and manage data workflows across on-premise and cloud environments (preferred but not mandatory).
- Use performance analysis tools to identify bottlenecks in ETL processes, optimize code, and ensure efficient data loading.
- Provide post-deployment support, including monitoring ETL jobs and troubleshooting failures or issues.
Required Skills and Qualifications
- At least 8 years of experience with Informatica PowerCenter for ETL development.
- Expertise in writing optimized SQL queries, stored procedures, and PL/SQL for data transformation and integration.
- Experience designing ETL architectures and working with complex data transformation logic.
- Solid experience in Informatica server setup, configuration, job monitoring, and troubleshooting.
- Strong ability to analyze and optimize performance of ETL workflows.
- Knowledge of Informatica Cloud or similar cloud ETL tools is a plus.
- Strong knowledge of integrating heterogeneous data sources into a unified data model.
- Familiarity with scripting languages (e.g., shell, Python) for automation of ETL workflows is a plus.
- Excellent communication skills and the ability to work with cross-functional teams.