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:

- Strong knowledge of SQL, including the ability to write complex queries, stored procedures, and triggers.

- Experience with SSIS or any other ETL tool (e.g., Informatica, Talend, Pentaho).

- Expertise in creating and optimizing ETL workflows, automating data loads, and transforming large datasets.

- Experience with database management systems (e.g., SQL Server, Oracle, MySQL).

- Knowledge of data modeling and database design concepts.

- Familiarity with data warehousing concepts and best practices.

- Experience with performance tuning and query optimization.

- Strong problem-solving skills and ability to debug complex database issues.

- Understanding of version control systems and Agile development methodologies.

- Experience with cloud-based ETL tools or cloud data platforms (Azure Data Factory, AWS Glue, etc.) is a plus.