ETL Informatica Developer

Looking for a strong ETL/Informatica developer (approximately 5 years exp) for a long-term project in Harrisburg, PA. Below are the key technical requirements

• Expert knowledge of Informatica PowerCenter 9.x or 10.x
• Excellent knowledge of Advanced PL/SQL and
• Experience with data warehouse design (logical and physical data modeling), * 5 years of experience with leading complex informatica projects.
• Proven Experience with building extracts using complex logics for applying high level filters using custom SQL - Must possess proven SQL skillsets.
• Strong understanding of Data architecture skills and Informatica based EDW solutions.
• Proficient in star schema data design and EDW based data infrastructure skills.
• In depth knowledge of informatica development, data warehouse design and query optimization.
• Database migration and ETL experience.
• Solid understanding of user-centered design principles, visual design skills, great technical know-how, and a proven expertise in interaction design.
• Experience in EDW/BI/DA Component Security interfaces.
• Prior experience working with PII data. Knowledge of what data is covered by HIPAA and other privacy related legislation and regulation.
• Excellent oral and written communication skills.

OPT/CPT candidate with the right attitude/aptitude considered. H1B sponsorship is available for the right candidate., * Informatica: 3 years (Preferred)

• Data warehouse: 2 years (Preferred)
• SQL: 5 years (Preferred)

Job Types: Contract, Full-time

Pay: $55.00 per hour

Benefits:

• Dental insurance
• Health insurance
• Paid time off
• Vision insurance