ETL Data Stage Specialist

$124,800 - $135,200/Yr

Pyramid Consulting - McLean, VA

posted 3 months ago

Full-time - Mid Level
McLean, VA
Professional, Scientific, and Technical Services

About the position

The ETL Data Stage Specialist position is an immediate contract opportunity based in McLean, VA, with a hybrid work model. This role is designed for a talented individual who can contribute to the development of scalable and reliable data solutions that facilitate the movement of data across various systems. The ideal candidate will possess a technology-first mindset, outstanding analytical skills, and a drive for innovation. The position requires the ability to work effectively both independently and as part of a team, demonstrating a willingness to experiment with new ideas, learn quickly from failures, and adapt to changing circumstances. In this role, the specialist will be responsible for developing data solutions that operate in real-time as well as in batch modes, ensuring that data is efficiently processed and transferred from multiple sources. The position also involves creating innovative automation solutions within the realm of data engineering, utilizing Agile methodologies for technology implementations. The specialist will provide support for applications, addressing production defects, and implementing enhancements as necessary. A critical aspect of the role includes evaluating defects, investigating their causes, and devising effective solutions to resolve these issues. Clear communication regarding incident resolutions is essential, as the specialist will be providing production support to ensure smooth operations. This position is part of a leading financial services organization, which emphasizes the importance of delivering high-quality data solutions. The successful candidate will have the opportunity to work on various projects that contribute to the overall efficiency and effectiveness of data management within the company.

Responsibilities

  • Develop scalable and reliable data solutions to move data across systems from multiple sources in real time as well as batch modes.
  • Create innovative and automation solutions in the areas of data engineering using Agile methodologies.
  • Support applications by providing fixes to production defects and making enhancements.
  • Quickly evaluate defects, investigate causes, and devise solutions to address defects.
  • Provide production support and communicate clearly on the resolution of incidents.

Requirements

  • Bachelor's degree in Computer Science or Engineering or equivalent working experience.
  • 4-6 years of experience in delivering solutions using Software Development Life Cycle.
  • 4-6 years of ETL experience using DataStage, Unix, SQL, and Control-M.
  • Strong data analytical skills using complex data sources including databases and text data files.
  • Experience in data engineering solution delivery using SAS, AWS (S3, Glue, Athena, EMR, PySpark, Data Lake), Python, Snowflake, Dev Ops, and CI/CD tools.
  • Knowledge and experience working with Informatica.
  • Knowledge and experience working with Java.

Benefits

  • Health insurance (medical, dental, vision)
  • 401(k) plan
  • Paid sick leave
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service