Dear Professional,
Hope you are doing well.
I am a technical recruiter with InnoSoul IT consulting company located in NY.
Please go through the Job Description and send me you Available Consultant updated resume with contact information.
Please send resume on paul@innosoul.com
Position : DataWarehouse Developer
Location : Tumwater WA
Duration : 12 Months
Direct Client Requirement
Required knowledge, skills and abilities
The contractor must have experience effectively using communication skills to achieve mutual understanding. Also, the contractor must be able to clearly communicate both orally and in writing to technical and non-technical audiences. The contractor is expected to have demonstrated skills and knowledge in the following areas:
a) Creating and maintaining Extract, Transform, and Load (ETL) processes using SQL Server Integration Services or Informatica Power Center.
b) Writing complex queries using Transact SQL for reporting and data validation purposes.
c) Working with large organizations (over 1000 employees).
d) Employing data warehouse principles and theories, including knowledge of the various tactical approaches to data warehouse development.
It would be desirable for the contractor to have demonstrated skills and knowledge in the following areas:
a) Experience using PowerExchange for Mainframe ADABAS
b) Tuning and optimizing SQL Server databases.
c) Understanding database modeling and design principles and ability to use a data model diagram.
d) Performing mainframe-to-server automation, bulk copy and FTP download.
e) Programming in .Net. or COBOL and/or Natural running on an MVS/zOS platform.
The data warehouse operating environment is SQL Server 2008 r2 and 2012 on Windows 2003 and 2008r2 servers, and ADABAS and VSAM on an MVS z/OS our ETL tools are Informatica Power Center and SQL Server Integration Services (SSIS)
The successful candidate will:
a) Participate in project team meetings and work closely with the data warehouse administrator,
ETL staff, data modelers, database administrators, support analysts, report writers, and the
data warehouse project manager to create ETL routines. Creating ETL routines includes
writing the code that creates the transformations and processes that move data from the
specified sources, transform it as required and write it into the data mart. Client requirements
and database design specifications will be provided by WSDOT staff.
b)Test target data structures to ensure that all works as designed.
c)Verify identified data sources to ensure that the needed data can be properly provided.
d)Write technical documentation of ETL routines to explain how the routines operate to meet
requirements and design specifications.
e)Provide technical assistance to write complex data-mart queries, based on the detailed
knowledge gained during the construction of ETL routines.
f) Assist in troubleshooting data loading and data warehouse performance issues.
Best Regards,
Paul
innoSoul, Inc.
24 Fairfield Ave,
Albany, NY, 12205
Email on : paul@innosoul.com
Contact : 518-504-0086
-- Hope you are doing well.
I am a technical recruiter with InnoSoul IT consulting company located in NY.
Please go through the Job Description and send me you Available Consultant updated resume with contact information.
Please send resume on paul@innosoul.com
Position : DataWarehouse Developer
Location : Tumwater WA
Duration : 12 Months
Direct Client Requirement
Required knowledge, skills and abilities
The contractor must have experience effectively using communication skills to achieve mutual understanding. Also, the contractor must be able to clearly communicate both orally and in writing to technical and non-technical audiences. The contractor is expected to have demonstrated skills and knowledge in the following areas:
a) Creating and maintaining Extract, Transform, and Load (ETL) processes using SQL Server Integration Services or Informatica Power Center.
b) Writing complex queries using Transact SQL for reporting and data validation purposes.
c) Working with large organizations (over 1000 employees).
d) Employing data warehouse principles and theories, including knowledge of the various tactical approaches to data warehouse development.
It would be desirable for the contractor to have demonstrated skills and knowledge in the following areas:
a) Experience using PowerExchange for Mainframe ADABAS
b) Tuning and optimizing SQL Server databases.
c) Understanding database modeling and design principles and ability to use a data model diagram.
d) Performing mainframe-to-server automation, bulk copy and FTP download.
e) Programming in .Net. or COBOL and/or Natural running on an MVS/zOS platform.
The data warehouse operating environment is SQL Server 2008 r2 and 2012 on Windows 2003 and 2008r2 servers, and ADABAS and VSAM on an MVS z/OS our ETL tools are Informatica Power Center and SQL Server Integration Services (SSIS)
The successful candidate will:
a) Participate in project team meetings and work closely with the data warehouse administrator,
ETL staff, data modelers, database administrators, support analysts, report writers, and the
data warehouse project manager to create ETL routines. Creating ETL routines includes
writing the code that creates the transformations and processes that move data from the
specified sources, transform it as required and write it into the data mart. Client requirements
and database design specifications will be provided by WSDOT staff.
b)Test target data structures to ensure that all works as designed.
c)Verify identified data sources to ensure that the needed data can be properly provided.
d)Write technical documentation of ETL routines to explain how the routines operate to meet
requirements and design specifications.
e)Provide technical assistance to write complex data-mart queries, based on the detailed
knowledge gained during the construction of ETL routines.
f) Assist in troubleshooting data loading and data warehouse performance issues.
Best Regards,
Paul
innoSoul, Inc.
24 Fairfield Ave,
Albany, NY, 12205
Email on : paul@innosoul.com
Contact : 518-504-0086
--
Request: Please do not send any messages to this group which are nor related to IT staffing.
You received this message because you are subscribed to the Google
Groups "Technical Recruiters" group.
To post to this group, send email to
technical-recruiters@googlegroups.com
To unsubscribe from this group, send email to
technical-recruiters+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/technical-recruiters?hl=en?hl=en
---
You received this message because you are subscribed to the Google Groups "Technical Recruiters" group.
To unsubscribe from this group and stop receiving emails from it, send an email to technical-recruiters+unsubscribe@googlegroups.com.
To post to this group, send email to technical-recruiters@googlegroups.com.
Visit this group at http://groups.google.com/group/technical-recruiters.
To view this discussion on the web visit https://groups.google.com/d/msgid/technical-recruiters/CAH2j5hNDa_-gYY564oSmMcEPFa16ieFpEFaM0f0qG%3DwUg4Rt6w%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
0 comments:
Post a Comment