Good experience on 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.

7. Documentation:: Create and maintain documentation for data integration processes, including data mappings, transformations, and workflow designs.
- Document standards, best practices, and guidelines for Informatica development.

8. Monitoring and Maintenance:: Monitor ETL jobs and address issues in a timely manner to ensure the reliability of data integration processes.
- Perform routine maintenance tasks and updates to keep the ETL workplace running smoothly.

9. Collaboration:: Work closely with other members of th

📌 Snowflake (Bengaluru)
🏢 TalentOla
📍 Bengaluru