PostgreSQL / Test Automation / BI Testing

Job Description Teamware Solutions is seeking a versatile and detail-oriented Quality Assurance Engineer with specialized expertise in PostgreSQL, Test Automation, and Business Intelligence (BI) Testing. This role is crucial for ensuring the quality, reliability, and performance of our data-driven applications, BI reports, and automated test frameworks. The successful candidate will work with relevant technologies, contribute to smooth operations, and actively support business objectives through meticulous testing and quality assurance practices. Roles and Responsibilities: Database Testing (PostgreSQL): - Perform comprehensive database testing, including data validation, integrity checks, and back-end testing using PostgreSQL. - Write and execute complex SQL queries to verify data accuracy, identify discrepancies, and validate ETL/ELT processes. - Test stored procedures, functions, and database triggers to ensure correct functionality and performance. Test Automation: - Design, develop, and maintain robust automated test scripts and frameworks for various application layers (UI, API, database). - Identify suitable test cases for automation and integrate automated tests into CI/CD pipelines. - Execute automated test suites, analyze results, and report defects efficiently. BI Testing: - Develop and execute detailed test plans and test cases for Business Intelligence (BI) reports, dashboards, and data visualizations. - Verify the accuracy, consistency, and completeness of data presented in BI solutions against source systems and business rules. - Conduct performance testing on BI reports to ensure optimal loading times and responsiveness. - Validate data models, aggregated data, and complex calculations within BI tools. Analysis, Development & Troubleshooting: - Conduct thorough analysis of business and technical requirements to define comprehensive test strategies and test cases. - Actively participate in the full software development and testing lifecycle, from requirements analysis to deployment and post-release validation. - Identify, document, prioritize, and track defects, working closely with development teams for timely resolution. - Perform root cause analysis for identified issues and contribute to preventive measures. Documentation & Reporting: - Create and maintain detailed test plans, test cases, test data, and comprehensive test reports. - Provide clear and concise communication regarding test progress, risks, and findings to project stakeholders. Collaboration: - Work closely with developers, business analysts, data engineers, and other QA team members to ensure a holistic approach to quality. - Understand and contribute to agile development methodologies. Preferred Candidate Profile: Technical Skills: - Strong proficiency in PostgreSQL for database querying, testing, and understanding schema. - Solid experience in Test Automation, including designing and implementing automation frameworks using industry-standard tools (e.g., Selenium, Cypress, Playwright) and programming/scripting languages (e.g., Python, Java, JavaScript). - Demonstrable expertise in BI Testing, with experience validating reports, dashboards, and data pipelines using BI tools (e.g., Tableau, Power BI, Qlik Sense). - Proficiency in writing complex SQL queries for data validation and analysis. - Familiarity with ETL/ELT processes and data warehousing concepts. - Experience with test management tools (e.g., JIRA, Azure DevOps, TestRail). - Knowledge of API testing tools (e.g., Postman, SoapUI) is a plus. Analytical & Problem-Solving: - Excellent analytical skills with a meticulous attention to detail to uncover subtle data discrepancies and software defects. - Strong problem-solving abilities to diagnose complex issues across database, application, and BI layers. Communication & Collaboration: - Exceptional verbal and written communication skills to articulate technical findings to both technical and non-technical audiences. - Proven ability to work effectively in a collaborative, cross-functional team environment. Quality Mindset: - Strong understanding of software testing methodologies, quality assurance best practices, and the Software Development Life Cycle (SDLC). - A proactive attitude towards ensuring high-quality product delivery. Education: - Bachelor's degree in Computer Science, Information Technology, or a related technical field.