Job Description :

State of GA is seeking a ETL System Architect / Application Developer for a contract position in REMOTE. Please find below the job description. If interested, please share your word format resume with hourly rate expectation.

10-15+ Year Experience and Local & EST Time Zone Preferred

Role: ETL Systems Architect/Developer (650440)

Duration: 12 Months+

Location: Remote

Interview Mode: Web Cam Interview Only

Type: Contract

Start Date: 05/24/2021

Client: State of GA

Rate: DOE

Purpose of Engagement: System Architect / Application Developer (ETL)

Job Summary:

Senior developer with ETL experience to re-architect the integration between University System of Georgia's (USG') cloud-based learning management system (Georgia View) 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.

- 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

Required Skills

  1. Experience in modeling and business system designs Required 5 Years
  2. Hands on experience in ETL development Required 2 Years
  3. SQL Server Database experience Required 5 Years
  4. Proven experience with STAR and SNOWFLAKE modeling techniques Required 2 Years
  5. SQL Server (or comparable database) experience with Data Warehouse deployments Required 2 Years
  6. Proven track record as an ETL Architect, leading development teams to deliver successful business intelligence solutions with complex data sources Required 3 Years
  7. Oracle Data Integrator to load to SQL Server environment Highly desired 2 Years
  8. Visual Studio Desired 2 Years
  9. SSIS experience , C# Desired 2 Years
  10. PYTHON Desired 2 Years
  11. Agile development methodology background. Required 2 Years
Bachelor's degree; Licenses, Certifications, Registrations. Required 2 Years
             

Similar Jobs you may be interested in ..