ETL Dev Lead

Role: ETL Dev Lead

No. of Positions: 1

Hiring Mode: Contract (TP)

Location: On-site

Alpharetta, GA; Charlotte, NC; Chicago, IL; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Denver, CO; Fargo, ND; Garden City, NY; Houston, TX; Jacksonville, IL; Lenexa, KS; Los Angeles, CA; Lubbock, TX; Morristown, NJ; Mt Juliet, TN; New York, NY; Purchase, NY; Topeka, KS

Job Description:

• 10+ years of data Clienthitecture 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.

• dvanced experience with extracting data from Insurance applications.

• Extensive knowledge of Data Warehousing, ETL and BI Clienthitectures, 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.

• Clienthitect 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.

• nalyze 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.