Hi,
Hope you are doing great. Please review an urgent requirement from our client, detailed below. We would love to review profiles of any consultant you have in your employ that matches this description. Please include rates and contact information. *Face to Face interview required**.* *Please Reply on: -- **[email protected]* <[email protected]> *Job title: * * ETL Developer* *Location:* *San Ramon, CA* *Job start date: * *ASAP* *Rate: * *All Inclusive Hourly Rate* *Duration* *6 to 9 Months* *Description* · *Responsible for proper ETL architecture, standards and best practices, collaborating with existing ETL resources to set cutting edge industry standards. * · *Participates in setting strategy and standards through logical and physical modeling and implementation. Must be able to understand the business side. * *Essential Functions * 1. Manages development resources by assigning design, development and testing tasks and ensuring resource adhere to previously agreed to timelines communicating status. 2. Evaluates the integration of various data sources like Oracle, SQL server, VSAM and sequential files into staging area and recommends and/or implements efficiencies. 3. Counsels team members on the evaluation of data using the Informatica Data Quality (IDQ) toolkit. Applies data analysis, data cleansing, data matching, exception handling, and reporting and monitoring capabilities of IDQ. 4. Performs technical walk-through as needed to communicate design/coded solution and to seek input from team members. 5. Develops ETL processes using Informatica, ETL control tables, error logging, auditing, data quality, etc. 6. Implements data cleanup procedures, transformations, scripts, stored procedures, and execution of test plans for loading the data successfully into the targets *Education Required :-* Education or Equivalent Experience Bachelor's Degree in Computer Science or related field required *Required Experience * o 7 - 10years of experience at Enterprise-level ETL development and ETL architecture using Informatica, Teradata, and understanding the COBOL file structures. o Technical Skills Strong Teradata technical knowledge in the areas of general SQL, and use of Teradata export and import utilities (FastExport, FastLoad, MLoad) o Strong Informatica technical knowledge in the following areas on Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor. o Good knowledge of analytical and logical conceptual level programming skills o Good knowledge of Erwin model generation tools (logical and physical); o Teradata and the Teradata Financial Services Logical Data Model Data analysis, data mapping, data loading, and data validation. Understand re-usability, parameterization, workflow design, etc. o Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions Should have thorough understanding of Entire life cycle of Software and various Software Engineering Methodologies. o Performance tuning and end-to-end lifescycle experience with Enterprise wide data warehouse. Our client is really very eager to fill this position ASAP!!!! If you are interested, please send me your updated resume with your expected hourly rate or call me at your earliest convenience. If you are not available to take up this position, I will be grateful if you could forward this email to your friends who may be interested. Hope to hear from you soon. Best Regards *Amit SinghPhone: (925) 946-0267 (Extn. 315)[email protected] <[email protected]>Skype-Amit3522Gtalk-amit352recruiterwww.acg-usa.com <http://www.acg-usa.com>220 North Wiget Lane, Walnut Creek, CA 94598*
