13 Aug
|
QUANTEON SOLUTIONS
|
Secunderabad
13 Aug
QUANTEON SOLUTIONS
Secunderabad
Key Responsibilities:
- SQL Query Development & Optimization:
- Design, develop, and maintain complex SQL queries, stored procedures, functions, and views.
- Optimize existing queries to enhance performance and efficiency when dealing with large datasets.
- Collaboration with Stakeholders:
- Work closely with data analysts, developers, and stakeholders to understand business requirements and translate them into robust SQL-based solutions.
- ETL Process Design & Implementation:
- Design and implement ETL (Extract, Transform, Load) processes to move and transform data between various systems, ensuring data is properly cleaned and organized.
- Data Validation & Troubleshooting:
- Perform data validation, troubleshooting, and quality checks to ensure data accuracy and integrity across systems.
- Database Maintenance & Improvement:
- Maintain and improve existing databases while ensuring data integrity, security, and accessibility.
- Monitor database performance, identify bottlenecks, and recommend improvements to keep systems efficient.
- Documentation:
- Document code, processes, and data models to support scalability and maintainability for future development.
- Support for BI Tools:
- Work with Business Intelligence (BI) tools and support the development of dashboards and reports as needed for analytics purposes.
Requirements:
- Experience:
- 3+ years of proven experience as an SQL Developer or in a similar data engineering role.
- Strong SQL Skills:
- Expert-level knowledge of SQL and relational database systems (e.g., MS SQL Server, PostgreSQL, MySQL,
Oracle).
- Proficiency in writing complex queries and working with large, complex datasets.
- Experience with performance tuning to optimize queries.
- ETL Tools & Data Pipelines:
- Experience designing and implementing ETL processes to move and transform data.
- Data Warehousing & BI:
- Familiarity with data warehousing concepts and experience with BI reporting and data analytics.
- Database Security & Backup:
- Solid understanding of database security, as well as backup and recovery procedures.
- Problem-Solving & Attention to Detail:
- Robust problem-solving skills with a keen attention to detail.
- Communication Skills:
- Good communication skills and ability to work collaboratively in a team environment.
Nice to Have:
- Cloud Databases:
- Experience with cloud-based databases such as AWS RDS, Google BigQuery, or Azure SQL.
- Scripting/Analytics Tools:
- Knowledge of Python, Power BI, or other scripting/analytics tools for data processing and reporting.
- Agile or Scrum Experience:
- Experience working in Agile or Scrum environments, contributing to iterative and rapid development cycles.
Key Skills:
- SQL (e.g., MS SQL Server, PostgreSQL, MySQL, Oracle)
- ETL (Extract, Transform, Load) processes
- Data Visualization & BI Reporting tools (Power BI)
- Data Analytics and Data Structures
- Cloud Databases (AWS RDS, Google BigQuery, Azure SQL)
- Python for scripting and automation
- Database Optimization & Performance Tuning
- Data Security, Backup, and Recovery
📌 Software Engineer (Secunderabad)
🏢 QUANTEON SOLUTIONS
📍 Secunderabad