PasadenaCARecruiter Since 2001
the smart solution for Pasadena jobs

SR. ETL DEVELOPER

Company: Sysintelli, Inc.
Location: San Diego
Posted on: November 6, 2024

Job Description:

SR. ETL DEVELOPER (San Diego, CA):
Design & development of ETL mappings, mapplets, sessions & workflows to load data from source to target databases using Informatica Power Center & fine-tuned mappings to improve performance.
Interact with customers to gather requirements & business logic for design & development.
Create Type 1 & Type 2 Slowly Changing Dimension Mappings to update Slowly Changing Dimension database tables.
Create & review Informatica ETL Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, look-ups, Stored Procedure transformation, functions, Filters, Sequence, Router, Union & Update Strategy adhering to coding standards.
Actively participate in data modeling; in implementation of Data Vault methodology; & in identifying Hub, Link & Satellite tables.
Be involved in dimensional modeling & design Star/Snowflake Data Models for Enterprise Data Warehouse.
Write complex SQL scripts to avoid Informatica look-ups to improve performance.
Develop Trend Lines, Statistics & Log Axes, groups, hierarchies, sets to create detail level summary report & Dashboard using KPIs (ix) Data Analysis, Data Integration & Data Modeling.
Required: MS (or equivalent) in Computer Science, Engineering (Computer/Electrical/Mechanical/Industrial) or a related field & 2 years of experience in positions involving similar duties/technical capabilities to the offered position.
Must be willing to travel and/or relocate to work in various unanticipated locations throughout the US.
Relocation benefits offered. No telecommuting. Drug testing required.
Submit cover letters & resumes to P. Baghani, Sysintelli, Inc., Panny@sysintelli.com.
#J-18808-Ljbffr

Keywords: Sysintelli, Inc., Pasadena , SR. ETL DEVELOPER, IT / Software / Systems , San Diego, California

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

Pasadena RSS job feeds