ETL - Informatica Developer Job - C2C
Ashwath Dhama
REQUIREMENT ONE: Sr. ETL / Informatica Developer - Irvine, CA & Fountain Valley, CA - Hyundai Motors
REQUIREMENT TWO: Sr. ETL / Informatica Developer - Herndon, VA - Fannie Mae
Duration: 12 – 24 months
Rate: $50-$60/hr – Fixed and non-negotiable
Job type: Contract on C2C
Priority: Very High
Visa: Open
Level: Senior
Interviews: Telephonic and/or skype
REQUIREMENT ONE: Sr. ETL / Informatica Developer - Irvine, CA & Fountain Valley, CA - Hyundai Motors
REQUIRED SKILLS/EXPERIENCE:
8 - 10 years of experience implementing large scale ETL processes using Informatica PowerCenter; Design high level ETL process and data flow from source system to target databases; MDM/ODS architect and knowledge, best practices; Strong experience with Oracle databases and strong SQL and PL/SQL knowledge; Participate in writing and reviewing logical and physical data models. ERWIN a plus; Work with appropriate leads and review high level ETL design, source to target data mapping document and be the point of contact for any ETL related questions; Develop & unit test Informatica ETL processes for optimal performance utilizing best practices; Performance tune Informatica ETL mappings and report queries; Perform detailed data analysis to understand the source system data; Review source to target data mapping document for ETL processes; Coordinate ETL and database development work with offshore ETL developers and conduct code reviews; Work closely with database administration team and ensure the database is architected and designed to handle concurrent ETL and reporting query jobs; Good understanding of project life cycle, especially tasks within the ETL phase; Ability to work independently and multi-task to meet critical deadlines in a rapidly changing environment; Excellent communication and presentation skills; Self-starter with ability to manage priorities
REQUIREMENT TWO: Sr. ETL / Informatica Developer - Herndon, VA - Fannie Mae
MUST have experience visible on the resume: ETL, Informatica Power Center, Data Quality, XML, Unix Shell Scripting, SQL
REQUIRED SKILLS/EXPERIENCE:
Minimum 8+ years of experience genuine consultants needed; Experience with Informatica Powercenter; Experience with Informatica Data Quality; Experience with Informatica Power Exchange (change data capture); Design, Develop, Test, Implement and troubleshoot ETL mappings and workflows in a large Data Warehouse environment; Strong experience developing and maintaining Informatica mappings/workflows in a data warehouse environment; Strong experience optimizing Informatica mappings, sessions and workflows; Experienced writing complex SQL’s, PL/SQL and Performance tuning is a plus
Strong database experience, data analysis and analytical skills; Experience creating ETL design documentation and maintaining overall design document and deliverables
Strong working experience with XML Data; Strong written and oral communication skills; Good understanding of dimensional modeling and ETL designs for loading Star Schemas