You will design, develop, and maintain ETL workflows to support complex data integration needs.
Responsibilities
- Create and manage ETL workflows using Informatica PowerCenter and Power Exchange.
- Translate business requirements into technical specifications for efficient data integration.
- Optimize ETL processes for performance, throughput, and minimal downtime.
- Implement data validation and cleansing routines to ensure data quality and integrity.
- Conduct unit and integration testing, troubleshoot production issues, and maintain process documentation.
Required Skills
- 5-8 years of experience in ETL development with a focus on Informatica tools.
- Proficiency in Informatica PowerCenter and related Informatica products.
- Strong SQL skills with experience in Azure DB and SQL Server.
- Knowledge of data warehousing concepts and BI architecture.
- Experience with UNIX/Linux scripting and scheduling tools.
- Familiarity with data modeling techniques and schema designs such as star and snowflake schemas.
- Bachelor's or master's degree in computer science, Information Systems, or a related field.
Preferred Skills
- Knowledge of Insurance, Guidewire Policy Center, and Policy Migration Tool.