ETL Dev Lead
Job in
Charlotte, Mecklenburg County, North Carolina, 28245, USA
Listing for:
TechDigital Group
Full Time
position
Listed on 2026-10-23
Job specializations:
-
IT/Tech
Job Description & How to Apply Below
- 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.
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction