ETL Developer at General Dynamics Information Technology

, Virginia, United States -

Full Time

Start Date

Immediate

Expiry Date

20 Jun, 26

Salary

161000.0

Posted On

22 Mar, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

ETL, AWS Glue, S3, Python, Spark, SQL, Athena, MySql, Informatica, ODI, Langchain, CrewAi, Llama, LLM Services, AWS Data Services, Oracle

Industry

IT Services and IT Consulting

Description

Type of Requisition: Regular Clearance Level Must Currently Possess: None Clearance Level Must Be Able to Obtain: None Public Trust/Other Required: Other Job Family: Data Science and Data Engineering Job Qualifications: Skills: Data Architecture, Data Requirements, Data Solutions Certifications: None Experience: 6 + years of related experience US Citizenship Required: Yes Job Description: GDIT’s DOJ/OJP team is looking for a dynamic and experienced ETL Developer to join our Agile teams. Our client is engaging in a significant overhaul of its legacy IT environment and approach. You, as the ETL Developer, will play a pivotal role in the planning and execution of this modernization effort. While working closely with senior Federal staff, Data Architects and the Business Analysts, you will design and implement ETL processes to support migration of legacy data to a redesigned modern application. Job Requirements: Design and implement industry best ETL technologies to satisfy client requirements. Design and develop optimal code to maintain exceptional performance in processing large volumes of data. Translate business requirements into technical specification. Design, develop, and test ETL solutions and automating data loading processes. Establish ETL environments according to project requirements. Develop and implement an efficient migration process to move ETL objects from development to test and production environments. Support the project team throughout the design, development and testing process. Participate in all design reviews and requirement sessions, as required. Support project documentation, as required. Understand database design, programming concepts, data modeling, and framework management. Communicate ideas to both technical and non-technical people in all levels of the organization. Work with Business Analysts, Data Architects, Enterprise Architects, and ETL Architects to ensure business requirements are being met with the solution being developed. Identify and reuse of ETL components and services to avoid duplicative implementations. Mentor other team members in developing, documenting and modifying ETL components. Develop advanced and complex ETL processes in the AWS GovCloud using the tools such as AWS Glue, S3, Python, Spark, SQL , Athena Support and administer the MySql database in the migration environment on the cloud. Required Qualifications: Excellent written and oral communication skills. 5+ years of working experience working with some industry leading ETL tools such as Informatica, ODI 1 year of working knowledge Langchain, CrewAi , Llama or other LLM services 2 years of working knowledge of the AWS data services – S3, Glue, Lambda, Sagemaker AI, EMR, RDS(relational data service) and other AWS services 4+ Years of working experience on the MySql, Oracle or any other RDBMS database. A demonstrated history of working in large enterprise level applications. Experience in working with database applications and SQL. Full comprehension of SQL, cardinality, levels of granularity, normalized vs de-normalized, database optimization techniques and other such data architecture best practices is required. Ability to work with various stakeholders with different technical abilities to gather data requirements. Experience working in cloud environments. Experience working in Agile development environments. A track record of delivery in challenging, face-paced environments BS or equivalent +6 yrs related experience, or MS + 3 yrs related experience. Contract Requirements: Contract Requires US Citizenship Must be able to obtain and maintain an Agency specific Public Trust clearance The likely salary range for this position is $119,000 - $161,000. This is not, however, a guarantee of compensation or salary. Rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range. Scheduled Weekly Hours: 40 Travel Required: None Telecommuting Options: Remote Work Location: Any Location / Remote Additional Work Locations: Total Rewards at GDIT: Our benefits package for all US-based employees includes a variety of medical plan options, some with Health Savings Accounts, dental plan options, a vision plan, and a 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match. To encourage work/life balance, GDIT offers employees full flex work weeks where possible and a variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave. GDIT typically provides new employees with 15 days of paid leave per calendar year to be used for vacations, personal business, and illness and an additional 10 paid holidays per year. Paid leave and paid holidays are prorated based on the employee’s date of hire. The GDIT Paid Family Leave program provides a total of up to 160 hours of paid leave in a rolling 12 month period for eligible employees. To ensure our employees are able to protect their income, other offerings such as short and long-term disability benefits, life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance are provided or available. We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most. We are GDIT. A global technology and professional services company that delivers consulting, technology and mission services to every major agency across the U.S. government, defense and intelligence community. Our 30,000 experts extract the power of technology to create immediate value and deliver solutions at the edge of innovation. We operate across 50 countries worldwide, offering leading capabilities in digital modernization, AI/ML, Cloud, Cyber and application development. Together with our clients, we strive to create a safer, smarter world by harnessing the power of deep expertise and advanced technology. Join our Talent Community to stay up to date on our career opportunities and events at gdit.com/tc. Equal Opportunity Employer / Individuals with Disabilities / Protected Veterans Join our 30,000 everyday heroes. We are GDIT. A global technology and professional services company that delivers consulting, technology and mission services to every major agency across the U.S. government, defense and intelligence community. Our 30,000 experts extract the power of technology to create immediate value and deliver solutions at the edge of innovation. We operate across 30 countries worldwide, offering leading capabilities in digital modernization, AI/ML, Cloud, Cyber and application development. Together with our clients, we strive to create a safer, smarter world by harnessing the power of deep expertise and advanced technology. For more information about GDIT's Privacy Policy, click here: https://www.gdit.com/privacy-policy/notices/

Responsibilities

The ETL Developer will design and implement ETL processes to support the migration of legacy data to a redesigned modern application as part of a significant IT environment overhaul. This involves designing and developing optimal code using industry best ETL technologies to meet client requirements and ensure exceptional performance with large data volumes.