Etl Developer

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 status updates.

Key Skills:

•  ETL Tools/Software.
•  SQL.
• Parameterization.
• Scripting Language.
• Organization.
• Creativity.
• Debugging/Problem Solving.