Area(s) of responsibility

JD - Informatica, Snowflake along with Matillion:

Informatica:

An Informatica Developer is responsible for designing, developing, testing, and maintaining data integration solutions using the Informatica platform.

1. **Requirement Analysis:**: Collaborate with business analysts and stakeholders to understand data integration requirements.

• Analyze source and target systems to identify data integration needs.

2. **Design and Architecture:**: Design data integration solutions using the Informatica PowerCenter or other relevant Informatica modules.

• Create data mapping documents to specify the flow of data from source to target.

3. **Development:** : Implement ETL (Extract, Transform, Load) processes using Informatica PowerCenter.

• Develop and optimize data mappings, transformations, and workflows to meet business requirements.

• Implement data cleansing, validation, and transformation rules.

4. **Data Modeling:**: Design and create data models that support the data integration requirements.

• Work with database developers and administrators to ensure effective data storage and retrieval.

5. **Testing:**: Conduct unit testing to validate the accuracy and efficiency of the implemented ETL processes.

• Collaborate with quality assurance teams to perform system and integration testing.

6. **Performance Tuning:**: Identify and address performance bottlenecks in ETL processes.

• Optimize SQL queries, transformations, and workflows for better performance.