Hi
I hope you are doing well.
We have an urgent position listed below. Please send your most recent resume along with the expected rate if you are interested.
Job role: Business Analyst (Insurance Domain) with PL/SQL and Java Framework Knowledge
Location: Canada, Remote
Below is a detailed Job Description for a Business Analyst (Insurance Domain) with PL/SQL and Java Framework Knowledge (6+ Years Experience)
Business Analyst - Insurance Domain
Experience: 6+ Years
The candidate should possess a solid understanding of insurance operations, policy administration, claims processing, underwriting workflows, and regulatory requirements, along with the ability to analyze data, perform SQL-based validations, and collaborate effectively with development and QA teams.
Key Responsibilities
· Business Analysis & Requirement Management
· Gather, analyze, document, and validate business requirements from stakeholders.
· Conduct workshops, interviews, and requirement elicitation sessions.
· Create detailed Business Requirement Documents (BRDs), Functional Requirement Documents (FRDs), user stories, and process flows.
· Translate business needs into clear functional and technical specifications.
· Perform impact analysis for proposed changes and enhancements.
· Ensure traceability of requirements throughout the project lifecycle.
· Insurance Domain Expertise
· Analyze and support business processes related to:
o Policy Administration
o Claims Management
o Underwriting
o Billing and Payments
o Renewals and Endorsements
o Insurance Product Configuration
· Work closely with business users to improve operational efficiency.
· Support regulatory and compliance initiatives affecting insurance products and processes.
· Understand P&C, Life, Health, or Commercial Insurance business processes.
· Data Analysis & PL/SQL
· Write complex SQL queries for data analysis, validation, reconciliation, and reporting.
· Analyze large datasets to identify trends, anomalies, and business insights.
· Work with database teams to review stored procedures, packages, triggers, and functions.
· Validate data migration and transformation activities.
· Support UAT and production issue investigations using Oracle database and PL/SQL.
· Application & Technical Collaboration
· Collaborate with development teams working on Java-based applications.
· Understand application architecture and integration points.
· Participate in solution design discussions and provide functional inputs.
· Review technical designs to ensure alignment with business requirements.
· Coordinate with developers, architects, QA teams, and project managers.
· Testing & Quality Assurance
· Create and review test scenarios and test cases.
· Support SIT, UAT, and regression testing.
· Perform requirement validation and defect triage.
· Ensure delivered solutions meet business expectations.
· Stakeholder Management
· Act as liaison between business users and technical teams.
· Conduct project status meetings and requirement walkthroughs.
· Present findings, recommendations, and business cases to senior stakeholders.
· Manage stakeholder expectations and address business concerns proactively.
Required Qualifications
· Experience
· 6+ years of experience as a Business Analyst.
· Minimum 3-5 years of experience in the Insurance industry.
· Proven experience working on large-scale application development or enhancement projects.
· Experience working in Agile and Waterfall environments.
· Insurance Domain Knowledge
Strong understanding of:
· Policy Administration Systems
· Claims Processing
· Underwriting Operations
· Insurance Product Lifecycle
· Premium Calculation
· Billing & Collections
· Regulatory Compliance Requirements
· Technical Skills
· Strong SQL and PL/SQL expertise.
· Experience querying databases
· Knowledge of stored procedures, packages, triggers, and views.
· Understanding of Java/J2EE-based applications.
· Familiarity with frameworks such as:
o Spring Boot
o Spring MVC
o Hibernate/JPA
o EJB
· Knowledge of REST APIs and system integrations.
· Experience with data mapping and data analysis.
· Tools & Technologies
· SQL Server Database
· SQL Developer / TOAD
· JIRA
· Confluence
· Microsoft Visio
· Azure DevOps
· Postman
· Swagger
· MS Excel
· Preferred Qualifications
· Experience with Guidewire, Duck Creek, Policy Center, Claim Center, or similar insurance platforms.
· Knowledge of cloud platforms (Azure/AWS).
· Experience with API integrations and microservices architecture.
· CBAP, CCBA, PMP, or Agile certifications.
· Prior experience working with distributed or offshore teams.
· Key Competencies
· Requirement Gathering & Analysis
· Business Process Modeling
· Stakeholder Management
· Insurance Domain Expertise
· Data Analysis & Validation
· Problem Solving
· Communication & Presentation Skills
· Agile Methodology
· Risk Analysis
· Documentation & Reporting
· Education
· Bachelor's degree in Business Administration, Computer Science, Information Technology, Engineering, or related field.
· Relevant Business Analysis or Insurance certifications are highly preferred.
· Nice-to-Have Skills
· Knowledge of ETL processes.
· Experience with reporting tools such as Power BI or Tableau.
· Exposure to DevOps and CI/CD pipelines.
· Experience working with microservices and event-driven architectures.
· Basic understanding of XML, JSON, and XSD schemas
--
Shailendra Rajak
Raas infotek corporation
262 Chapman road, Suite 105A, Newark, DE-19702
Phone no. 302-565-0220, Ext. 145
Email id: [email protected]
LinkedIn:linkedin.com/in/shailendra-r-9904ba27b