We are seeking a skilled Data Analyst with strong expertise in PL/SQL, MSSQL, and ETL processes to join our growing team. The ideal candidate will be responsible for developing, optimizing, and maintaining database solutions that support business-critical applications and data workflows.
Key Responsibilities:
- Design, develop, and maintain stored procedures, functions, triggers, and views using PL/SQL and MSSQL.
- Develop and optimize ETL processes to extract, transform, and load data between various systems.
- Monitor database performance and ensure data integrity, availability, and security.
- Collaborate with business analysts, developers, and data engineers to support application development and reporting needs.
- Troubleshoot and resolve database-related issues, ensuring minimal downtime.
- Prepare technical documentation and support system upgrades or migrations when required.
Requirements:
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- 2–6 years of hands-on experience with PL/SQL and MSSQL.
- Strong knowledge of ETL tools/processes and data integration techniques.
- Proficiency in writing complex SQL queries and optimizing query performance.
- Good understanding of database design, normalization, and indexing strategies.
- Strong analytical, problem-solving, and communication skills.
Nice to Have:
- Experience with cloud-based databases (e.g., Azure SQL, AWS RDS, GCP).
- Familiarity with BI tools (e.g., Power BI, Tableau).
- Knowledge of scripting languages (Python, Shell, etc.) for data automation.