SQL Developer - Data Analytics

Job Description :

Job Responsibilities :

• Design, develop, and maintain efficient database solutions using SQL Server, SSIS (SQL Server Integration Services), or other ETL tools.
• Create and manage ETL processes to extract, transform, and load data from multiple sources into databases or data warehouses.
• Develop stored procedures, views, functions, and triggers to support application development.
• Optimize database performance by tuning queries, indexes, and other database components.
• Collaborate with data architects, business analysts, and other teams to ensure that business needs are met through data solutions.
• Create and schedule SSIS packages to automate data workflows.
• Troubleshoot and resolve database performance, data integrity, and data quality issues.
• Ensure proper documentation of database architecture, ETL processes, and reporting requirements.
• Maintain data security and compliance standards, ensuring data privacy regulations are adhered to.
• Implement and maintain database backup, recovery, and disaster recovery strategies.
• Oracle PLSQL Development experience in Oracle SQL Performance Query Tuning
• Good understanding of Oracle Architecture
• Strong experience in writing Functions Procedures packages Function etc
• Strong experience in writing complex SQL Queries using Joins Hints indexes etc
• Should have worked on different file handling techniques SQL Loader UTL File External Tables etc
• Should be aware of Oracle 11g features
• Should have worked on Analytical functions Collections Bulk Data operation etc
• Help write and optimize in-application SQL statements.
• Ensure performance, security, and availability of databases.
• Prepare documentations and specifications.
• Profile server resource usage and optimize and tweak as necessary.
• Collaborate with other team members and stakeholders.
• Translate business needs to technical specifications.
• Design, build and deploy BI solutions (e.g. reporting tools).
• Maintain and support data analytics platforms (e.g. MicroStrategy).
• Create tools to store data (e.g. OLAP cubes)
• Conduct unit testing and troubleshooting.
• Evaluate and improve existing BI systems.
• Collaborate with teams to integrate systems.

Skills and Qualifications :

(ref : hirist.tech)