I have 2.2 years of experience in Informatica IICS as a Developer. And I have good knowledge in Snowflake, SQL , Oracle ,Data Integration , azure storage explorer and Shell Script. I am expert in Data Integration .
> Playing a vital role in creating high-level documents, source-to-target mapping documents, and detailed design documents for the entire ETL process.
> Extracting and loading data from diverse source/target systems such as SQL server, Salesforce, and flat files .
> Developing Data Integration platform components/processes using the Informatica cloud platform .
> Creating mapping documents with detailed source-to-target transformation logic, source data column information, and target data column information.
> Involved in designing, developing, and implementing ETL processes using IICS Data Integration o Creating IICS connections using various cloud connectors in IICS administration.
> Developing cloud data integration parametrized mapping templates for stage dimensions (SCD Type1, SCD Type2, Incremental Load).
> Developing complex Informatica cloud task flows with multiple mapping tasks.
> Designing and developing mappings to implement full and incremental loads from the source system.
> Managing the end-to-end ETL requirement gathering development with end-to-end support.
> Handling ETL code migration, DB code changes, and script changes to higher environments and supporting the code in PROD and QA environments.