ETL Developer - ODI Developer

The ETL Developer - ODI Developer plays a critical role in the data management ecosystem of the organization. You will focus on the extraction, transformation, and loading of data using Oracle Data Integrator (ODI), ensuring accurate and timely data availability across various systems. Collaborating closely with data analysts and business stakeholders, you will design robust data flows and optimize existing ETL processes. Your deep understanding of data warehousing concepts and proficiency with SQL and ODI tools are essential for maintaining the integrity, efficiency, and performance of our data systems. Your contributions will empower teams with reliable data insights for strategic decision-making and support data-driven initiatives. Key Responsibilities - Design and develop ETL processes using Oracle Data Integrator. - Extract data from various sources such as SAP, CSV files, and databases. - Transform data based on business rules and requirements. - Load data into target data warehouses and data marts. - Conduct data profiling to ensure data quality and consistency. - Optimize ETL performance and data processing efficiency. - Debug and troubleshoot ETL workflows and data integration issues. - Collaborate with BI analysts to comprehend data requirements. - Implement best practices for ETL development and maintenance. - Document ETL processes and workflows for future reference. - Perform regular maintenance and upgrades on existing data pipelines. - Ensure compliance with data governance and security policies. - Participate in code reviews and promote team knowledge sharing. - Monitor ETL jobs for performance and reliability. - Assist in user training and support related to ETL tools. Required Qualifications - Bachelor's degree in Computer Science, Information Technology, or a related field. - 3+ years of experience in ETL development using Oracle Data Integrator. - Strong knowledge of SQL and database technologies. - Experience with data modeling and data warehousing concepts. - Familiarity with various data source integrations. - Proficiency in performance tuning of ETL processes. - Experience with debugging and performance optimization. - Knowledge of data governance and data quality best practices. - Ability to work collaboratively in a team environment. - Strong analytical and problem-solving skills. - Excellent communication skills, both written and verbal. - Experience with source control tools like Git. - Familiarity with deployment automation tools is a plus. - Certifications in Oracle Data Integrator or similar tools are advantageous. - Ability to manage multiple tasks and deadlines effectively. - Commitment to continuous learning and professional development.,