Interesting Opportunity SQL Developer - Data
- Kpr sugar apperals
- 4 to 8 Yrs
- Jamshedpur
- 3 months ago
- Email to a friend
- Report this job
Job Description
- 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),
Employement Category:
Employement Type: Full timeIndustry: IT Services & Consulting
Role Category: Not Specified
Functional Area: Not Specified
Role/Responsibilies: Interesting Opportunity SQL Developer - Data
Contact Details:
Company: TechnoRightLocation(s): Jamshedpur
+ View Contact
Keyskills: SQL SSIS ETL Query Tuning Data Modeling Database Design Data Warehousing Performance Tuning Agile Methodologies
Fraud Alert to job seekers!
₹ Not Specified
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in