Birlasoft

Senior Technical Lead – Enterprise Apps

Birlasoft

full-time

Posted on:

Location Type: Hybrid

Location: BIRLASOFT OFFICE • New Jersey • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Job Level

Senior

Tech Stack

ETLGuidewireInformaticaRDBMSSQL

About the role

  • Collaborate with business stakeholders and IT teams to define and document data architecture and modeling needs
  • Architect and design comprehensive solutions for the enterprise data warehouse
  • Source data from multiple Insurance and Reinsurance Policy, Treaty, Claim and financial systems
  • Design and implement Source to Target mappings optimized for high-volume data integration
  • Create logical and physical data models and implement them on SQL Server platforms
  • Work closely with the development team to ensure accurate translation of mappings into code
  • Develop strategies for data collection and ingestion and write SQL based solutions to validate data accuracy and integrity in the data warehouse
  • Analyze and design enterprise data models for optimal reporting
  • Support reporting teams in understanding and utilizing the data warehouse model effectively
  • Participate in release planning and validate changes post-deployment
  • Develop SQL Server views for reporting and dashboard development
  • Troubleshoot and optimize SQL and Informatica mappings and stored procedures

Requirements

  • 10+ years of data architecture and design experience
  • 3+ years of experience within the Insurance and reinsurance domain
  • Advanced experience with extracting data from Insurance applications
  • Extensive knowledge of Data Warehousing, ETL and BI Architectures, concepts, and frameworks
  • Capable of creating and tuning Semantic layer Reporting Views
  • Capable of facilitating data discovery sessions involving business subject matter experts
  • Knowledge of RDBMS platforms (SQL Server, DB2, etc.) with experience in generating DDL
  • Possess knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-CD & SAP FI-GL applications
Benefits
  • Hybrid work model
  • 3 days on-site
  • Permanent position

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
data architecturedata modelingSQLETLdata warehousingdata integrationdata validationreportingInformaticaRDBMS
Soft skills
collaborationcommunicationfacilitationproblem-solvinganalytical thinking