Get job as soon as 2 days (HURRY UP) ENROLL NOW or Call   +1 (804)-454-3215

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 :


  • 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.

Recommended jobs for you

  • Etl Developer

    Apollose San Diego, CA

    Responsibilities : Responsiblties: Efficiently and effectively solutions for well-formed business or technical problems preferred. Provides senior team members with infor

    View Job

Thanks For Your Feedback

We’re an equal opportunity provider.
All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status. is not a Consulting Company/Training Company/H1B Sponsor.

Attach A Resume First