Hi,
*Please send your resume to divy...@idctechnologies.com
<divy...@idctechnologies.com>*
*Location: **South San Francisco, CA*
*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.
- 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*
- 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*
*Regards,*
*Darshan*
* IDC Technologies, Inc *
*1851 McCarthy Boulevard, Suite 116, Milpitas, CA, USA, 95035.*
*Phone No. :- (*408) 882-6837
*Mailto : divy...@idctechnologies.com <divy...@idctechnologies.com>*
--
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.
