Data Warehouse DeveloperNeed an information management data
warehouse developer and want some practical suggestions about
responsibilities, qualifications and salaries?
Information management projects require: 
Data movement developers are responsible for creating software code that will extract data from source systems, transform it as necessary and load it into data warehouses and/or into data marts. They are primarily required during the development, quality assurance and transition to production phases. Responsibilities include:  Helping data analysts run data
profiling scripts and documenting the results.Creating detail design specifications
based on
architecture and design specifications.Documenting satisfaction of
requirements in
design specifications to help with requirements traceability.Participating in design specification
quality
assurance reviews involving a data architect and data integration
designer.Creating unit test data to ensure that
the code
performs under all expected conditions.Developing ETL software using common
tools such
as Informatica, Ab Initio, and Ascential DataStage.Conducting unit tests in a personal
schema to
ensure that the code meets specification.Documenting test results and storing
test data and results in the project documentation repository.Participating in code reviews with
data
architects, lead developers and other developers.Providing input to operational run
manuals. Responding rapidly to any code defects
discovered during quality assurance testing and:
Provide input object migration plans
required for integration, quality assurance, user acceptance testing
and release to production, by
identifying all objects that need to be migrated.Providing post production support to
help
ensure
knowledge transfer.What are typical responsibilities for database developers? Database developers may include:
data warehouse test script developers are involved with developing scripts and stored procedures required to create test data, augment test or create quality assurance test scripts to help provide repeatable processes for testing purposes. A data warehouse developer must have at least 2-4 years of experience with data movement software such as Informatica, Ab Initio and Ascential DataStage, experience working in a data warehousing environment, and experience with SQL and stored procedures What are salaries expectations? Experienced ETL developers with 3-5 years of related data warehousing experience should expect to earn $70,000-95,000. What are contract employee salary expectations? Contract employees can expect to earn anywhere from $45 to $70 per hour. However, this is the amount that is paid to a staffing company. The amount the contract employee receives will depend upon the fee demanded by the resource-staffing firm. Can this work be done part time? Development work can be done remote. This is a full time role during the development phase and requires at least a 50% involvement during quality assurance testing and release to production. This role is not a part time project role. It is a good candidate for contract employees and offshore development. Summary… Information management projects are data centric and require highly skilled IT specialists data warehouse developers during the development, quality assurance testing and release to production phases.
|
|
 |
|
