Job ID : 35912
Location : San Diego, CA
Company Name : MSIT
Job Type : Full-Time, Part-Time, Contract, Training
Industry : Information Technology
Salary : $46000 - $56000 per year
No. of Positions : I have ongoing need to fill this role
Required Skills : Creativity, Debugging, Problem Solving..
Benefits : Medical Insurance, Dental Insurance, Vision Insurance, 401K, Life Insurance
Job 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 status updates.
Key Skills:
- ETL Tools/Software.
- SQL.
- Parameterization.
- Scripting Language.
- Organization.
- Creativity.
- Debugging/Problem Solving.