Senior ETL ODI Developer

Job Description: Data EngineerCompany: Kooe Private LimitedPosition: Data EngineerType: Contract, RemoteExperience: 7+ Years in building functions & stored procedures using ODI, 3+ Years in Project ManagementJob Overview:We are seeking an experienced Data Engineer with expertise in Oracle Data Integrator (ODI) and project management. The ideal candidate will have a strong background in Agile methodologies, JIRA, and data warehousing. This role involves designing and developing ELT processes, validating data, and ensuring data quality. The successful candidate will contribute significantly to the development of our data infrastructure and support business requirements documentation (BRD).Key Responsibilities:Design data warehouse tables and create applicable documentation.Develop table creation scripts and execute them with the Database Administrator (DBA).Analyze data sources and determine data relationships to align with the business requirements documentation (BRD).Design and develop Extract Load Transform (ELT) processes and load data from source tables into staging tables, then into target fact and dimension tables using Oracle Data Integrator (ODI).Validate data loaded into various tables utilizing SQL and other analytical tools.Utilize tools and practices in data governance, including query and data profiling techniques.Address data quality issues and Exact, Transform, Load (ETL) processes.Proactively analyze and calculate data quality using SQL queries.Collaborate with cross-functional teams to ensure data accuracy and relevance.Leverage Agile methodologies and JIRA for project management.Skills & Qualifications:Experience:7+ years of experience in building functions & stored procedures using ODI.3+ years in Project Management.Technical Skills:Strong proficiency in Agile methodologies and JIRA.Expertise in designing data warehouse tables and creating related documentation.Proficient in developing table creation scripts and executing them for DBAs.Solid experience in analyzing data sources and determining data relationships.Familiarity with data quality issues and ETL processes.Proficient in designing and developing ELT processes with ODI.Experienced in validating data using SQL and other analytical tools.Knowledge of data governance tools and practices, including query and data profiling techniques.Soft Skills:Strong written, verbal, and analytical skills.Excellent research and problem-solving abilities.Nice-to-Have Skills:Certifications related to data engineering, Oracle Data Integrator (ODI), or project management.Experience in data analysis, including queries to calculate data quality.Strong understanding of data governance and quality assurance practices.

Key Skills

• CSS
• Python