ETL Developer lead Job at Syntricate Technologies, Dallas, TX

M2RYRDdDbFpFN0xjanB6VTAzbzgxZGYwemc9PQ==
  • Syntricate Technologies
  • Dallas, TX

Job Description

Required Skills: 10+ years of data architecture and design experience working with development team to extract data directly from source applications and loading to an enterprise data warehouse. 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-CDSAP FI-GL applications. Architect and design comprehensive solutions for the enterprise data warehouse. Sourcing 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. Syntricate Technologies

Job Tags

Similar Jobs

ATTITUDE

Formulateur/Formulatrice cosmétique Job at ATTITUDE

Formulateur/formulatrice cosmtique propos dATTITUDE ATTITUDE est une entreprise qubcoise qui rayonne travers le monde. Sa mission est de rvolutionner lindustrie de la beaut avec des produits sains. Faits dingrdients naturels, ces produits sont offerts ...

Arc'teryx

Recruiter Job at Arc'teryx

 ...ll talent strategy. Sourcing, interviewing, and assessing candidate skills, experience, and competencies to make hiring recommendations to the business. Collaborating and educating store managers on our recruiting process to ensure ... 

Alterra Mountain Company

Employee Housing Custodian Job at Alterra Mountain Company

 ...to specific times of the year Schedule: May require working early mornings, weekends, and holidays Employee Perks: ~ Free skiing and...  ...become a key player in our team! Job Responsibilities: Cleans employee-tenant units (trash removal, dirty linen, vacuuming,... 

Hays

Commercial Litigation Partner Job at Hays

Rle Nous cherchons un(e) Avocat(e) Snior spcialis(e) en Litige Commercial avec une exprience substantielle de plus de 12 ans pour rejoindre lquipe de litige de notre client. Lavocat(e) recrut(e) pour ce poste sera impliqu(e) dans des reprsentations commerciales...

Vets Hired

Police Officer Recruit Job at Vets Hired

 ...wanted persons by court orders or actions in criminal cases. Maintains knowledge of local...  ...to work in the United States Experience and Education: No previous law enforcement...  ...formal education or coursework in criminal justice or a related field that provides...