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!
...Company: Matrix Design Studio Location: San Diego, CA (hybrid; local site visits) Workplace Type: On-site / Hybrid Remote Employment Type: Freelance with path to full-time, salaried... ...family-owned architecture and interior design studio crafting luxury custom...
...Job Description Job Description Job description Smart Homz is a rapidly growing Home Tech company and is seeking field technicians. Full-time Opportunities throughout NJ, but immediate need in Bergen County (willing to commute to Monmouth and/or Ocean Counties...
A Bartender/Restaurant Server is responsible for preparing beverages... ...inquiries and requests in a timely, friendly and efficient manner... ...regulations+ Accurately total, process and collect payments from... ...*Title:** _Server/Bartender \(Part Time\)_**Location:** _null_*...
...THURSDAYS 9A-3P Join the Guardian Angel Senior Services Home Care Team- Where Caregivers... ...that's met with gratitude and respect. As part of our team, you'll enjoy: Round-the-... ...about. Comprehensive benefits and paid time off , ensuring your well-being is taken care...
...monitor nursing staffing in all neighborhoods to ensure appropriate staff is available to provide resident care and meet established PPD. Effectively implement a person-centered approach to care, focusing on the residents strengths while providing a sense of comfort...