Lead Cloud ETL Engineer - 100% Remote Opportunity

Clearance Level
Software Engineering
Remote, Based in Maryland
Montgomery County, Maryland

REQ#: RQ119034

Travel Required: None
Requisition Type: Regular

As a Software Engineer Cloud ETL Expert you will provide operation and maintenance support to the program in addition to support the mission of migrating the IDR Teradata data and ETLs from Informatica to the Snowflake cloud.

In this role, a typical day will include:

  • Attend daily stand-up scrum calls.
  • Collaborate in a "war-room" setting with business analysts, developers, testers, architect, scrum master, and product owner to assist in grooming, designing, coding, unit testing user stories related to the Program Increment and current iteration.
  • Exercise positive interpersonal communication skills and works independently and within an agile team during all phase of the software development lifecycle.
  • Design, develop and implement complex ETL processes of healthcare data to meet a wide range of business and system requirements.
  • Support the ETL operational processes including but not limited to: automation, job scheduling, dependencies, monitoring, maintenance, patches, upgrades, security, and administration.
  • Investigate and corrects software defects and analyzes and maintains data quality.
  • Lead, mentor and provide guidance to 3-5 team members.
  • Identify process improvements and innovative ways to solve existing or new problems.
  • Uses expert knowledge to develop and apply advanced methods, theories and research techniques in the investigation and solution of complex and advanced software applications and problems.
  • Uses expert knowledge in the preparation and installation of solutions by determining and designing system specifications, standards, and programming.
  • Uses specialized knowledge to develop highly detailed documentation for new or existing programs.
  • Applies practical knowledge of job typically obtained through advanced education and work experience.
  • Hands-on participation in designing, developing, evaluating, planning.
  • Recognized as a Subject Matter Expert in software engineering.

Required Qualifications:

  • BA/BS in a Computer Science or related technical discipline or the equivalent combination of education, technical certifications or training, or work experience.
  • 15+ years of direct related computer programming experience.
  • 8+ years of IT experience with at least 8 years of SQL development experience developing on multiple relational database platforms including Teradata.
  • 2+ years of Cloud ETL development experience using AWS Services / tools, Databricks, Snowflake, and/or similar technologies.
  • 6+ years of physical data modeling, partitioning and developing. optimization/indexing strategies on the Teradata platform or similar DBMS.
  • 2+ years experience with Informatica PowerExchange/ Informatica PowerConnect/ Informatica PowerCenter.
  • 2+ years of experience with UNIX scripting and utilities.
  • In depth knowledge on Data Warehouse (DW) concepts for ETL Development.
  • 2+ year of experience in Code migration and deployment using AWS resources in the cloud environment.
  • 3+ years of experience in working with Python programming.
  • Experience in leading a technical team of 3-5 members.
  • Should have experience in participating in CMS reviews such as TRB (Technical Review Board).
  • Candidate must be able to obtain and maintain a Public Trust clearance and must have lived in the United States at least three (3) out of the last five (5) years.
  • Only US Citizenship and Green Card holder can be considered for this position.

Desired skills/experience

  • Prior experience developing healthcare IT solutions strongly preferred.
  • 4+ years of experience in Github, or similar version control tools.
  • Prior experience using the Agile development framework, and CI/CD DevOps.

Attributes for Success:

  • Demonstrates good solid communication skills.
  • Shows strong technical design and coding skills with cloud technologies.
  • Demonstrated out of the box, innovated ideas resulted in improved performance.




About Our Work

We are GDIT. The people supporting some of the most complex government, defense, and intelligence projects across the country. We deliver. Bringing the expertise needed to understand and advance critical missions. We transform. Shifting the ways clients invest in, integrate, and innovate technology solutions. We ensure today is safe and tomorrow is smarter. We are there. On the ground, beside our clients, in the lab, and everywhere in between. Offering the technology transformations, strategy, and mission services needed to get the job done.

COVID-19 Vaccination

GDIT does not have a vaccination mandate applicable to all employees. To protect the health and safety of its employees and to comply with customer requirements, however, GDIT may require employees in certain positions to be fully vaccinated against COVID-19. Vaccination requirements will depend on the status of the federal contractor mandate and customer site requirements.

GDIT is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.