Informatica Solution Architect

• We are seeking a highly skilled Informatica Solution Architect professional with extensive experience in Informatica Cloud (IICS) for a dynamic role in a pharmaceutical data environment.
• The ideal candidate will be autonomous with recent experience in IICS, and possess a strong background in data modeling and SQL/Azure Environment.

Key Responsibilities

• Develop and maintain Informatica Cloud (IICS) solutions.
• Engage in DataBricks database development and optimization.
• Conduct thorough testing and validation of data processes.
• Gather and analyze requirements to ensure alignment with business needs.
• Deploy solutions and manage data integration processes.
• Lead workshops and brainstorming sessions to drive innovative solutions.
• Participate actively in Agile ceremonies including daily meetings, retrospectives, and sprint planning.
• Document processes and solutions on Confluence and Jira.
• Create connections and ETL processes to interface with various databases and data sources such as SFTP and Amazon buckets.
• Establish business rules for data acceptance and develop automatic testing processes for data validation.
• Design and implement data entities and transformations for Azure DB ingestion.
• Architect schemas and data entities to support a comprehensive data warehouse.
• Perform data cleaning, consolidation, and mapping to ensure data quality and integrity.