No more applications are being accepted for this job
- ETL Development:
- Design, develop, and implement ETL solutions using Oracle Data Integrator (ODI) toolset.
- Create and maintain ODI interfaces, mappings, and workflows to extract, transform, and load data from various source systems into target databases.
- Perform data profiling, cleansing, and validation as part of the ETL process.
- PL/SQL Development:
- Write complex PL/SQL code to support ETL processes, including data manipulation, transformation, and validation.
- Develop and optimize stored procedures, functions, and triggers for data processing and business logic implementation.
- Ensure adherence to coding standards and best practices in PL/SQL development.
- Data Modeling and Integration:
- Collaborate with data architects and business analysts to understand data requirements and design appropriate data models.
- Integrate ODI solutions with existing data models and databases, ensuring compatibility and scalability.
- Implement data integration patterns and best practices for efficient data movement and transformation.
- Performance Tuning:
- Identify performance bottlenecks in ETL processes and PL/SQL code and implement optimizations for improved efficiency and scalability.
- Monitor ETL jobs and database performance metrics, tuning parameters as necessary to meet performance objectives.
- Error Handling and Logging:
- Design and implement error handling mechanisms and logging frameworks to capture and manage exceptions during ETL execution.
- Develop reusable components and templates for error handling and logging to streamline development and maintenance.
- Documentation and Maintenance:
- Create technical documentation, including design documents, process flow diagrams, and data mappings.
- Conduct code reviews and participate in quality assurance activities to ensure compliance with coding standards and project requirements.
- Provide ongoing support and maintenance for ETL jobs and PL/SQL code, troubleshooting issues and implementing enhancements as needed.
- Collaboration and Communication:
- Work closely with cross-functional teams, including data analysts, business users, and IT stakeholders, to understand requirements and deliver solutions that meet business needs.
- Communicate effectively with team members and project stakeholders, providing status updates, escalating issues, and seeking clarification as necessary.
- Bachelor's degree in Computer Science, Information Technology, or related field.
- [5+] years of experience in ETL development using Oracle Data Integrator (ODI) and PL/SQL.
- Strong proficiency in ODI toolset, including ODI Studio, ODI Console, and ODI Topology.
- Expertise in writing complex PL/SQL code, including stored procedures, functions, and triggers.
- Solid understanding of relational database concepts and data modeling techniques.
- Experience with performance tuning of ETL processes and SQL queries.
- Familiarity with data warehousing concepts and methodologies.
- Excellent problem-solving and analytical skills.
- Strong communication and interpersonal skills.
- Ability to work independently and collaboratively in a team environment.
odi developer - Hyderabad, India - Astrosoft Technologies
Description
Job Description: ODI Developer with PL/SQL
Position Title: ODI Developer with PL/SQL
Location: [Hyderabad]
Company Overview: [Provide a brief description of the company, its industry, and its goals.]
Responsibilities:
Qualifications: