Exp : 5 to 7 years

Notice Period : Immediate to 30 Days

Skill :

- Guidewire Conversion BA

- SSIS, SQL, Data warehousing, Agile

Roles and Responsibilities :

- Conducting Gap Analysis and feasibility analysis during the project inception phase.

- Preparing Business process flows and eliciting the business requirements and documenting comprehensive business requirements.

- Work with the business stakeholders to rationalize and prioritize the business requirements.

- Understanding and analyzing business expectations and conducting workshops that may involve multiple stakeholders, elicit & document requirements.

- Assist with system integration and user acceptance testing.

- Strong technical background preferred (Mapping, SQL, Postman, SoapUI, etc.) with mapping/flat file integration handling experience

- As a business system analyst, create HLD and Architecture documents for different integrations touch points.

- Analyze the impact of business requirements changes to the project.

- Translate business requirements into software requirements specifications.

- Participate in design sessions in prototyping new systems or enhancements.

- Collaborate with the technical resources to ensure that the system design adequately reflects the business requirements.

- Act as an Offshore SME and supporting the development and testing resources.

- Preparing business scenarios and supporting artifacts for the Testing Team.

- Support the creation of system test plans.

- Assist in the facilitation of meetings between the IT and business stakeholders.

- Create training decks and conduct training to an audience that is wide and who come from contrasting skill sets.

- Conducting Insurance Domain training and product training for external stakeholders.

- Responding to RFPs/RFIs.

- Preparing detailed process flows and demo scenarios.

- Preparing marketing collateral materials like presentations and demo paths.

- Analyze market & technological advancements in the insurance sector and create point of views, white papers, use cases and/or working demo models.

- Understanding the features, functions, and capabilities of packaged solutions in order to achieve proper business requirements alignment and adaptation to package as needed.

- Analyze industry reports, create an actionable outcome that can benefit the firm at large.

Key Skills :

- Must have extensive working knowledge of SSIS, SQL and Data Warehousing

- Experience with Data conversion/migration framework

- Hands-on design, workflow, development and performance tuning experience in data warehouse, SQL Server/Oracle.

- Strong analytical skills to build Data mappings from Legacy source to Guidewire Policy center /claim center data model.

- Working experience with Guidewire Policy, Claims and Billing Conversion using SSIS is strongly preferred.

- Must be experienced in designing and building complete ETL/SSIS process.

- Should have good exposure in writing Stored Procedures, Functions, View, Triggers, Indexes using SQL

- Experience in DB management, migrating data, transforming data, and data integrity.

- Good written and oral communication