- Conduct or participate in meetings with key system owners to understand CARFAX’s current data and systems environment
- Analyze source system data to assess data quality and work with technical and business representatives to determine strategies for handling data anomalies identified
- Design ETL processes and develop source to target data mappings
- Develop, test, and deploy ETL routines using ETL tools and external programming/scripting languages, as necessary
- Integrate ETL routines into production job streams
- Monitor and optimize the performance of the ETL routines and environment
- Administer and maintain the ETL environment, including performing configuration management activities related to the ETL environment
- 4+ years designing ETL processes and developing source to target mappings
- 4+ years experience developing, testing, and deploying ETL solutions using Informatica PowerCenter. Experience with cloud data integration solutions such as GoodData a plus.
- Significant experience implementing data warehousing solutions in an Oracle 10/11g environment. Experience with analytical databases such as ParAccel a strong plus.
- Very strong SQL and/or PL/SQL skills required.
- Significant experience optimizing ETL routines and environments
- Significant experience administering and maintaining ETL environments
- Experience with data virtualization tools such as Composite Software a strong plus
- Experience scheduling jobs using Control-M a plus
- Experience developing BI solutions using leading BI tools such as Cognos, MicroStrategy, or Business Objects strongly desired
- Excellent problem solving skills and strong attention to detail
- Ability to work effectively in a rapidly changing, team-based environment. Experience working in Agile environments is a strong plus.
- Excellent communication and collaboration skills with business and technical communities
- Excellent written communications skills
- All candidates subject to a full background check
Carfax - 18 months ago
The most trusted provider of vehicle history information, CARFAX is used by millions of consumers each year. CARFAX Vehicle History...