Company Overview

Astrosoft Technologies, established in 2004, is a premier information technology and services company headquartered in Florida. Renowned for its expertise in Data, Analytics, Cloud, and AI/ML, Astrosoft is celebrated for its customer-first approach and exceptional project delivery. With a highly skilled team of 51-200 employees, the company prides itself on its structured project execution and unparalleled industry reputation. For more information, visit Astrosoft Technologies.

Job Overview

Astrosoft Technologies is seeking a Mid-Level Oracle Data Integrator (ODI) for a full-time position based in Hyderabad. The ideal candidate will have strong expertise in Oracle Data Integrator, SQL, and PL/SQL. This role involves developing and managing data integration solutions and requires experience in ETL development, Java, ODI Studio, and Data Warehousing. The position offers an exciting opportunity to work within Astrosoft's dynamic and innovative environment.

Qualifications and Skills

• Proficiency in Oracle Data Integrator with the ability to design, develop, and implement robust data integration solutions (Mandatory skill).
• Strong competence in SQL and PL/SQL, including the ability to write and optimize complex queries and manage database systems (Mandatory skill).
• Experience with ETL development processes and methodologies to efficiently extract, transform, and load data into data warehouses or other systems.
• Knowledge of Java programming to facilitate integration tasks within Oracle environments and enhance ODI functionality.
• Familiarity with ODI Studio, with expertise in creating and configuring packages, procedures, and load plans.
• Experience in data warehousing concepts and architectures to effectively store and manage large volumes of data.
• Understanding of cloud integration services to support and implement cloud-based data solutions.
• Excellent problem-solving and analytical skills to identify and resolve data integration and transformation challenges.

Roles and Responsibilities

• Develop and maintain Oracle Data Integrator (ODI) solutions to support business data strategies and reporting needs.
• Collaborate with cross-functional teams and stakeholders to understand data requirements and ensure data quality and consistency.
• Optimize SQL queries and PL/SQL scripts for improved performance of data processing tasks.
• Engage in the complete ETL process, including responsibility for data extraction, transformation, and loading into target environments.
• Conduct regular maintenance and updates of data integration processes to align with evolving business requirements.
• Implement and manage data warehousing solutions that enhance data accessibility and usability.
• Provide technical support and troubleshooting for data integration and transformation issues.
• Contribute to process improvements and innovative solutions to enhance data integration capabilities within the organization.