odi developer - Hyderabad, India - Astrosoft Technologies

    Astrosoft Technologies
    Astrosoft Technologies Hyderabad, India

    1 week ago

    Default job background
    Technology / Internet
    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:

    1. 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.
    1. 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.
    1. 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.
    1. 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.
    1. 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.
    1. 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.
    1. 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.

    Qualifications:

    • 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.