Informatica PowerCenter Developer (Hybrid Role)

Looking Informatica PowerCenter ETL Developer for Tampa, FL (Hybrid).

Please Note ::: This is Hybrid role.

An Informatica PowerCenter Developer is responsible for designing, developing, and maintaining data integration processes using Informatica PowerCenter.

Responsibilities:

Data Extraction:

· Extract data from various sources (databases, flat files, XML, web services, etc.).

· Design and implement workflows to automate data extraction.

Data Transformation:

· Write transformations (such as aggregations, joins, lookups, filters) to clean, transform, and process raw data into usable formats.

· Ensure that data quality and business rules are maintained.

Data Loading:

· Load transformed data into target systems (databases, data warehouses, or cloud platforms).

· Handle various types of loading processes (incremental loads, full loads).

Mapping Design:

· Design and develop mappings in PowerCenter to define how data is extracted, transformed, and loaded.

· Implement reusable transformations and mapplets for efficiency.

Performance Tuning:

· Optimize ETL jobs to handle large volumes of data efficiently.

· Apply partitioning, session, and database optimizations to improve performance.

Job Scheduling:

· Schedule ETL jobs to run automatically at defined intervals using the Workflow Manager.

· Monitor job execution and troubleshoot errors or failures.

Error Handling and Logging:

· Implement error handling and logging mechanisms to track ETL job performance and issues.

Documentation:

· Document the ETL process, mapping specifications, and data flow for future reference.

Collaboration:

· Work with business analysts, data architects, and other developers to gather requirements and understand data needs.

· Coordinate with database administrators (DBAs) to ensure data integrity and optimize data storage.

Required Skills:

· Strong knowledge of PowerCenter Designer, Workflow Manager, and Repository Manager.

· PowerCenter Designer: Proficient in designing mappings and transformations.

· Experience in creating and managing workflows and sessions.

· Experience with different transformations (Aggregator, Filter, Joiner, Lookup, Router, etc.).

· Strong proficiency in SQL for querying databases and performing transformations.

· Experience with relational databases like Oracle, SQL Server, or DB2.

· Knowledge of ETL best practices, such as partitioning, data load strategies, and error handling.

· Understanding of dimensional modelling, star and snowflake schemas, fact and dimension tables.

· Experience with optimizing mappings and workflows for performance, especially for large data sets.

· Knowledge of version control and source code management tools to manage ETL code.

· Ability to troubleshoot and resolve issues with ETL processes and data quality.

· Familiarity with scripting languages (e.g., shell scripting or Python) to automate or extend ETL processes.