INFORMATICA DEVELOPER

Job Description

EXPERIENCE: 5+ years JOB DESCRIPTION: Experienced Informatica Developer with expertise in Informatica Intelligent Cloud Services (IICS), AWS Redshift, AWS Database Migration Service (DMS), and SQL Server to join our team. The ideal candidate will have a strong background in data integration, ETL processes, and cloud data solutions, and will work on a variety of data projects involving cloud technologies ROLES RESPONSIBILITIES Design, develop, and maintain ETL workflows using Informatica IICS to integrate data from various sources (on-premises and cloud) into AWS Redshift. Implement and optimize AWS Redshift for efficient data storage and analytics. Utilize AWS Database Migration Service (DMS) to migrate data from on-premises databases (e.g., SQL Server) to AWS cloud environments. Write complex SQL queries, perform data transformations, and ensure data quality and consistency in SQL Server. Collaborate with data architects, business analysts, and other stakeholders to understand data requirements and design efficient ETL processes. Perform testing and debugging of ETL processes to ensure accurate data load and transformation. Monitor and optimize ETL performance for scalability and efficiency. Ensure data security and compliance within the cloud environment and on-premises systems. Provide ongoing support and maintenance for ETL processes, including troubleshooting and resolving production issues. Document technical specifications, designs, and procedures related to data integration processes.