*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 -- You received this message because you are subscribed to the Google Groups "Visa Transfer OPT, CPT, PT, H1,H4" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/paul_talluri/CAHz0OxdQP_orN%3DFYN%3DCeo%2BjNmSO_4WexjhozVEo3Sw3ujzrh0Q%40mail.gmail.com.
