Prep.Study - SQL Developer (5-8 yrs)

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.