*Job Title : Data Analyst Location : Kansas City, MO Duration : 6 months +*
* ****************Data Analyst **************** Responsibilities: Data Modeling for both transactional and data warehouse databases Creation of ETL Mappings; mapping of tables from source to target using standard SDLC mapping templates Creation of EAI Mappings; mapping of XML Schemas from source to target using standard SDLC mapping templates Create and maintain data model Create queries and stored procedures in SQL Profile data and validate results Communicate with customers to obtain data requirements and perform data analysis on data provided* *Required Qualifications: Must have 4 years experience in writing/developing SQL queries. Minimum 3 years of software development experience Experienced in defining and manipulating complex SQL including mathematical functions, grouping, joins, sub-select, etc. Experienced in data loading, extraction and manipulation for diverse RDBMS- specifically SQL Server and Oracle Strong skills in Microsoft Excel and other spreadsheet formats for data analysis, organization, and loading Experience with various ETL, data warehousing tools and concepts Experience in query tuning and concepts BS/MS in Computer Science, Software Engineering, or related areas* *Familiarity with following tools/technologies Data Modeling: Embarcadero ER/Studio XML Tool: XML Spy Query Tools Data/SQL Mapping Databases: SQL Server* *Knowledge of any of the following Subject Areas would be a Plus: Marketing; Loyalty; Campaign Management; Sales ( Point of Sale Systems), Customer MDM, Product MDM* *,.-:*'``'*:-.,_,.-:*'``'*:-.,_,.-:*'``'*:-.,_ .-:*'``'*:-.,_,.-:*'``'*:-.,_,.-:*'``'*:-.,_,.-:*'``'*:-.,_ .-:*'``'*:-.,_,.-:*'``'*:-.,_,.-:*'``'*:-.,_,.-:*'``'*:-.,_ .-:*'``'*:-.,,_,.-:*'``'*:-., Feroz Khan Fax: (203) 971-8354 E-mail: **[email protected]* <[email protected]> * ,.-:*'``'*:-.,_,.-:*'``'*:-.,_,.-:*'``'*:-.,_ .-:*'``'*:-.,_,.-:*'``'*:-.,_,.-:*'``'*:-.,_,.-:*'``'*:-.,_ .-:*'``'*:-.,_,.-:*'``'*:-.,_,.-:*'``'*:-.,_,.-:*'``'*:-.,_ .-:*'``'*:-.,.,_,.-:*'``'*:-., * *Notice of Confidentiality: The information contained herein is intended only for the confidential use of the recipient. If the reader of this message is neither the intended recipient, nor the person responsible for delivering it to the intended recipient, you are hereby notified that you have received this communication in error, and that any review, dissemination, distribution, or copying of this communication is strictly prohibited. If you receive this in error, please notify the sender immediately by telephone, and destroy this e-mail message OR reply with the subject “REMOVE” such that your email would be taken out of our distribution list. * -- You received this message because you are subscribed to the Google Groups "oraapps" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/oraapps?hl=en.
