PL/SQL Developer TheCophil

About TheCophil

Job Description

Job Title: PL/SQL Developer Chennai, OMR CTC: 6.5 to 7LPA Interview Mode : 1) Virtual Interview 2) Telephonic Interview 3) Face to Face Interview Gender: Male Mandatory Skillset: ETL Datamigration SQL Queries Oracle Databased tool Toad / SQL Developer Key Responsibilities Develop, test, and maintain complex PL/SQL packages, procedures, functions, and triggers for data processing and ETL tasks. Design and implement database schemas and objects such as tables, indexes, and views. Analyze business requirements and translate them into technical solutions using PL/SQL. Optimize SQL queries and database performance for high efficiency. Perform data analysisto support report generation and modify existing reports as needed. Develop migration scripts for data transfer between systems. Ensure compliance with security standardsto protectsensitive data. Provide technicalsupport for production systems, including troubleshooting and resolvingissues. Documenttechnicalspecifications and create reusable code forscalability. Required Skills Technical Skills: Proficiency in Oracle PL/SQL programming with experience in developing stored procedures, functions, and triggers. Strong understanding of relational database concepts(RDBMS) and performance tuningtechniques. Experience with ETL processes and data warehouse integration. Knowledge of advanced PL/SQL features like collections, ref cursors, dynamic SQL, and materialized views. Familiarity with toolslike SQL Developer, Toad, orsimilarIDEs. Exposure to Unix/Linux scripting is a plus. Soft Skills: Strong analytical and problem-solving abilities. Excellent communication skillsto interact with stakeholders and team members effectively. Attention to detail with a focus on accuracy in coding and testing. Ability to work both independently and in a team environment. Qualifications Bachelors degree in computerscience, Information Technology, or a related field (or equivalent experience) Proven experience (3.5 to 4+ years) in Oracle PL/SQL development Job Types: Full-time, Permanent Benefits: Paid sick time Paid time off Work from home Schedule: Day shift Experience: PL/SQL: 3 years (Required) Data migration: 2 years (Required) ETL: 2 years (Required) Location: Chennai, Tamil Nadu (Preferred) Work Location: In person,