ETL ODI Developer

Overview:

Key Responsibilities:

• Designing and developing ETL processes using Oracle Data Integrator (ODI) for data extraction transformation and loading.
• Collaborating with crossfunctional teams to gather and analyze data requirements.
• Performing data modeling schema design and performance tuning for ETL processes.
• Conducting data profiling and quality assessments to ensure accurate data integration.
• Implementing data validation and reconciliation processes to maintain data consistency.
• Developing and maintaining ETL documentation and data mapping documents.
• Participating in code reviews testing and debugging of ETL processes.
• Providing technical support and troubleshooting for ETL jobs and processes.
• Collaborating with business stakeholders to understand and address data integration needs.
• Monitoring and optimizing ETL workflows and job schedules.
• Adhering to best practices for data integration data warehousing and ETL development.

Required Qualifications:

• Bachelors degree in Computer Science Information Technology or related field.
• Proven experience in designing and developing ETL processes using Oracle Data Integrator (ODI).
• Strong proficiency in SQL and database concepts.
• Experience with data modeling and schema design for data warehousing.
• Proficiency in performance tuning and optimization of ETL processes.
• Understanding of data integration and ETL best practices.
• Ability to work effectively in crossfunctional teams and collaborate with diverse stakeholders.
• Excellent problemsolving and analytical skills for troubleshooting ETL issues.
• Strong communication skills and the ability to effectively convey technical information to nontechnical stakeholders.
• Knowledge of industrystandard data warehousing and ETL tools and technologies.

etl,data integration,sql,data warehousing