ETL Tech Lead - perm

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.

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 Clear Case.
• 2+ years of experience in Staff supervisory role.
• Working knowledge of On-Demand connectors – SAS, RDBDS and flat files.