divya chandana

Experienced IICS Developer | Expert in ETL Development, Cloud Data Migration, Snowflake, Oracle SQL & AWS" and ORACLE SQL. Used ETL tool as informatica IICS, Transformation, SQL,CDI,cloud data integration,Agile scrum methodology using JIRA, CDCI pipe

I developed the mapping logics using the requirement specification, and I have built transformations such as filter, expression, aggregation, and router based on the logics. Create and maintain detailed technical involves designing, developing, and implementing data integration and transformation solutions using Informatica Cloud Data Integration (CDI). IICS is a cloud-based platform that provides ETL, data integration, and data quality services, and the role of an IICS Developer revolves around managing and optimizing these processes.documentation for workflows, mappings, and Create and manage data extraction, transformation, and loading (ETL) pipelines within the IICS platform. Work with various data sources such as cloud applications, databases, flat files, and web services to extract data and process it. integrations Integrate data from different sources like on-premises and cloud-based systems (e.g., AWS, Google Cloud, Azure). Leverage IICS capabilities like Data Integration, Data Quality, and Application Integration to create seamless, automated data workflows.Define data transformation rules to clean, filter, join, and aggregate data as needed. Implement complex business logic and data transformations using the IICS tools and features, ensuring data quality and accuracy. Use IICS's Data Quality tools to ensure the accuracy, completeness, and consistency of data. Create and implement rules to validate and cleanse data before it’s loaded into the destination systems.Leverage IICS to design and maintain cloud-based data pipelines that integrate with cloud storage (e.g., AWS S3, Azure Blob Storage). Optimize cloud data solutions for performance, scalability, and cost-efficiency. Monitor and troubleshoot ETL jobs to ensure data integration jobs run without issues. 

Developed the task flow for the complete implementation of the project's functionality, including reading data from various sources, moving it to the stage area, processing it using transformation logic, performing the action from it, and loading the final target tables into the data warehouse . typically involves designing, developing, and maintaining data integration workflows using Informatica Intelligent Cloud Services (IICS) , Creating efficient pipelines for extracting, transforming, and loading (ETL) data between systems.Work closely with business analysts, data engineers, data architects, and other stakeholders to understand data requirements and translate them into technical solutions. Collaborate with other teams to ensure the data integration process meets business objectives.Maintain clear documentation for ETL processes, transformation logic, and data flows. Create user guides and technical documentation for stakeholders to ensure smooth handovers and knowledge sharing.Ensure compliance with data privacy laws and internal security standards when handling sensitive data. Implement encryption, access controls, and other security measures as part of the data pipeline.Proficiency in using IICS for building and managing cloud-based ETL workflows