Senior ODI Architect/Developer

PEOPLECORP AMERICA; Atlanta (GA); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading company is seeking a Senior Developer to focus on ETL processes with a strong background in SQL Server and database modeling. The role involves rearchitecting integrations between their cloud-based learning management system and on-premise data reporting, requiring advanced skills in ETL architecture and guidance for development teams.

Qualifications

• 5 Years experience in modeling and business system designs.
• 2 Years hands-on experience in ETL development.
• Proven track record as an ETL Architect.

Responsibilities

• Lead and guide an ODI based ETL architecture.
• Handle complex business rules and performance requirements.
• Use ODI to load CSV files to LMS database.

Skills

ETL Development

SQL Server Database

Data Warehouse Deployments

STAR Modeling

SNOWFLAKE Modeling

Oracle Data Integrator

Agile Development

Python

C#

SSIS

Education

Bachelor's degree

Tools

Visual Studio

Job description

Job Description
Our Direct Client is seeking an experienced, full-time, on-site, dedicated Candidate, with skills and expertise as described in below requirement.

Responsibilities:
Senior developer with ETL experience to rearchitect the integration between Client cloud-based learning management system 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#, Client has team to support it instead of doing a re-write.

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

800 Corporate Drive, Suite 301-500
Stafford, VA, 22554
Phone - 1 [phone]
Fax - 1 [phone]