We are seeking a Specialist with 6+ years of experience in Oracle ETL and scripting to design develop and optimize data integration pipelines
Job Description:
Develop and maintain robust Oracle ETL pipelines to ingest transform and load data from various sources Write effective Oracle SQL and PLSQL scripts to support data processing and automation tasks Perform data validation and ensure data quality and integrity across ETL processes Collaborate with cross functional teams to understand data requirements and deliver scalable solutions Monitor and troubleshoot ETL workflows to ensure pipeline reliability and performance Document ETL processes data mappings and technical specifications Stay updated with the latest Oracle ETL tools and scripting techniques to improve development efficiency
Roles and Responsibilities
Design develop and optimize ETL workflows using Oracle ETL tools and scripting languages Implement error handling logging and ing mechanisms to maintain pipeline robustness Tune SQL queries and PLSQL code for optimal performance on Oracle databases Automate repetitive tasks and data processing using scripting Collaborate with data engineers analysts and stakeholders to translate business requirements into technical solutions Participate in code reviews testing and deployment activities following best practices and SDLC methodologies Mentor junior team members and contribute to knowledge sharing within the Oracle ETL skill cluster