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. (ref:hirist.tech)

Location: in, IN

Posted Date: 4/2/2025