ETL Informatica Developer

Do you have experience in Schema design?, 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)

NOTE: If you do NOT have experience in Informatica or cannot write good SQL queries - please do not apply., * 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., * SQL: 3 years (Preferred)
• Informatica: 3 years (Preferred)
• Data warehouse: 2 years (Preferred)

$55 an hour - Full-time, Contract, Pulled from the full job description

• Health insurance
• Paid time off
• Vision insurance
• Dental insurance, Job Types: Contract, Full-time

Pay: $55.00 per hour

Benefits:

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