Modeling Star Snowflake Data Warehouse ETL Architecture Agile Development Bachelors   Requirement id 116334 Job title Developer Job location in Norcross, GA Skills required Modeling, Business Systems, ETL Development, Star Snowflake Data Warehouse ETL Archit Open Date 28-Apr-2021 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Developer: Modeling, Business Systems, ETL Development, Star Snowflake Data Warehouse ETL Archit start date:05/17/2021 End date:05/12/2022 submission deadline:05/03/2021 client info :BORUSG - ITS *Note: Agency Interview Type: Web Cam Interview Only Description: Senior developer with ETL experience to rearchitect the integration between University System of Georgias (USG) cloud-based learning management system (GeorgiaView) and their on-premise data reporting repository. The hired resource will lead and guide an ODI based ETL architecture to handle complex business rules while balancing the fulfillment of stringent performance requirements. The goal is to use ODI to load CSV files to a LMS database (SQL Server). The original design was written in C# and loaded to SQL Server database. If the candidate can make it work with C#, USG has team to support it instead of doing a re-write. Essential Responsibilities - Drive design and determine the ETL requirements for integration project - Partners with Technical Lead and supports the development of complex ETL routines to load a dimensional star schema (and supporting layers) and develops error handling processes. - Perform an active, leading role in shaping and enhancing overall ETL architecture, including ETL standards, patterns and best practices. - Determines organizational strategies for data integrity validation processes. - Establishes policies and best practices for optimizing ETL data throughput/accessibility - Identifies opportunities for new architectural initiatives; makes recommendations on the increasing scalability and robustness of ETL platforms and solutions. - Supports sustainability effort by providing technical assistance, troubleshooting and alternative development solutions - Assists in the development of ETL-related Service Level Agreements. Required Experience 3-4 years experience. •- Experience in modeling and business system designs - Hands on experience in ETL development - SQL Server Database experience - Proven experience with STAR and SNOWFLAKE modeling techniques - SQL Server (or comparable database) experience with Data Warehouse deployments - Proven track record as an ETL Architect, leading development teams to deliver successful business intelligence solutions with complex data sources Highly Desired - Oracle Data Integrator to load to SQL Server environment   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 116334 while calling.   Other jobs in GA: Alpharetta (12), Atlanta (37), Conyers (2), Downtown Atlanta (1), Dublin (1), Duluth (5), Dunwoody (4), Lawrenceville (2), Norcross (4),    Modeling job openings in other states Jobs List NCDOT - Specialist- Senior (733994) Create date: 09-May-2024 No of Submissions : 2 Start date : 05/15/2024 End date : 05/15/2025 Submission deadline : 05/13/2024 Client info : NCDOT Note : * Remote * The candidate will be allowed to work remotely for the duration of the engagement. * Contractors who live outside of N.... (This job is for - Modeling Workflow Jobs in NC Raleigh Consultant - (in Raleigh, NC)) VDOT IT Governance Analyst 3 (723734) Create date: 13-Nov-2023 Hybrid Start date :12/04/2023 End date :06/30/2024 Submission deadline :11/16/2023 Client info :VDOT Description : *local Richmond, VA candidates required *first round of interviews via phone, second round is ONSITE, NO exceptions.... (This job is for - Modeling Cybersecurity Jobs in VA Richmond Analyst - (in Richmond, VA)) NCDOT - Specialist- Mid Level (705000) Create date: 01-Mar-2023 Start date : 04/29/2023 End Date : 04/28/2024 Submission deadline : 03/07/2023 Client Info : NCDOT Note : * The candidate will be allowed to work remotely for the duration of the engagement. * Remote * Either Webcam Interview or In Person Description : ----.... (This job is for - Modeling Databases Workflow Jobs in NC Raleigh Specialist - (in Raleigh, NC)) Data Architect - RxRenu Team - 84238 Create date: 04-Jan-2022 Description: Client: Prime Therapeutics Role: Data Architect Location: Remote Duration: 15 months ? Project Scope / Components: RxRenu – adjudication effort Building a solution that will take seconds to process a claim ? Team Size & Break.... (This job is for - Modeling Architecture Jobs in MN Minneapolis Architect - (in Minneapolis, MN)) Oracle Business Intelligence (OBIEE) Developer - 5740 Create date: 18-Nov-2021 Description: Day-to-Day Tasks include, but not limited to: Coordinate the activities of the project teams. Analyze and migrate existing reports from Oracle Discoverer (now de-supported) to OBIEE. Create BI models to meet business reporting and analytics requirements Interact wit.... (This job is for - Obiee Modeling Jobs in NY NewYork Developer - (in New York, NY))    Modeling job openings in GA Jobs List Consultant - 53910 Create date: 17-Aug-2018 TITLE: Reporting and Analytics Strategy Consultant JOB PURPOSE: This position is responsible for assisting the Enterprise Data Management (EDM) Team in the development of a road map and strategy that combines current practices with the implementation of Workday Financials and a hosted PeopleSoft 9.2 HCM deploymen.... (This job is for - Modeling Jobs in GA Atlanta Consultant - (in Atlanta, GA)) MS SQL Server BI - J-11-181-070 Create date: 10-Nov-2016 Start Date : 11/27/2016 End Date : 05/27/2017 Submission Dead Line : 11/16/2016 Description : - Microsoft Analysis Services 2008 / 2014 - Modeling Analytic Cubes - Building Dimensions - Automation of cube builds - Performance Tuning - Cube Security Modeling Jobs in GA ALPHARETTA Developer - (in Alpharetta, GA)) (Developer: Modeling, Business Systems, ETL Development, Star Snowflake Data Warehouse ETL Archit in Norcross, GA)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)