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
Security • Cybersecurity
Own global revenue recognition under ASC 606 and accounting processes including commissions, COGS, and leases. Review tax provisions, returns, transfer pricing, and subsidiary filings; support external audits and cross-functional reporting. Lead accounting projects, process improvements, and AI-driven workflow automation. Requires a CA, Big 4 high-tech experience, strong US GAAP and revenue recognition knowledge, ERP experience, advanced Excel skills, and excellent communication.
Top Skills:
Ai Automation ToolsAsc 340-40Asc 606ExcelMS OfficeNetSuiteUs Gaap
Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Perform software verification and validation for embedded aerospace platform components. Develop test plans, conduct requirement- and scenario-based testing, execute change impact analyses, resolve technical issues, support audits, and collaborate with stakeholders. The role requires embedded C/C++ and RTOS expertise, emulator and debugger experience, testing tools, technical leadership, and stakeholder management.
Top Skills:
BitbucketC++DeosDoors NgEmbedded CIcdJIRALauterbachLdraLinuxRtosVectorcast/Cover
Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Develops and executes verification plans and test cases for embedded platform software. Performs requirements-based and scenario-based testing, change impact analysis, debugging, technical issue resolution, audits, and continuous improvement. Collaborates with stakeholders and cross-functional teams while guiding engineers and supporting quality, cost, and schedule objectives.
Top Skills:
As9100BitbucketCC++DeosDoors NgEmbedded SystemsIcdJIRALauterbachLdraLinuxRtosVectorcast/Cover
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
