Company Overview

Astrosoft Technologies, founded in 2004 and based in Florida, is recognized for its expertise in data, analytics, cloud, and AI/ML among other areas. Known for putting the customer first and taking ownership in project execution, Astrosoft has been consistently acknowledged by clients as a premier partner. The company, a part of the Information Technology & Services industry, prides itself on top-tier talent, a robust project execution framework, and an impeccable delivery record.

Job Overview

Astrosoft Technologies is seeking a seasoned Oracle Data Integration professional for a Senior-level position in Hyderabad. This full-time role requires extensive experience of up to 10 years. The candidate will be responsible for leveraging their skills in data integration to enhance business processes and optimize project outcomes for the company. The job demands the ability to work with various data management solutions.

Qualifications and Skills

• Proven experience in Oracle Database management, ensuring efficient storage, retrieval, and analysis of data.
• Strong understanding of data mapping, the process of matching fields from one database to another for transformation and processing.
• Hands-on experience with ETL processes (Mandatory skill), ensuring extraction, transformation, and loading of data is seamless and accurate.
• Advanced proficiency in SQL (Mandatory skill), necessary for querying and managing data across various relational databases.
• Solid skills in PL/SQL (Mandatory skill), enabling the writing of complex database scripts for data manipulation and business logic implementation.
• Expertise in data transformation techniques, enabling the conversion of data from its raw format into another structured format for analysis.
• Strong attention to data quality, ensuring that information is accurate, consistent, and suitable for its intended purpose.
• Experience in implementing and managing data warehousing solutions to centralize and maintain data from multiple sources.

Roles and Responsibilities

• Design, develop, and maintain Oracle data integration solutions to meet evolving business and technology requirements.
• Conduct thorough data analysis and mapping for integration purposes, ensuring data quality and accuracy.
• Collaborate with stakeholders to identify business requirements and translate them into technical specifications.
• Implement best practices for ETL processes, optimizing data flow, and ensuring timely data loading.
• Monitor database performance, troubleshoot issues, and implement necessary optimizations and improvements.
• Ensure high levels of data availability and quality consistent with company standards and regulations.
• Provide mentorship and technical guidance to junior team members and promote knowledge-sharing across the team.
• Contribute to continuous improvement efforts, recommending enhancement opportunities in data architecture and integration processes.