What are the responsibilities and job description for the Senior ODI Architect/Developer position at PEOPLECORP AMERICA INC?
Job DescriptionOur 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.Skills Required / Desired : 5 Years Required - Experience in modeling and business system designs2 Years Required - Hands-on experience in ETL development5 Years Required - SQL Server Database experience2 Years Required - Proven experience with STAR and SNOWFLAKE modeling techniques2 Years Required - SQL Server (or comparable database) experience with Data Warehouse deployments3 Years Required - Proven track record as an ETL Architect, leading development teams to deliver successful business intelligence solutions with complex data sources2 Years Highly desired - Oracle Data Integrator to load to SQL Server environment2 Years Desired - Visual Studio2 Years Desired - SSIS experience, C#2 Years Desired - PYTHON2 Years Required - Agile development methodology background2 Years Required - Bachelor's degree; Licenses, Certifications, RegistrationsLocation : 800 Corporate Drive, Suite 301-500Stafford, VA, 22554Phone - 1 (703) 547-8929Fax - 1 (703) 991-7602#J-18808-Ljbffr
