INFORMATICA DEVELOPER

As an experienced Informatica Developer, you will be responsible for utilizing your expertise in Informatica Intelligent Cloud Services (IICS), AWS Redshift, AWS Database Migration Service (DMS), and SQL Server. Your primary role will involve working on various data integration projects that leverage cloud technologies. You will be tasked with designing, developing, and maintaining ETL workflows using Informatica IICS to seamlessly integrate data from different sources, both on-premises and in the cloud, into AWS Redshift. Your focus will also include implementing and optimizing AWS Redshift to ensure efficient data storage and analytics capabilities. Utilizing AWS Database Migration Service (DMS), you will be responsible for migrating data from on-premises databases such as SQL Server to AWS cloud environments. Additionally, you will be expected to write complex SQL queries, conduct data transformations, and uphold data quality and consistency standards within SQL Server. Collaboration with data architects, business analysts, and other stakeholders will be essential to comprehend data requirements and develop efficient ETL processes. Your responsibilities will also include testing, debugging, and monitoring ETL processes to guarantee accurate data loading and transformation, as well as optimizing performance for scalability and efficiency. Ensuring data security and compliance within both cloud environments and on-premises systems will be a critical aspect of your role. You will be required to provide ongoing support and maintenance for ETL processes, troubleshoot and resolve production issues, and meticulously document technical specifications, designs, and procedures related to data integration processes.,