JOB DESCRIPTION
Location: Hybrid | Raleigh, NC, USA
Duration: 11 months
Our client, a leading financial institution in Raleigh, NC is looking for a Quality Assurance Analyst (Datawarehouse) to research and evaluate data to make recommendations to management about ways to improve data storage, reporting, and other business issues.
Typical Day in role:
Execution and Operational Excellence
- Significant contribution to project/program test strategies and plans
- Responsible for the adoption of quality engineering practices
- Provide feedback on the quality of deliverables and escalate issues
Projects and Initiatives
- Accountable for developing a deep understanding of systems, solutions, and technology associated with the systems in scope
- Accountable for developing deep domain knowledge and business logic, processes, flows, data flows, and rules, for areas in scope
- Responsible for reviewing requirements and business functions and constructing data flows to map intended system behavior including data boundary conditions to optimize maximum coverage
- Responsible for following defined QE processes and tools usage and intent
- Responsible for creating/executing and maximizing automation of complex test cases for assigned programs/projects through the application lifecycle, including multi-level tests to exercise full functionality of an AUT, e.g. service-level, component, and UI tests (functional)
- Responsible for following agreed-upon processes for test results storage, defect tracking, and defect verification and supporting project metrics tracking
- Strong MSSQL and Oracle PL/SQL skills, and/or equivalent database experience
- Responsible for raising quality issues
- Partners across IT and with assigned business lines to test new or existing software to ensure functional requirements are met.
Must-Have Skills:
- Experience with testing ETL processes using tools like Informatica or DataStage, and validating data transformation, integrity, and quality within a data warehouse environment
- Proficient in writing and executing SQL queries for data validation, creating and maintaining test plans, test cases, and test scripts, as well as automating data warehouse testing using tools like Selenium, JMeter, or Python scripts
- Hands-on expertise in data profiling tools to identify anomalies, performance testing of data warehouse components, and validating data accuracy and processing efficiency
- Familiar with data modeling concepts, database design principles, and cloud-based data warehousing solutions like Snowflake
- Proficient in version control tools like GIT for managing test scripts and documentation, and defect tracking tools for reporting and managing defects
- Experienced in validating reports by ensuring data accuracy, consistency, and completeness in business intelligence tools like Tableau, and troubleshooting and resolving data discrepancies and report generation issues
- Experience in Datawarehouse (ETL) Testing (Tools and Techniques)
Nice-To-Have Skills:
- Certifications: ISTQB Computer Engineering
Soft Skills Required:
- Strong analytical and problem-solving skills to identify, troubleshoot, and resolve data issues effectively across UI and API testing as well as data migration processes
- Excellent communication and collaboration abilities to work effectively with cross-functional teams, understand requirements and clearly convey testing results and insights
- Detail-oriented with a strong focus on accuracy and thoroughness in testing, ensuring high data quality and integrity
Education:
- Bachelor Degree
Finance professional is committed to creating an inclusive environment where all team members and clients feel like they belong. We seek applicants with a wide range of abilities and we provide an accessible candidate experience. We advocate for you and welcome anyone regardless of race, color, religion, national origin, sex, physical or mental disability, or age.