Designs and maintains SSIS ETL packages, Oracle PL/SQL procedures, packages, and triggers. Manages data integration workflows using Oracle Data Integrator, performs unit and system integration testing, validates data accuracy, resolves defects, and prepares technical documentation and test reports.
Oracle PL/SQL & SSIS Developer
Summary
We are seeking a skilled Oracle PL/SQL & SSIS Developer to join our IT Services team. In this pivotal role, you will design, develop, and maintain robust data integration solutions and database procedures. Your expertise will be essential in ensuring data integrity, optimizing complex queries, and facilitating seamless system interoperability. This position is critical for driving our data infrastructure forward, supporting large-scale operations, and delivering high-quality technical solutions that meet rigorous business standards.
Responsibilities
- Design and construct SSIS packages for efficient data extraction, transformation, and loading (ETL) processes.
- Develop and optimize Oracle PL/SQL scripts, including complex packages, stored procedures, and triggers.
- Execute comprehensive unit testing and system integration testing to validate software functionality and performance.
- Perform thorough data validation activities to ensure accuracy and consistency across all datasets.
- Identify, troubleshoot, and resolve data defects and technical issues promptly.
- Utilize Oracle Data Integrator (ODI) for managing data integration workflows.
- Prepare and maintain detailed technical documentation and generate precise test reports.
Requirements
Requirements:
- Proven experience in Oracle database management, specifically with PL/SQL development and package maintenance.
- Strong proficiency in developing and maintaining SSIS packages for enterprise data solutions.
- Hands-on expertise with Oracle Data Integrator (ODI) for data integration tasks.
- Demonstrated ability to conduct unit testing and system integration testing effectively.
- Solid background in data validation techniques and systematic defect resolution.
- Excellent capability in creating technical documentation and formal test reporting.
- Relevant work experience ranging from 5 to 12 years in the specified domain.
Similar Jobs
Events • Food • Travel • Hospitality • Hotels & Resorts
Prepares and cooks menu items under senior chef supervision, manages guest orders, executes recipes, oversees kitchen stations, inspects presentation and quality, maintains sanitation and safety standards, and supports inventory replenishment. The role requires at least one year of cook or trainee experience in a five-star hotel or high-standard restaurant, cuisine knowledge, teamwork, communication, and the ability to work effectively in demanding kitchen conditions.
Events • Food • Travel • Hospitality • Hotels & Resorts
Provides friendly food and beverage service across hotel dining outlets by welcoming guests, taking orders, serving items, maintaining outlet readiness, promoting menu offerings, processing orders, and addressing feedback. Supports table setup, clearing, cleaning, teamwork, food safety, hygiene, alcohol awareness, and workplace safety. Requires strong communication, adaptability, English fluency, shift flexibility, and the ability to stand for extended periods.
Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
Supports payment-system workflows across client onboarding, product enhancements, production support, testing, and releases. Gathers and documents requirements, creates user stories and process flows, coordinates cross-functional stakeholders, supports UAT and defect resolution, investigates production issues, tracks risks and dependencies, and manages operational handovers. Requires flexibility for urgent production issues and planned releases.
Top Skills:
AgileAzure DevopsJIRA
What you need to know about the Hyderabad Tech Scene
Because of its proximity to leading research institutions and a government committed to the city's growth, Hyderabad's tech scene is booming. With plans to establish India's first "AI city," the city is on track to become one of the world's most anticipated tech hubs, with companies like TransUnion, Schrödinger and Freshworks, among others, already calling the city home.
