Data Warehouse Developer

Company Name:
McAfee, Inc.
JOB DUTIES: Develop reliable, efficient, and maintainable McAfee CMSB Data Warehouse and ETL solutions. Perform Informatica installation, upgrades, and administration. Perform analysis, design, development, implementation, and maintenance of programs and applications for the Data Warehouse and ETL processes. Translate business requirements into robust, scalable, and supportable Data Warehouse solutions which function within system architecture. Define, develop, and document ETL design, including process flow, data flow, source -to-target mappings, physical database designs, and data models. Perform detailed source-system analysis, source-to-target data analysis, data profiling, data cleansing, data quality validation, data testing, and transformation analysis. Design and build data mappings from multiple source systems to data warehouse, maintaining source data integrity. Develop batch and real time ETL applications using Informatica to populate the data warehouse. Participate in the full development cycle, end to end from design, implementation, documentation, testing, and maintenance. Develop ETL solutions using Informatica to fetch data from external source systems such as files, or Hadoop to populate the data warehouse. Develop Business Intelligence reports using Microstrategy 9.3 tools.
REQUIREMENTS: Bachelors degree in Computer Science, Engineering, or related field, followed by five years of progressive, post-baccalaureate experience in the job offered or five years of progressive, post-baccalaureate experience in a computer-related occupation.
Experience must include:
1. Minimum 5 years of experience with MS SQL Server and Informatica;
2. Data warehouse-related architecture, design, and production procedures, job scheduling, ETL (Extract, Transform, Load), and workflow development;
3. Data profiling, data cleansing, data quality validation, and data testing;
4. Relational and dimensional databases
5. Data warehousing and VLDB (over 5 TB);
6. Business intelligence methodologies and architectures; and
7. Use of source control tools.
To apply mail resume to: McAfee Inc. c/o Martha Rodriguez, 5000 Headquarters Drive, Plano, TX 75024. Reference Job Code #. EOE.

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.

More Jobs

Business Intelligence (OBIEE) & Data Warehouse...
Canoga Park, CA CGI Technologies and Solutions, Inc.
Sr. Data Warehouse Developer
El Monte, CA East West Bancorp, Inc.
Data Warehouse Developer
Sacramento, CA California State University System
Data Warehouse Developer
San Leandro, CA Mach 1 Global Services
Business Intelligence (OBIEE) & Data Warehouse...
Canoga Park, CA CGI Group, Inc.
Data Warehouse Developer
Pasadena, CA Randstad Technologies