Hi,
We have an opening for....... Job Title: Sr. ETL Developer Location: Oakland, CA Duration: 6+ Months Position Summary: The IT Decision Support Systems group of IR&C Application Services is charged with the development and maintenance of the enterprise Decision Support Systems serving the information needs of the Office of the President and the campuses. The position requires considerable administrative and technical coordination in a highly complex technical and organizational environment and results in systems designed to meet the corporate and campus business information and analytical needs. The resulting systems include extremely complex state of the art enterprise Decision Support Systems. Under direction of the IT Decision Support System Manager and other members of the DSS team, the incumbent is responsible for designing and implementing robust Extract Transform and Load applications and processes to load data and supporting metadata into the decision support systems. Responsible for the ongoing operational stability of the ETL processes ensuring they are properly monitored and audited to provide data integrity, accuracy and timeliness of delivery. Proposed Job Duties: . In collaboration with the DSS Data Warehouse Architect, Data Analysts and DSS Business Partners and using the IBM InfoSphere tool set for data and metadata management, provide ETL design, architecture, technology, processes and best practices recommendations and strategies that support the development and implementation of enterprise data warehousing and an enterprise metadata repository. . With other IT DSS team members participate in the development and implementation of standards, policies and best practices in the development and maintenance of the decision support systems. Build and Maintain ETL processes 70% Working closely with Data Warehouse 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 and maintenance of extract processes to assure the selection of correct data, including design 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 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 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 IT DSS Manager and the Data Warehouse Architect with status and progress reports on development and maintenance activities as required. Job Requirements: . Minimum four years experience in data related work with at least 2 years as a senior ETL analyst for large, complex decision support systems. Experience with IBM DataStage 8.1, QualityStage and FastTrack preferred. . Extensive experience in extract transform and load, data profiling, data quality, metadata management and data intake for large complex data systems. . Bachelors Degree in Information Systems or a related field or an equivalent combination of education and experience. . Strong interpersonal skills; ability to work on cross-functional teams. . Strong verbal and written communication skills with an ability to express complex technical concepts in business terms and complex business concepts in technical terms . Self motivated and independent, able to work with a minimum of supervision and able to work well with stakeholders and project staff . Ability to prioritize and multi task across numerous work streams . Ability to plan and organize technical work and deliverables. Able to lead teams to consensus decisions on complex business and technical data challenges . 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, InfoSphere tool set and Business Objects tool set. Significant Contacts Title/Organization Purpose of ContactFrequency Business Sponsor/Stakeholder/Project Manager Elicit requirements, translate into technical ETL requirements, plan and participate in development of test plans and activities as needed Data Warehouse Group Manager and Technical Leads Take direction, provide status as required, plan and execute work plans and initiatives Daily Other IR&C Managers and Technical Experts Collaborate with other IR&C staff to assure deliver of the decision support system. As scheduled Please send me your Updated Resume and these details ASAP: Full Name: Contact No: E-mail ID: Availability: Visa Status/Citizenship: Current Location: Rate or Employer Details: Regards, Sam Resource Manager Ling Technologies, Inc. I 9161 Liberia Ave, Suite 200 Manassas, VA 20110 Work: 703-880-2641 Extn:207I Fax Toll Free 866-473-6904I [email protected] I www.ling-tech.com <http://www.ling-tech.com/> I YChat: [email protected] Disclaimer: We respect your Online Privacy. This is not an unsolicited mail. Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include Contact information and a method to be removed from our mailing list. If you are not interested in receiving our e-mails then please reply with a REMOVE in the subject line and mention all the e-mail addresses to be removed with any e-mail addresses which might be diverting the e-mails to you or click on this link to be removed. Remove link: mail to <http://www.mail2web.com/cgi-bin/compose.asp?mb=inbox&mp=I&mps=1&lid=0&intLi stPerPage=20&ed=yWqIig6kAEXMbfqWN9QPG8o8mJKR%2BXVqwKSvjjReOhppgzo365Vkuqbcp% 2F4%2BBBdKbIM5H5%2FE%2FBzH%0D%0AdtlYIbONgBb%2Fa0PIWczfNwFJ6FQ9x0vDypqp6FFd33 9ycG8Rpv6HrdNkvfaJlybPUoM%3D&[email protected]> sender. We are sorry for the inconvenience. CONFIDENTIALITY NOTICE: This confidential message/attachment contains information intended for a specific individual(s) on Staffing/Consulting/Recruitment purpose and it may contain confidential, proprietary or legally privileged information of Ling Technologies Inc. Any inappropriate use, inappropriate distribution or inappropriate copying is strictly prohibited. If received in error, notify the sender and immediately delete the message. Neither this information block, is the typed name of the sender, nor did anything else in this message intend to constitute an electronic signature, unless a specific statement to the contrary is included in this message. Note: This is not an unsolicited mail. If you are not interested in receiving our e-mails then please click reply this mail with REMOVE in subject line. P Please consider the environment before printing this e-mail.
