Job Description :
ETL Developer
West Chester, PA
12 months
Deliverables:
*Strong data gap analysis and comparison skills, ability to work independently and the standard Informatica skills.
*Teradata experience - need experience loading data into Teradata using the Informatica tool, as well as strong SQL Skills to query Teradata.
*Cloud experience (especially Google Cloud) would be a HUGE plus.
ETL skills focused on Informatica development, including Cloud technologies. Databases: Teradata , Informatica ETL
Develops design specifications within defined architecture, utilizing standard procedures and techniques
Set up complex workflows and schedules
Develop ETL data workflows and code for new data integrations and maintain/enhance existing workflows and code
Can conduct diagnosis of standard business problems, factoring in an understanding of current technical and applications architecture.
Troubleshoots applications problems independently.
Must possess deep knowledge of data extraction, transformation & loading (ETL) methods
2+ years SQL programming experience
2+ years RDBMS hands-on experience (Teradata, Oracle, MS SQL, DB2)
2+ years advanced hands-on experience with ETL tools
2+ years advanced hands-on experience with Data Warehousing
2+ years hands-on experience with Informatica
Preferred some UNIX knowledge
BI Skills – experience with Microstrategy preferred. Dimensional modeling knowledge. View development or database development experience.
nice to have – experience tuning queries for performance in Teradata