the smart solution for Oakland jobs

ETL Developer

Company: Amerit Consulting
Location: Oakland
Posted on: June 13, 2018

Job Description:

Company Overview: Creating value by bringing together the right people to achieve results is our motto. Our clients and employees say they choose to work with us because of how we work with them - with service that exceeds their expectations and a personal commitment to their success. Our client, with missions in University teaching, research and public service and half-million annual enrollments, seeks an accomplished ETL Developer. Description: ETL Developer with Unix/ Shell Scripting skills to implement the migration to manage File Transfer project. 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. 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. Create/ modify Unix/ Shell scripts (60%): work towards implementing changes for new managed file transfer process. Create / modify existing Unix/ Shell scripts, batch jobs to process files transferred through MFT process. 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. 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. Requirements: Bachelor''s Degree in Information Systems or a related field or an equivalent combination of education and experience. 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. Strong familiarity with multi-dimensional Star schema and general DBMS concepts is required. Extensive experience in extract transform and load, data profiling, data quality, metadata management and data intake for large complex data systems. Ability to analyze, verify, and document the accuracy of the developed ETL code through self-directed testing. Deep knowledge of best practices through relevant experience across data-related disciplines and technologies particularly for enterprise wide data architectures and data warehousing/BI. Experience with IBM data warehouse environment. I''d love to talk to you if you think this position is right up your alley. If you''re looking for rewarding employment and a company that puts its employees first, we''d like to work with you. We''re driven, people driven. NOTE: Candidates that are offered a position are required to pass pre-employment drug and background screening. Qualified candidates with criminal histories, are considered in a manner that is consistent with local, state and federal laws.

Keywords: Amerit Consulting, Oakland, ETL Developer, IT / Software / Systems, Oakland, California

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Other IT / Software / Systems Jobs

Java Engineering Manager (1363)
Description: Java Engineering Manager 1363 LocationSan Francisco, CA SummaryThis role will lead a team of developers and will run and improve the fraud detection systems. Duties Participate in the full cycle of (more...)
Company: Cameron Craig Group
Location: San Francisco
Posted on: 06/23/2018

Windows System Administrator
Description: Hi all,We have an opening for a Windows System Administrator in Sacramento, CA. Please
Company: Horkus Solutions
Location: Sacramento
Posted on: 06/23/2018

Mobile Developer
Description: Let companies apply to you, not the other way around Sign up with Hired to get access to thousands of companies currently hiring mobile developers. Are you a Mobile Developer Would you like to build (more...)
Company: Hired
Location: San Carlos
Posted on: 06/23/2018

Need Java Full Stack Developer with Micro Service and Cloud (10+ yrs)
Description: Exp : 10 yrs. Only candidates who can share their LinkedIn Profile will be considered .Role : Java J2EE Fullstack Developer with Micro-servicesLocation : Foster City, CA Role and Responsibilities:-- (more...)
Company: ComTec Information Systems
Location: San Mateo
Posted on: 06/23/2018

Product Technology Specialist
Description: Overview br We are looking for a Product Technology Specialist who will be responsible for delighting our guests after the sale. The Product Technology Specialist will be responsible for explaining (more...)
Company: Penske Motor Group
Location: San Rafael
Posted on: 06/23/2018

Mobile Developer
Description: Let companies apply to you, not the other way around Sign up with Hired to get access to thousands of companies currently hiring mobile developers. Are you a Mobile Developer Would you like
Company: Hired
Location: Richmond
Posted on: 06/23/2018

PHP Developer - Bolinas
Description: Let companies apply to you, not the other way around Sign up with Hired to get access to thousands of companies currently hiring PHP developers. Are you a PHP Developer You will be
Company: Hired
Location: Bolinas
Posted on: 06/24/2018

Java Architect +Oracle ATG
Description: Java Solution Architect with Oracle ATG and
Company: Concept Software & Services, Inc.
Location: San Francisco
Posted on: 06/24/2018

Principal Software Engineer
Description: We are developing a cloud-based platform for precision medicine and clinical analytics designed to individualize medical treatments at the point of care. We are revolutionizing complex drug treatment (more...)
Company: RathRecruiting
Location: San Francisco
Posted on: 06/23/2018

Earn 800-1000 weekly for Health Benefits Company..MUST Have COMPUTER And PHONE
Description: We are currently hiring services reps who can work part-time or full-time from
Company: General Painting Company
Location: Mill Valley
Posted on: 06/23/2018

Log In or Create An Account


Forgot password?

Find us on Facebook

Find us on LinkedIn

Get the latest California jobs by following @recnetCA on Twitter!

Oakland RSS job feeds