SF Bay Area Computer Jobs and IT Jobs

Job ID: 6805906

TITLE: Data Integration (DI) Engineer

Job Description: Analyze data values and data patterns to identify the relationships that link desperate data elements into logical units of information or “business objects”. Identify and document the transformation rules, atomic grain of the data in the source systems. Responsible for the full ownership and utilization of the IBM Infosphere Discovery to perform the data discovery tasks. Assess and cultivate long-term strategic goals for Enterprise Data architecture and development in conjunction with end users, business partners and other stakeholders. Create and maintain information on the enterprise critical data entities, data attributes and calculations. Organize the information by business units or subject areas. Responsible for analyzing the aligning the enterprise data models with other business models. Create and maintain enterprise Data Warehouse conceptual, logical, and physical data models. Assist data Systems analysts to analyze and document business and data requirements using EDM recommended techniques. Identify and manage the resolution of data quality and data security issues such as uniqueness, integrity, accuracy, consistency, privacy, and completeness in a cost-effective and timely fashion. Create elaborative unit test plan different test cases. Executes each unit test case and ensures that quality meets design specifications prior to quality assurance/integration testing. Support data/Information governance by providing reporting and traceability on data movement, modeling and business intelligence applications as required by regulatory requirements. Telecommuting permissible three (3) days per week.

Requirements: Bachelor’s degree or foreign degree equivalent in Computer Science, Engineering (any) and five (5) years of progressive, post-baccalaureate experience in job offered or related role.

Experience and/or education must include:

1. Design, Implementation and Maintenance of Data Model in Datawarehouse composed of data from multiple Systems such as MS SQL server.
2. Creation of ETL Workflow for Data Integration to facilitate data load into the Datawarehouse for generating reports containing metrics for the customers.
3. Conduct Data Analysis to understand business requirements on the unstructured sources; 
4. Design and Development of the ETL (Extract Transform and Load) and solutions using IBM Infosphere DataStage and Stored procedures.
5. Building of Visual Reports for Internal Customers to show KPI’s
6. Development of project schedules and ETL process as per the project requirements and
7. Experience in Agile and SDLC Process.
8. IBM Infosphere Foundation Tools and scripting in UNIX for Automation of File Transfer, Archival or deletion process.

OTHER: Job Site: 1901 Harrison, 17th Floor, Oakland, CA 94612; 40 hours/week; $196,685/yr - $201,685/yr. If offered employment, the applicant must have legal right to work in U.S. EOE.

Please reference Job#6805906 and apply online at wcirb.com/about-us/start-your-wcirb-career.