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.