close Advantages of 'Apply Now'
'Apply Now' provides you with a fast and easy way to apply to a job and has many benefits over other methods of applying including:
  • Apply to multiple jobs quickly and easily. If you've used the 'Apply Now' process before, we've already saved your information. Just select and preview your resume and optional cover letter and submit.
  • Receive confirmation of submission. With your information automatically sent and saved in our system, we'll make sure your resume gets in the recruiter's HotJobs account and we'll send you a confirmation email.
  • Stay organized in your job search. You can centrally manage your resume activity history online anytime. Keep track of the date, company and position you applied for, and the resume and cover letter you sent.

ETL Developer / ETL Architect: Aircell, Inc

Company NameAircell, Inc
Job CategoryInternet; Telecommunications
LocationItasca, IL
Position TypeFull-Time, Employee
Experience5-10 Years Experience
Desired Education LevelBachelor of Science
Date PostedOctober 27, 2009 (Reposted Nov 17)
View Aircell, Inc profile and job listings

Aircell is the world's leading provider of airborne communications. Gogo, powered by Aircell, turns a commercial airplane into a Wi-Fi hotspot with true inflight Internet access. We are hiring talented professionals to bring passengers a deep library of great videos inflight. COME ABOARD A WINNING TEAM!

Aircell offers an excellent compensation and benefits package. Aircell employees receive comprehensive group insurance programs including health, dental, and vision coverage. In addition, employees receive life insurance coverage, plus short- and long-term disability insurance. Employees can elect to participate in a 125 pre-tax benefit program for health or dependent-care expenses, as well as a generous 401(k) investment plan. Employees also receive paid vacation and 8 paid holidays per year.

Summary:

The ETL Developer will be responsible for creating, updating and maintaining ETL logic via the Business Objects Data Integrator tool that feeds the Enterprise Data Warehouse (EDW). The ETL Developer should have experience in both creating new ETL logic via an ETL tool, learning the logic and design of existing ETL processes, and being able to run and support them in an automated Production environment pulling nightly data out of multiple operational systems. The ETL Developer must also be able to architect a proper solution which optimizes ETL processes and the EDW data model for future data reuse and scalability.

The ETL Developer also has a familiarity with the end-to-end software development process, and has the flexibility to work in software projects that contain either a high level of rigor or the need to “fast-path” through the process without losing sight of quality or milestone dates.

The ideal candidate will be able to communicate with business and IT representatives at all levels to derive data requirements, translate them into design specifications that can meet requirements and scale for the future in the EDW environment, and implement quality, well tested solutions. The ideal candidate will also enjoy working in a small but growing IT organization, where outstanding work habits and quality product will be recognized by senior management.

Key Responsibilities:

  • Creating/maintaining ETL logic using the Business Objects Data Integrator tool.
  • Performing Production Support for ETL jobs, and finding new opportunities to introduce automation for monitoring, scheduling and restart/recovery for overnight batch pulls from operational systems..
  • Determining ETL Data Architecture and strategies to ensure ETL processes and Data Warehouse data model are optimized for data reuse and scalability.
  • Understanding the EDW ETL and Data Architecture at a holistic level, what data is available across all operational systems feeding the EDW.
  • Performing impact analysis on existing ETL and EDW Data Model when new ETL logic or new source systems are introduced into the data warehouse.
  • Determine level of effort for ETL work given a set of requirements, and determine estimate to complete during implementation.
  • Show due diligence in all application development by well-documenting design, code and test scripts
  • Regularly report status, issues and risks to management.
  • Work with user groups to review design, assumptions, and quality test of work.
  • Act as the “face” of the EDW to business groups performing business analysis and data discovery.

Required Skills & Experience:

· 5-10 years overall technology / system life cycle development background

· 3-5 years with any major ETL tool (e.g., Informatica, DataStage), ideal candidate will have experience or exposure to the Business Objects Data Integrator Tool

· 3+ years in Database Design/Development, including familiarity with SQL Server, the SQL query language and basic database administrative tasks.

· 3+ years data modeling with exposure to Data Warehouse Star Schema and OLAP concepts. Experience with a major Data Modeling tool such as ERwin or Embarcadero.

· 1+ years supporting ETL jobs in a Production Environment, including scheduling, monitoring, troubleshooting and recovering overnight batch jobs

· Nice to have: 1 year of experience or exposure to real-time data architecture concepts and tools such as EAI, EII, Service Oriented Architectures (SOA) and middleware products such as IBM Tibco

· Nice to have: 1 year of experience or exposure to metadata management concepts, tools and best practices such as Master Data Management (MDM) and processes to collect/maintain/publish metadata to business and technical audiences

· Nice to have: exposure to Business Objects Universes and reporting tools (Webi, Infoview)

· Nice to have: Telecomm / Cellular technology background

· Nice to have: Consulting background

· End-to-end experience throughout the software development life-cycle, including laying out testable requirements, creating test scripts, documenting test results.

· Excellent written and verbal communication skills, with the ability to document and communicate business requirements and technical designs across all levels of Business and IT, including analysts, management and project stakeholders

· Ability to be a fast starter and hit the ground running, taking responsibility for an existing ETL architecture running in Production, and look for opportunities for improvement as new development work comes in.

· Ability to deliver in a sometimes high stress environment with urgent priority work and aggressive due dates

· Ability to manage ones own work, including self management of multiple tasks and provide regular and on demand status to management

· Comfortable working in a small team environment and having high visibility to senior management.

· Proactive mentality is required in the ideal candidate – assessing the situation for what it is, making things happen and rolling with the punches as necessary.

HOW TO APPLY TO THIS OPENING

Prior to submitting your response, we encourage you to review our company web site, to learn more about us and the gogo Inflight Internet service.

We request that interested candidates send us your response via e-mail only. In your subject line please include the position title. Your resume & cover in plain text, MS Word or RTF is welcomed at recruiting@aircell.com This e-mail address is being protected from spam bots, you need JavaScript enabled to view it

Please no agencies, phone calls, third parties.

Aircell LLC is an equal opportunity employer and works in compliance with both federal and state laws. We are committed to the concept regarding Equal Employment opportunity. Qualified candidates will be considered for employment regardless of race, color, religion, age, sex, national origin, marital status, medical condition or disability.

e


Tips For A Safe Job Search: Never give your bank account information, credit card or social security number to a prospective employer. Do not accept any offers to cash checks or wire money. Click here to Learn More.

NOTICE: We collect personal information on this site. To learn more about how we use your information, see our Privacy Policy.

About Yahoo! HotJobs | Affiliate Program | Advertise with us