Data Profiling IBM Atlas ETL Data Architect Developer (Jobs in Oakland, CA)   Requirement id 63436 Job title Developer Job location in Oakland, CA Skills required PGP Decryption, SQL, Star Schemas, Data Profiling IBM Atlas ETL Data Archit Open Date 17-Aug-2017 Close Date Job type Contract Duration 6 Months Compensation DOE Status requirement --- Job interview type Face to Face interview    Email Recruiter: coolsoft Job Description Developer: PGP Decryption, SQL, Star Schemas, Data Profiling IBM Atlas ETL Data Archit Client Info : UCOP Job Description : Position Summary: The ITS Data Services group is charged with the migration of File transfer interfaces from VSFTP to a managed file transfer (MFT) process - Go-Anywhere. The position requires considerable administrative and technical coordination in a highly complex technical and organizational environment and results in systems designed to meet the migration effort. Under direction of the Data Services ETL Manager and other members of the Data Services team, the incumbent is responsible for implementing changes required to onboard with the new managed file transfer process, designing and implementing robust Extract Transform and Load applications and processes to load data and supporting metadata into the decision support systems. Proposed Job Duties: Function % Duties Ess Duty? Create/ modify Unix/ Shell scripts 60% Work closely with Production Control Shared Services Center (PCSSC) in implementing the changes for new managed file transfer process. Create / modify existing Unix/ Shell scripts, batch jobs to process files transferred through MFT process Y Build and Maintain ETL processes 30% Working closely with Data Architect, data modelers, data analysts, business analysts and BI developers to understand requirements and using the InfoSphere toolkit and ETL best practices, develop ETL processes in support of the requirements, validate that they meet business and technical specifications, ensure that any issues raised during testing are addressed prior to migration into production; and manage ongoing maintenance of the system and data. Work includes: Design, build, test and maintenance of extract processes to assure the selection of correct data, including design, test and implementation of parsing rules to assure selection of correct data and build of data profiling to assure ongoing correctness of extracted data. Design, build, test and maintenance of transform rules and processes to derive the correct data from the extracted data and to transform it into the required format and structure to support the business requirements Design, build, test and maintenance of the process to properly load the transformed data into the target database and the associated metadata into the enterprise metadata repository. Development and execution of ETL test plans. Manage maintenance of the system and data including monitoring and data profiling to assure ongoing data quality, ongoing monitoring and optimization of the system to manage scalability and performance; and identification and implementation of improvement opportunities for key development processes. Provide the BI Manager and the Data Architect with status and progress reports on development and maintenance activities as required. Y Related Activities 10% Other duties as assigned. Proposed Job Requirements: Job Requirements Req/Pref Disp Ord Minimum five years experience in data related work with at least 2 years experience on UNIX / Shell scripting and as a senior ETL analyst / developer for large, complex decision support systems. Experience working with encryption protocols like PGP Encryption, SSH keys. Hands on experience with IBM DataStage, including extensive experience with parallel job design and development and strong SQL coding skills, is required. Working experience with revision control systems, Linux platform, Shell scripting, and DB2 database is required. S   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 63436 while calling.   Other jobs in CA: Anaheim (4), Brea (3), Brisbane (2), Carlsbad (3), Concord (1), Culver City (1), Cupertino (5), Downtown Los Angeles (3), El Monte (3), El Segundo (1), Foothill Ranch (2), Irvine (1), La Jolla (2), Lake Forest (1), Larkspur Landing (1), Long Island (1), Los Angeles (27), Newport (1), Newport Beach (3), Orange (2), Orange County (7), Pasadena (1), Poway (5), Rancho Cordova (1), Redwood City (3), Sacrament (1), Sacramento (19), San Diego (87), San Francisco (24), San Jose (4), Simi Valley (1), South San Francisco (1), Westlake Village (2),         (Developer: PGP Decryption, SQL, Star Schemas, Data Profiling IBM Atlas ETL Data Archit in Oakland, CA)

Featured Jobs Troubleshooting Engineer (Jobs in Des Moines, Iowa) Application Developer (Jobs in Richmond, Virginia) Business Analyst Business Analyst (Jobs in Richmond, Virginia) Consultant (Jobs in Murfreesboro, Tennessee) TFS Automation Analyst (Jobs in Dimondale, Michigan) Cloud Architect (Jobs in Lansing, Michigan) GitHub Consultant (Jobs in Lansing, Michigan) IT Developer (Jobs in Atlanta, Georgia) Microsoft Consultant (Jobs in ANDERSON, South Carolina) Business Analyst JAD SQL Analyst (Jobs in Lansing, Michigan)