Senior ETL Developer USA Jobs

Job Opening Apply here
Company:	Emergent Global Partners
Job Title:	Senior ETL Developer
Job Location:	San Francisco - San Francisco County - CA California - USA
Employment Category:	Finance
Employment Type:	Full Time
Posted:	2013-01-04
Job Description
Client: Large Retail Bank Location: San Francisco, CA Start: ASAP Duration: Contract-To-Hire Position: Sr. ETL Developer Description: Responsible for ETL design, development, standards and best practices, collaborating with existing ETL resources to set cutting edge industry standards. 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 a 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 in the targets. Experience: ·         7-10 years of experience at Enterprise-level ETL development and ETL architecture using Informatica, Oracle, SQL Server and Teradata (preferred not a must), understanding the COBOL file structures. ·         Strong database (Oracle and Teradata) technical knowledge and general SQL ·         Strong Informatica technical knowledge in the areas on Informatica Designer Components – Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor. ·         Good Knowledge of analytical and logical conceptual level programming skills. ·         Good knowledge of Erwin model generation tools (logical and physical); Teradata and the Teradata Financial Services Logical Data Model. ·         Data analysis, data mapping, data loading, and data validation. ·         Understand reusability, parameterization, workflow design, etc. ·         Strong experience in building Data Quality checks and general know how of data quality principles. ·         Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions. ·         Should have thorough understanding of Entire lifecycle of Software and various Software Engineering Methodologies. ·         Performance tuning and end-to-end lifecycle experience with Enterprise wide data warehouse
Position Requirements
Education Level Required:	High School
Contact Information
Preferred method of contact:	E-mail via Apply Online Box (below when logged in)
Apply for this Job Here
USA-only applications: Please note that this Company / Employer has indicated that only qualified candidates currently residing in USA are being considered here for this position. You must be logged in as a registered jobseeker in order to apply to this job posting. Log in using the fields below, or register here if you do not already have a (Free) jobseeker account. Email Address Password How this Free jobsite works - How to apply for this job: When you register (if you have not already done so), you will first be asked to confirm your registration. When you do that, you will be sent your account login details. You will be able to log in and enter your CV / Resume information into the default Resume Outline layout and format in your account area. Alternatively or additionally, you can attach your original Resume document (when within the size limits) as part of your application email for the job. You may attach up to 3 files below any job posting. You must also write an introductory message or cover letter. Your Resume Outline (if you have entered one in your account) and/or your attached files will be sent directly to the employer's email address, along with your introductory message (or cover letter) and your account contact profile. Good luck with your application!