Position: Senior ETL Developer Location: Dayton, Ohio 6 month assignment + renewal
*Must be a US Citizen; Active Clearance and have excellent communication skills* IClient is looking for a ETL Developer that is a Contract / full-time consulting opportunity that we have for the Cincinnati, Ohio area. *Core Responsibilities: * * Sourcing the data from the operational systems * Applying the business transformation rules * Preparing a database-loadable file for the Data Warehouse * Management of the deployment of the data acquisition tool(s) * Contributing the technical metadata to the metadata repository The ETL Specialist will extract data destined for the Data Warehouse from the operational systems that store the data. The specific duties are: * Work with the source system analysts to understand the windows available for data extraction * Program, test, implement and maintain any data extraction programs necessary to extract the data from the operational systems needed to be moved to the Data Warehouse * The Data Warehouse ETL Specialist is responsible for applying transformation rules as necessary to keep the data clean and consistent and therefore usable by the user community. *Skills & Attributes: Specific tasks include:* * Participation in design sessions chaired by data stewards and/or IT personnel where decisions are made involving the transformation from source to target * Programming the data acquisition tool with the rules to be applied to the data * Ensuring the correct application of the business rules through data query after the data is loaded into the Data Warehouse * Following the data extraction and rules application, the file(s) will need to be made ready for loading into the Data Warehouse. * Obtaining complete knowledge of the physical database schema * Preparing the files needed to load each table that has been designated to receive files from operational systems rather than direct input from data stewards * Programming the data acquisition tool(s) with the tables to load the files into * Working with the Data Warehouse Database Administrator to ensure the file loads properly into the Data Warehouse * The metadata repository will contain technical metadata such as data sources and transformation rules applied. The Application Programmer will be responsible for the entry and maintenance of this information. *Required Experience:* Substantial ETL architecture design experience within data warehousing environments governed by applying appropriate methodologies and ETL standards * *3+ years of experience with relational databases (Oracle, SQL Server, *DB2, Teradata, etc) *2+ years of Informatica experience* 2+ years working on BI/DW projects Data modeling with ERWIN a plus BI (Cognos, Business Objects) a plus Thanks & Regards, Rani Adari Sr. IT Recruiter Tech Tammina 203 Elden Street Herndon, VA-20170 Call: 703-880-4992 Fax: 703-991-5532 [email protected] www.tammina.com GTalk:raniadarii -- You received this message because you are subscribed to the Google Groups "SAP ABAP" 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/sap-abap. For more options, visit https://groups.google.com/groups/opt_out.
