QA Data Mart Testing - Python, SQL, ETL

Job Description

Essential Skills :

• Should have experience testing multiple test phases in medium to large projects.
• Understanding of information governance principles and how they could apply in a testing capacity.
• Should have adequate experience and clear understanding of data warehouse and data mart testing. Identification and Test Data Preparation Techniques.
• Ability to transform complex Business logic into SQL or PL / SQL queries.
• Thorough knowledge of Software Test Life Cycle, Test Case Life Cycle, Defect Life Cycle etc.
• Creating requirements traceability matrix (RTM)
• Proficiency with Test Case Preparation and Execution.
• QA Automation Test tools expertise using Python.
• Extensive exposure to ETL testing with high-level of SQL skills is required.
• Should have exposure to large data sets and understand Data Quality Framework.
• Experience in data analysis, including profiling, auditing, balancing, and reconciliation, in an Information technology operating environment.
• Defect tracking experience (i.e., Jira, ALM, etc.)
• Experience in tuning SQL queries, Stored Procedures, Views, etc. for performance improvements
• Should be detail oriented with analytical mind set.
• Knowledge of data models and entity relationship diagrams.
• Must have the ability to multi-task and adapt quickly to changes while maintaining urgency in completing assigned tasks.

Requirements

Experience (Years) : 8-10 Essential Skills : Hands-on working experience architecting Guidewire ClaimCenter solutions, including customization and integration.

Guidewire certification is a plus.Other technologies of interest : Guidewire Cloud, Salesforce CRM, legacy modernization, and AWS.

Proven knowledge & architecture experience in, architecture (digital / digital marketing / micro / macro / monolithic services, APIs), application integration, service-oriented architecture, event-driven architecture, application architecture, distributed architecture, data architecture and modelling.

Proven experience with modelling languages & techniques. Can quickly comprehend the functions and capabilities of new technologies.

Can understand the long-term ("big picture") and short-term perspectives of situations. Strong technical background (platforms, languages, protocols, frameworks, open source, etc.

Experience with architecture frameworks (TOGAF) & architecture certifications a plus.Experience in engaging and supporting claims teams and understanding their day-to-day operations in the P&C insurance space.

Open and clear connect with the business, telecom, infrastructure, security, audit, vendors, and software engineering. Driven by challenges and results.

Organized, proactive and a motivation for change.Knowledge on security standard methodologies and understand the impacts it can have on a business.

Comfortable working in a constantly evolving technological environment.An excellent teammate who demonstrates leadership.

Comfortable speaking with all levels of the organization and different audiences.