ETL Engineer

Posted:
9/26/2024, 5:42:06 AM

Location(s):
Maryland, United States ⋅ Chevy Chase, Maryland, United States

Experience Level(s):
Mid Level ⋅ Senior

Field(s):
Data & Analytics

Position Summary  

GEICO is seeking an experienced ETL Engineer with strong expertise in Ab Initio tools and a proven track record in supporting Enterprise Data Warehouse operations. The ideal candidate will possess strong problem-solving skills, flexibility to work in 24x7 support shifts, and a passion for continuous process improvement. You will be responsible for managing production support issues, collaborating with cross-functional teams, and driving the efficiency of ETL processes while maintaining high availability and performance. 

 

Position Description 

Our ETL Engineer plays a key role in supporting the organization's data warehouse operations using ETL tools like Ab Initio. You will be responsible for production support, root cause analysis, and resolution of issues, working closely with monitoring tools like Control-M. The position demands hands-on experience with Ab Initio tools, a solid understanding of the software development lifecycle, and strong communication skills. The ideal candidate is a team player who is self-motivated, excels under pressure, and quickly adapts to a dynamic technological environment. 

 

Position Responsibilities 

As an ETL Engineer, you will: 

  • Support Enterprise Data Warehouse using ETL tools like Ab Initio. 

  • Handle production support operations, including incident management and independently triage root cause analysis of issues. Perform L1 and L2 production support 24x7. 

  • Communicate effectively on production support issues and manage tickets, resolutions, and reporting metrics. 

  • Collaborate with cross-functional teams to ensure smooth production operations. 

  • Maintain and enhance production support documentation. 

  • Identify and implement process improvements to increase efficiency and effectiveness.  

  • Provide training and support to junior team members as needed. 

 

Qualifications 

  • Ability to work overnight shifts (1 week on, 2 weeks off).

  • Minimum of 5 years of experience in ETL development using Ab Initio tools in a Data Warehousing environment.  

  • At least 4 years of experience in production support projects.  

  • Strong skills in Unix and SQL.  

  • Proficiency with Control-M or any other similar job scheduling tool.  

  • Experience with BMC ticketing/reporting tools.  

  • Basic knowledge of Azure cloud.  

  • Good oral and written communication skills.  

  • Experience with Enterprise Data Warehouse.  

 

 Experience 

  • ​​Hands-on experience with various Ab Initio tools including GDE, EME, etc. 

  • Familiarity with monitoring tools like Control-M. 

  • Strong understanding of the software development lifecycle. 

  • Ability to work as a team player, self-motivated, and capable of meeting deadlines. 

  • Problem-solving skills and the ability to learn quickly within a mature technology environment.  

 

Education 

  • Bachelor’s degree in computer science or a related field and/or equivalent experience.  


 

Annual Salary

$80,000.00 - $160,000.00

The above annual salary range is a general guideline. Multiple factors are taken into consideration to arrive at the final hourly rate/ annual salary to be offered to the selected candidate. Factors include, but are not limited to, the scope and responsibilities of the role, the selected candidate’s work experience, education and training, the work location as well as market and business considerations.


 

GEICO will consider sponsoring a new qualified applicant for employment authorization for this position.


 

Benefits:

As an Associate, you’ll enjoy our Total Rewards Program* to help secure your financial future and preserve your health and well-being, including:

  • Premier Medical, Dental and Vision Insurance with no waiting period**
  • Paid Vacation, Sick and Parental Leave
  • 401(k) Plan
  • Tuition Reimbursement
  • Paid Training and Licensures

*Benefits may be different by location.  Benefit eligibility requirements vary and may include length of service.

**Coverage begins on the date of hire. Must enroll in New Hire Benefits within 30 days of the date of hire for coverage to take effect.

The equal employment opportunity policy of the GEICO Companies provides for a fair and equal employment opportunity for all associates and job applicants regardless of race, color, religious creed, national origin, ancestry, age, gender, pregnancy, sexual orientation, gender identity, marital status, familial status, disability or genetic information, in compliance with applicable federal, state and local law. GEICO hires and promotes individuals solely on the basis of their qualifications for the job to be filled.

GEICO reasonably accommodates qualified individuals with disabilities to enable them to receive equal employment opportunity and/or perform the essential functions of the job, unless the accommodation would impose an undue hardship to the Company. This applies to all applicants and associates. GEICO also provides a work environment in which each associate is able to be productive and work to the best of their ability. We do not condone or tolerate an atmosphere of intimidation or harassment. We expect and require the cooperation of all associates in maintaining an atmosphere free from discrimination and harassment with mutual respect by and for all associates and applicants.