Informatica+ Snowflake ( Matillion)Technical Lead-Data Engg

Area(s) of responsibility

Informatica

JD - Informatica, Snowflake along with Matillion :

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

• Requirement Analysis :
• : Collaborate with business analysts and stakeholders to understand data integration requirements.
• Analyze source and target systems to identify data integration needs.
• 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.
• 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.
• 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.
• 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.
• Performance Tuning :
• : Identify and address performance bottlenecks in ETL processes.
• Optimize SQL queries, transformations, and workflows for better performance.

Skills Required

snowflake , Informatica Powercenter, Informatica, Sql, Etl