Etl Developer
Job ID : 35912
Job Title : Etl Developer
Location : San Diego, CA
Comapny Name : MSIT
Job Type : Full-Time, Part-Time, Contract, Training
Industry : Information Technology
Salary : $46000 - $56000 per year
Work Authorization : ["OPT","CPT","Entry Level","F1","H4","L1","H1 Visa","TN Permit Holder","Green Card Holder","Canadian Citizen","All EAD","US Citizen"]
No. of Positions : I have ongoing need to fill this role
Posted on : 01-19-2024
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.
Company Details :
Company Information hidden please Login to view details