Astrosoft - Senior ODI Developer

Job Title: Senior ODI Developer About the Job : Astrosoft Technologies, an award-winning leader in Data, Analytics, Cloud, AI/ML, and Digital solutions, is seeking a highly experienced and motivated Senior Oracle Data Integrator (ODI) Developer to join our growing team in Hyderabad. As a Senior ODI Developer, you will play a critical role in designing, developing, and maintaining robust ETL solutions for our clients, ensuring data integrity and optimal performance. We are looking for a professional with a strong understanding of data warehousing concepts, extensive experience with Oracle technologies, and a proven track record of delivering successful ETL projects. Role: Oracle Data Integrator 12C (ODI) Developer Location: India, Onsite, Hyderabad, Gachibowli (Hybrid: 3 Days Work From Office) Job Type: Full Time Shift Timings: 12:30 PM to 9:30 PM IST Experience Range: 5 years Key Responsibilities : - Design, develop, and implement complex ETL processes using Oracle Data Integrator 12c. - Develop and maintain data warehouse solutions, ensuring data quality and consistency. - Write and optimize complex SQL and PL/SQL queries for data extraction, transformation, and loading. - Identify and resolve performance bottlenecks in ETL processes and database queries. - Design and document ETL mappings, interfaces, and workflows. - Work closely with database administrators to ensure optimal database performance and data integrity. - Utilize Git for version control and collaborative development. - Diagnose and resolve issues related to ODI processes and data integration. - Collaborate with business analysts and stakeholders to gather and analyze requirements. - Create and maintain technical documentation for ETL processes and data mappings. - Adhere to best practices for ETL development and data warehousing. - Perform and participate in code reviews to ensure code quality and maintainability. - Mentor junior developers and share knowledge of ODI and data warehousing concepts. Required Skills and Qualifications : - Master's degree in Computer Science, Information Technology, or a related field. - Minimum of 5 years of experience in Oracle Data Integrator (ODI) development. - Extensive experience with Oracle Data Integrator 12c, including knowledge of interfaces, packages, procedures, and scenarios. - Advanced knowledge of SQL and PL/SQL, with the ability to write complex queries and stored procedures. - Strong understanding of data warehousing concepts, including dimensional modeling, star schema, and snowflake schema. - In-depth knowledge of Oracle Database, including performance tuning and database administration. - Experience with other ETL tools is a plus. - Performance Tuning: Proven ability to identify and resolve performance issues in ETL processes and database queries. - Proficiency in using Git for version control. - Strong analytical and problem-solving skills. - Excellent verbal and written communication skills. - Ability to work effectively in a team environment. Desired Skills and Experience : - Experience with cloud-based data warehousing solutions. - Knowledge of data governance and data quality principles. - Experience with other Oracle technologies (Oracle GoldenGate, Oracle Analytics Cloud). Benefits from Astrosoft Technologies : H1B Sponsorship (Depends on Project & Performance) Lunch & Dinner (Every day) Health Insurance Coverage- Group Industry Standard Leave Policy Interview Process : 2 Technical Rounds (1st Internal Round & 2nd Customer Round) Background Verification (BGV) (ref:hirist.tech)

Location: hyderabad, IN

Posted Date: 3/26/2025