What makes iLink's offerings unique is the fact that we use pre‑created frameworks, designed to accelerate software development and implementation of business processes for our clients. iLink has over 60 frameworks (solution accelerators), both industry‑specific and horizontal, that can be easily customized and enhanced to meet your current business challenges. Requirements 5+ years' experience in building function & store procedure using ODI tool. Design Data warehouse table and applicable documentation. Develop table creation scripts and execute the scripts for the Database Administrator (DBA). Analyze data sources and determine data relationships to pair with the business requirements documentation (BRD). Familiarity with data quality issues and Exact, Transform, Load (ETL) processes. Design and develop Extract Load Transform (ELT) process and load data from source tables into staging tables and then into target fact and dimension tables utilizing Oracle Data Integrator (ODI). Validate data loaded into various tables utilizing Structured Query Language (SQL) and other analysis. Knowledge and understanding of the applicable tools and practices used in data governance including query and data profiling techniques. Proven skills in data analysis—including queries to calculate data quality. Solid written, verbal, and analytical skills. Strong research and problem determination and solution skills. Versátil to work in Shifts (Rotational). Benefits Competitive salaries Medical Insurance Employee Referral Bonuses Performance Based Bonuses Flexible Work Options & Fun Culture Robust Learning & Development Programs In-House Technology Training Job Type: Full timeIndustry: IT ServicesState/Province: JaliscoCity: GuadalajaraCountry: Mexico #J-18808-Ljbffr