*please send your resumes to pra...@infotechspectrum.com <pra...@infotechspectrum.com>*
*Job Title: Data Analyst with SQA Experience* *Location: San Francisco, CA* *Duration: 12+ Months* *Job Description:* • Analysis of database tables as they relate to a data warehouse model and determination of likely intra and inter-database relationships. • Assess the quality and consistencies of data stored in a source database and develop recommendations for data cleansing based upon data warehouse business rules. • Prepare a Data Quality and Schema Structure Report which documents findings regarding the database analysis work performed. ER diagramming will be a part of this activity. • Create mappings between the fields in the source and target systems as well as identifying relationships within a source (implicit foreign keys, lookup tables, etc.). • Leverage mappings to create an ETL process to move the data from the source system to the target system. o This includes data cleaning and value mapping • Basic Performance tuning of queries and tables. • Documentation of source schemas to be used by other Data Analysts. • Quality assurance validation of the transformed data output, often in XML format. *Desired Skills* • Data validation and testing experience · Experience with SQL in Oracle database must. · Experience with SQA. • Ability to rapidly understand business requirements, communicate business expectations to cross-functional development teams, document analysis findings that can be easily understood • Ability to assemble, analyse, and evaluate data and to be able to make appropriate and well-reasoned recommendations and decisions to the Business stakeholders and the Project Team • Strong SQL and Database skills • Past project experience with integration technologies i.e. ETL, data migration, and packaged applications • Experience with data quality assessment, cleansing, and improvement efforts • Effective communication and writing skills • Data sourcing, data mapping, data profiling, data mining, documenting data definitions Thanks, Pramod K Info Tech Spectrum E: pra...@infotechspectrum.com G-Talk/Yahoo: pramoditreqs P : 408-400-3217 -- You received this message because you are subscribed to the Google Groups "Business_Intelligence" group. To unsubscribe from this group and stop receiving emails from it, send an email to business_intelligence+unsubscr...@googlegroups.com. To post to this group, send email to business_intelligence@googlegroups.com. Visit this group at http://groups.google.com/group/business_intelligence. For more options, visit https://groups.google.com/d/optout.