Database Specialist

Aissel Technologies; Gokul; On-site; INR 350,000 - 650,000; Full time

Job summary

Aissel Technologies is seeking a Database Specialist to optimize loading into databases, ensure data integrity, and improve performance. The role emphasizes ETL, data quality, and collaboration with data analysts and DBAs.

Ideal candidates will have SQL proficiency, experience with open-source DBMS, and familiarity with cloud databases (AWS/Azure). Data warehousing knowledge and programming in Python or PHP are a plus.

Qualifications

• 1+ years of database management experience with data loading or ETL.
• Proficiency in SQL and experience with open-source DBMS.
• Strong analytical and problem-solving abilities.
• Familiarity with data integration tools and data warehousing concepts.
• Detail-oriented with focus on data quality.
• Good communication and teamwork.
• Experience with cloud databases (e.g., AWS, Azure).
• Programming experience in Python or PHP for data manipulation.
• Knowledge of data security and compliance requirements.

Responsibilities

• Data Loading: Design and implement efficient data loading processes for various databases (e.g., MySQL, PostgreSQL).
• Monitor and optimize the performance of data load activities.
• ETL Processes: Develop, maintain, and optimize ETL processes to ensure accurate data migration and transformation.
• Data Quality Assurance: Conduct data validation and integrity checks post-load to ensure accuracy.
• Identify and resolve data discrepancies or issues.
• Collaboration: Work with data analysts, DBAs, and stakeholders to understand data requirements.
• Participate in cross-functional teams to support data-driven projects.
• Troubleshooting: Diagnose and resolve issues related to data loading and database performance.
• Implement solutions to improve efficiency and reliability.

Skills

SQL

Data loading

ETL processes

Data quality

Data warehousing

Analytical skills

Team collaboration

Cloud databases

Python

PHP

Tools

MySQL

PostgreSQL

AWS

Azure

Airflow

Job description

We are seeking a Database Specialist to manage and optimize the loading of data into our databases. This role will be critical in ensuring data integrity, performance, and timely updates. The ideal candidate will have a strong understanding of database systems, ETL processes, and data transformation techniques

Responsibilities

1. Data Loading:
   1. Design and implement efficient data loading processes for various databases (e.g., MySQL, PostgreSQL, etc.).
   2. Monitor and optimize the performance of data load activities.
2. ETL Processes:
   1. Develop, maintain, and optimize ETL processes to ensure accurate data migration and transformation.
3. Data Quality Assurance:
   1. Conduct data validation and integrity checks post-load to ensure accuracy.
   2. Identify and resolve data discrepancies or issues.
4. Collaboration:
   1. Work closely with data analysts, database administrators, and other stakeholders to understand data requirements and ensure successful implementation.
   2. Participate in cross-functional teams to support data-driven projects.
5. Troubleshooting:
   1. Diagnose and resolve issues related to data loading and database performance.
   2. Implement solutions to improve efficiency and reliability.

Essential Skills

• 1+ years of experience in database management, understanding of data loading, or ETL processes.
• Proficiency in SQL and experience with various open-source database systems.
• Strong analytical and problem-solving skills.
• Familiarity with data integration tools is a plus.
• Knowledge of data warehousing concepts and methodologies.
• Detail-oriented with a commitment to data quality.
• Strong communication skills and the ability to work in a team environment.
• Experience with cloud database solutions (e.g., AWS, Azure).
• Familiarity with programming languages (e.g., Python, PHP) for data manipulation.
• Understanding of data security and compliance requirements.