Etl Developer - San Diego, United States - MSIT

Description

Responsibilities Estimations system design writing program specifications and reviews. Develop ETL mappings transformations using Informatica Power Center. Implement source and target definitions in workflow designer.

Develop mappings using various transformations like update strategy lookup stored procedure Router Filter sequence generator joiner aggregate transformation and _expression.

Develop several reusable transformations and mapplets that were used in other mappings. Work on the server manager to run several sessions and batches concurrently and sequentially.

Design Mappings to the utmost performance by optimizing expressions in expression editor of transformation filtering source data at the source qualifier and applying transformation logic.

Design the schema in Snowflake with Data retention period for 7 days for all permanent tables in order to maintain streams are not stale in near future.

Create streams on dimensional raw tables and merge the data into foundation layer tables In Snowflake Cloud. Develop SQL batch files in Snowflake for data loads from and in to Snowflake using Snow SQL scripts. Able to work on OACLE PL/SQL packages stored procedures and functions. Co-ordinate with offshore and onshore teams resolved common challenges and discussed daily ticket