Junior SQL Developer/Software Integration Specialist

Job Overview

Key Responsibilities

• Write and optimize SQL queries for database management and reporting.
• Support the creation and maintenance of database queries and scripts to meet business requirements.
• Analyze data to identify trends, patterns, and discrepancies, ensuring accurate reporting and data analysis.
  

PowerBuilder Support

• Assist in maintaining and supporting PowerBuilder applications and reports.
• Troubleshoot and resolve issues related to PowerBuilder and its integration with databases.
• Help in the development and enhancement of applications built on PowerBuilder.
  

API Integration

• Work with APIs to integrate software systems for seamless data flow and functionality.
• Assist in integrating third-party APIs with internal applications and databases.
• Help maintain and troubleshoot API integration issues and provide support to ensure continuous data exchange between systems.
  

Power Query (UI-Based Tool)

• Utilize Power Query to import, transform, and manage data for business intelligence reporting.
• Help prepare datasets and reports using Power Query and ensure the integrity of data.
• Assist in UI-based queries and the setup of automated workflows for data processing.
  

Collaboration

• Collaborate with team members, developers, and business analysts to understand and define project - requirements.
• Provide support in the deployment, testing, and troubleshooting of software integrations.
  

Required Skills & Qualifications

• A degree in Computer Science, Information Technology, or a related field.
  

Technical Skills

• Basic knowledge of SQL queries and relational database management systems (RDBMS).
• Familiarity with PowerBuilder or willingness to learn and work with it.
• Understanding of API Integration concepts, REST APIs, and web services.
• Basic experience with Power Query (UI-based data manipulation tool) is a plus.
  

Soft Skills

• Strong problem-solving and analytical skills.
• Ability to communicate effectively with team members and stakeholders.
• Willingness to learn and adapt to new technologies.
• Strong attention to detail and commitment to quality work.
  

Preferred Qualifications

• Some experience or academic projects involving database management or API integrations.
• Exposure to PowerBuilder, Power Query, or similar development tools.
• Basic knowledge of Power Bi, Data visualization tools and reporting tools will be added advantage.