BH 20485 - ETL Developer
Company Name:
Open Systems Technologies
ETL Developer
Must have Cognos, SQL, SSIS/DataStage
Insurance experience a plus
Architect & Design position for Database and ETL (SSIS). Must be familiar with Cognos 8.4 and up - along with SQL. ETL Developer
Description:
The ETL Developer will work within the Finance department in support of ETL development (SSIS tool) and maintenance efforts on various business intelligence, reporting, and data warehousing projects. The role will be responsible for creation of ETL scripts and supporting production processes.
Skills /
Experience:
? Expert in Data Modeling and Data Warehousing.
? More than 5
years of hands-on with SSIS, including distributed operations and data warehouse ETL process flows.
? Working knowledge of SQL
? More than 5
years writing queries using SQL Server 2008, Oracle, etc - Software development life cycle methodologies and deliverables.
? Experience with Data Stage and SAP BW a big plus.
? Education/Certifications: Bachelor's Degree in Computer Science or Information Systems or its equivalent.
? Experience in Cognos Framework Manager a plus ? Experience in Cognos BI applications ? versions 8.4 and up a plus ? Experience with Cognos installation and configurations will be a plus.
Responsibilities:
? Working with business user and business analysts to understand the business and application requirements ? Develop an understanding of the data ? what it is, where it comes from, where it is going and what transformations are being done to it ? Developing an understating of the system and how all the pieces work together ? Review data models with the data architect to ensure that the current design can support the business and reporting requirements ? Review data models for Data Warehousing best practices ? Translating requirements into a logical data model
Estimated Salary: $20 to $28 per hour based on qualifications.
Open Systems Technologies
ETL Developer
Must have Cognos, SQL, SSIS/DataStage
Insurance experience a plus
Architect & Design position for Database and ETL (SSIS). Must be familiar with Cognos 8.4 and up - along with SQL. ETL Developer
Description:
The ETL Developer will work within the Finance department in support of ETL development (SSIS tool) and maintenance efforts on various business intelligence, reporting, and data warehousing projects. The role will be responsible for creation of ETL scripts and supporting production processes.
Skills /
Experience:
? Expert in Data Modeling and Data Warehousing.
? More than 5
years of hands-on with SSIS, including distributed operations and data warehouse ETL process flows.
? Working knowledge of SQL
? More than 5
years writing queries using SQL Server 2008, Oracle, etc - Software development life cycle methodologies and deliverables.
? Experience with Data Stage and SAP BW a big plus.
? Education/Certifications: Bachelor's Degree in Computer Science or Information Systems or its equivalent.
? Experience in Cognos Framework Manager a plus ? Experience in Cognos BI applications ? versions 8.4 and up a plus ? Experience with Cognos installation and configurations will be a plus.
Responsibilities:
? Working with business user and business analysts to understand the business and application requirements ? Develop an understanding of the data ? what it is, where it comes from, where it is going and what transformations are being done to it ? Developing an understating of the system and how all the pieces work together ? Review data models with the data architect to ensure that the current design can support the business and reporting requirements ? Review data models for Data Warehousing best practices ? Translating requirements into a logical data model
Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
