Monday 6 February 2012

[Outsource:59524] Data Warehouse Developer

Please send resume to annie@addonusa.com

 

Data Warehouse Developer

Location: Tallassee FL

Duration: 6 months

 

 

This position is responsible for design, construction and implementation of ETL (Extract, Transformation and Load) processes for the Data Warehouse solution at Citizens. The ETL Developer will work closely with the Lead Data Warehouse Analyst and use their knowledge of Data Warehousing and Business Intelligence from gathering requirements through implementing solutions for retrieving, loading, combining and summarizing data from multiples systems into the Data Warehouse. This is a technical development role, heavily involved in technical design, development, unit and system testing activities relating to Data Warehouse data load utilities and processes.

 

Key activities include:

 

Analyzes source system data to understand the data structure, definitions and anomalies. Interacts with customers as needed to better define and understand the general reporting requirements.

Interacts with other technical team members to establish ETL requirements and designs. Designs, develops and implements ETL processes and procedures for an Enterprise Data Warehouse solution.

Ability to program in SQL to perform the data query, extract, transformation and load functions. Documents ETL designs in a clear and concise manner.

Participates in the testing and implementation of new or enhanced ETL processes and procedures.

 

REQUIREMENTS

 

Knowledge of Relational, Star Schema and Dimensional database modeling techniques. Knowledge of Denormalized and Reporting table database modeling techniques.

Strong ETL Design and Development skills.

Strong SQL query, SQL DML (Data Manipulation Language) and relational database design skills.

 Ability to clearly and concisely document all ETL and SQL processes and Job and

Scheduling information.

Ability to read, interpret and develop Data Flow Diagrams.

Minimum two years experience in large data warehouse projects from design through production support strongly desired.

Minimum five years of SQL Development and two years of which are in Data Warehouse

ETL development experience.

Minimum two years experience with SQL Server 2000 or 2005 RDBMS, required. Minimum two years experience with SQL Server DTS or SSIS ETL tools, required. Property & Casualty insurance experience is strongly desired.

Computer literacy in Microsoft Word, Excel and Outlook, required.

Ability to effectively interact with both internal and external contacts in person, by e-mail and over the phone.

 

 

Thanks & Regards

 

Annie Mark   

Addon Technologies

Ph:  734-956-4737 Ext 1+202

annie@addonusa.com

www.addonusa.com

 

Please visit  www.NRIYP.com
New generation Yellow pages for NRI's
Classifieds|Yellow Pages|Travel|Classmates

 

--
Introduce business in 3800 cities. How?
=====================================================
Thanks for using group.
Moderator
 
1) This group is managed by www.BRCIndex.blogspot.com
2) Post your message with your linkedin Profile (Visit linkedin.com) to confirm your identity and refer business.
3) Visit www.BRCIndex.blogspot.com (3800 Business Referral Club)
4) Reply to two message before posting new one.
5) Donot post same message in all 3800 business Referral Club.

You received this message because you are subscribed to the Google Groups "Outsource" group.
To post to this group, send email to Outsource@googlegroups.com
To unsubscribe from this group, send email to Outsource-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/Outsource

No comments:

Post a Comment