ETL Developer Job at Stampin' Up!, Riverton, UT

VFJaZkFDK1N3YXZyUVdDMDRwdkxrZGsvU0E9PQ==
  • Stampin' Up!
  • Riverton, UT

Job Description

Overview ETL Developer role at Stampin' Up! in Riverton, UT. The position involves working with business analysts to gather requirements for development, testing, and project coordination; documenting ETL mapping specifications; preparing source analysis and ETL design documentation prior to development; and extracting, transforming, and loading data from multiple sources into the data warehouse using ETL tools. Responsibilities Extract, transform, and load data from multiple sources into the data warehouse using ETL tools including SAP Data Services and Informatica. Document ETL mapping specifications and prepare documentation for source analysis and ETL design prior to development. Move data from source systems to different schemas based on dimensions and fact tables using slowly changing dimensions type 1 and type 2. Improve performance of ETL processes by benchmarking approaches and implementing changes such as redesigning mappings, introducing intermediate/staging tables, and using database partitioning. Create test cases, perform unit testing for ETL code, and log/resolve defects during deployment; participate in defect analysis calls for UAT to understand data and suggest modifications. Prepare complex SQL queries to validate data in source and target databases; tune mapping performance following best practices to reduce ETL run time. Create and enhance data solutions enabling seamless delivery of data; collect, parse, manage, and analyze large data sets for reporting; lead the design of the logical data model and implement the physical database structure, including operational data stores and data marts. Identify and fix production issues quickly; work with data validation tools to create test rules and validate data loaded in the data warehouse; create monitors, validation rules, and dashboards to identify issues. Collaborate with end users to understand data requirements and ensure data quality and availability for reporting. Qualifications Bachelor's degree in Electronics Engineering, Computer Science (willing to accept foreign education equivalent) or related field of study, and 4 years of software development experience. Specific skills/requirements: SQL, data warehousing including dimensional modeling and support; ETL tools SAP Data Services (BODS)/Business Objects Data Integrator (BODI) and Informatica. How to apply To apply, send your resume to lnelson@stampinup.com and reference this advertisement in your cover letter. Location: Lehi/Utah region; compensation ranges shown in job posting may vary by location and experience. EEO statement: Referrals increase your chances of interviewing at Stampin' Up! by 2x. #J-18808-Ljbffr Stampin' Up!

Job Tags

Similar Jobs

ISC Healthcare

Travel Nurse RN - Med Surg Job at ISC Healthcare

 ...Job Description ISC Healthcare is seeking a travel nurse RN Med Surg for a travel nursing job in Marshall, Michigan. Job Description & Requirements ~ Specialty: Med Surg ~ Discipline: RN ~ Start Date: 11/10/2025~ Duration: 13 weeks ~36 hours per week... 

DataAnnotation

Claims Investigator - AI Trainer Job at DataAnnotation

 ...We are looking for legal experts to join our team to train AI models. You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the quality of each model. In this role you will need to hold an expert level of legal reasoning... 

StretchLab

Stretch Therapist Athletic Science Grads Something New Job at StretchLab

 ...and experienced, join our growing team of talented Flexologists. You must have a thorough knowledge of human anatomy, a Sports and Exercise Science degree, or have current certification in one of the following: Massage or Neuromuscular Therapy, Yoga, Pilates, Physical... 

ScionHealth

Pharmacy Tech I Job at ScionHealth

 ...we create our culture by living our values in our day-to-day interactions with our patients and teammates. Job Summary The Pharmacy Technician under the direct supervision of the (Market) Manager/Director of Pharmacy or Registered Pharmacist and according to the... 

Hebrew SeniorLife

Summer Intern Job at Hebrew SeniorLife

 ...Job Description: Position Summary: The summer intern will positively contribute to the patient experience while participating in learning opportunities that will enhance growth and development as a member of the healthcare team. Responsible for working closely with...