ETL Tech Lead - Full time perm job

E*Pro Consulting service offerings include contingent Staff Augmentation of IT professionals, Permanent Recruiting and Temp-to-Hire. In addition, our industry expertise and knowledge within financial services, Insurance, Telecom, Manufacturing, Technology, Media and Entertainment, Pharmaceutical, Health Care and service industries ensures our services are customized to meet specific needs. For more details please visit our website www.epro-tech.com

ETL Tech Lead
•    7+ years of current and hands-on experience with Informatica Power Center (v 8.x and higher) design, development and performance tuning. This should include at least 1 year of v9.x experience.
•    4+ years of current and hands-on experience with reading and loading high-volume Type2 dimensions (Slowly Changing Dimensions) in Multi-Dimensional Datamarts (Start Schema).
•    7+ years of current and hands-on experience with SQL and Relational databases.
•    4+ years of current and hands-on UNIX shell scripting experience.
•    4+ years of current and hands-on experience in designing high performing ETLs in a complex Data Warehouse, Data Marts and Analytics Environments.
•    4+ years of current and hands-on experience with Performance Tuning of SQL and ETL Process for high volume and high complexity processing.
•    3+ years of current and hands-on Autosys experience.
•    3+ years of current and hands-on experience with code management tools such as ClearCase.
•    2+ years of experience in Staff supervisory role.
•    Working knowledge of On-Demand connectors – SAS, RDBDS and flat files.

Only GCs/GC EADs/US Citizens