Informatica+ Snowflake ( Matillion)Technical Lead-Data Engg

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.