The Senior Technical Specialist in Oracle PL/SQL will be responsible for the technical design, development, and maintenance of Oracle PL/SQL code. They will contribute to the implementation and enhancement of Oracle databases, ensuring optimal performance and data integrity.
Talend JD:
Design, develop, and maintain Talend ETL/ELT solutions integrating data from Oracle, Snowflake, and other sources
Implement effective data pipelines leveraging Talend and Snowflake for large scale data processing and analytics
Develop and customize Talend jobs using Java and Python for complex transformations and automation
Optimize SQL queries and ETL workflows for performance, scalability, and data quality
Provide production support, troubleshoot issues, and ensure reliable data delivery
Mentor junior developers and enforce best practices and coding standards
Key Responsibilities
Develop and maintain complex oracle pl/sql procedures, functions, packages, and triggers
Collaborate with cross functional teams to analyze requirements and design effective database solutions
Optimize sql queries and database code for performance improvements
Troubleshoot and resolve database issues in a timely manner
Implement data security protocols and ensure compliance with data protection regulations
Perform database tuning and capacity planning activities
Create technical documentation and provide guidance to junior team members
Skill Requirements
Proficient in oracle pl/sql programming, including stored procedures, functions, and triggers
Solid experience in designing and optimizing oracle databases
Knowledge of performance tuning techniques for sql queries
Familiarity with data security and compliance standards
Excellent problem-solving skills and attention to detail
Good communication and teamwork abilities
Bachelor's degree in computer science, engineering, or a related field