Prep.Study - SQL Developer

Job Description : - Proven experience as an SQL Developer - Develop and Maintain PL/SQL Code : Design, code, and maintain PL/SQL procedures, functions, packages, and triggers to support application functionality and data integration. - Database Optimization : Perform performance tuning and optimization of SQL queries and PL/SQL code to ensure efficient execution and resource utilization. - Should be able to decode the SQL : Stored Procedures and do documentation - Experience with database design, implementation, and maintenance - Strong expertise in SQL Server Integration Services (SSIS) - Ensure data quality and integrity through proper validation and cleansing processes. - Actively participate in the full software development lifecycle, including planning, design, coding, testing, and deployment. - Data Analysis and Reporting : Develop and maintain reports, dashboards, and data extracts to support business analysis and decision-making processes. - Troubleshooting and Debugging : Identify and resolve issues related to SQL code, database performance, and application functionality. - Collaboration : Work closely with other developers, analysts, and business stakeholders to understand requirements and deliver effective solutions. - Documentation : Create and maintain technical documentation for PL/SQL code, database structures, and procedures to ensure clarity and knowledge sharing - Compliance and Best Practices : Adhere to industry best practices and company standards for database development, security, and data management - Must Have Strong SQL knowledge, strong SSIS, ETL knowledge & Ability to coordinate with end-users, business analysts, and other stakeholders. - Excellent problem-solving and analytical skills. - Effective communication and leadership skills. - Proven ability to work independently and collaboratively. (ref:hirist.tech)

Location: in, IN

Posted Date: 11/24/2024