Hi,
Please help to fill below requirement:- ETL DEVELOPER Fairfax, VA (Between Vienna and Dunn Loring Metro stops) 12 months + Phone & Skype DOE *Need USC ONLY* The position requires candidates with Informatica, recent mainframe connectivity experience. seeking an ETL Developer to providing Data Warehouse and Business Intelligence services to our Federal client. The ideal candidate will work with varying data sources with different schemas and data elements to produce an effective/efficient Data Warehouse. The goal is to create one large data storage in Oracle 11g and load data from nine source systems consisting data from Oracle, IDMS Mainframe, SQL*Server and Pervasive data stores via the Informatica Data Replication approach. *Responsibilities:* • Monitor ETL workflows and logging, providing detailed job reports and status • Perform ETL failure recovery when needed. Daily notifications on ETL workflow status will be required to ensure no interruption in service • Extract data from IDMS and into Oracle 11g using the Informatica PowerExchange for IDMS solution. • Develop Informatica workflows to ingest data from multiple transactional systems according to documented logic and source-to-target mappings • Work directly with customer and System and Data Architects providing feedback and influencing outcomes • Migrate existing PL/SQL scripts to Informatica workflows for data ingest • Apply Informatica tool to provide data cleansing, data quality assurance, and PII data masking for testing purposes *Requirements* • Experience with Informatica PowerCenter 9.5, Informatica PowerExchange • Experience with Informatica Data Quality and Informatica Dynamic Data Masking • Experience with CA Integrated Database Management System (IDMS) – a database management system for Mainframes. • Experience in Data Warehouse and Business Intelligence environment • Experience with Oracle 10/11g RDMS and associated tools and infrastructure • At least 5 years overall experience in IT applications development or consulting related to IT applications development and data ingest processes • At least 5 years in technical development and leadership roles on BI projects - with some experience along the way doing these types of activities: Designing and developing with ETL Tools and Designing and developing with Relational Reporting Tools. -- *Please only reply to my official ID [email protected] <[email protected]>* Sam (Saurabh Gaur) Sage Group Consulting Inc. Office: 732-767-0010 Extn: 604 Email: [email protected] GTalk: superbsam21 | Yahoo: saurabh_gaur www.sageci.com [image: Description: saplogoone][image: SageLogoC] -- You received this message because you are subscribed to the Google Groups "USITCV" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/usitcv. For more options, visit https://groups.google.com/d/optout.
