ETL Developer

Description

The National Security Sector within Leidos is seeking a highly skilled ETL Developerwith expertise in Informatica PowerCenter, Informatica Intelligent Cloud Services (IICS), and Databricksto join our team. The ideal candidate will have extensive experience in designing, developing, and optimizing ETL pipelines, ensuring data integrity, and working with cloud-based data platforms. This role requires a strong background in data warehousing, cloud migrations, and performance tuning. The candidate should have a proven track record of working on complex projects with high data volume transactions.

This position supports the Passenger Systems Program Directorate (PSPD) Interface and Support Processes division within Customs and Border Protection (CBP). PSPD supports the Department of Homeland Security (DHS) and CBP critical missions, specifically screening and processing travelers at the ports of entry (POEs) into the United States.

• This position REQUIRES onsite support in Ashburn, VA, twice a week

Key Responsibilities :

Design, develop, and maintain ETL processes using Informatica PowerCenter, IICS, and Databricks.

Develop and optimize data pipelines to integrate structured and unstructured data from various sources.

Work closely with data architects and business analysts to understand data requirements and translate them into scalable ETL solutions.

Perform data profiling, quality checks, and implement best practices for data governance.

Optimize performance of ETL jobs and data pipelines to ensure efficiency and scalability.

Support cloud data migration efforts, including integrating Informatica with cloud platforms (AWS, Azure, or GCP).

Troubleshoot and resolve issues related to data integration, transformations, and workflow execution.

Document ETL designs, processes, and technical specifications.

Handle high data volume transactionsefficiently and ensure system scalability.

Required Qualifications :

BA / BS with 8+ years of relevant experience or a Master's with 7 years of related experience; OR 4 years of related experience in lieu of degree

5+ yearsof experience in ETL development, data integration, and data engineering

Must be able to maintain and obtain a CBP Background Investigation prior to start

Expertise in Informatica PowerCenter and Informatica IICS(Cloud Data Integration & Application Integration).

Hands-on experience with Databricks(PySpark, Delta Lake, Notebooks, Workflows).

Strong experience in SQL, stored procedures, and performance tuning (SQL Server, PostgreSQL, Redshift, Snowflake, etc.).

Experience working with cloud-based data platforms(AWS, Azure, or GCP).

Knowledge of data warehousing concepts, data modeling, and ETL best practices.

Familiarity with REST APIs, JSON, and XML data processing.

Experience with job scheduling tools like Control-M, Airflow, or similar.

Strong problem-solving skills and ability to work independently or in a team environment.

Excellent communication skills and ability to collaborate with cross-functional teams.

Proven experience working on large-scale, complex projects with high data volume transactions.

Preferred Qualifications :

Active CBP BI

Experience with CBP PSPD

Experience with Kafka, Spark Streaming, or other real-time data processing technologies.

Familiarity with CI / CD pipelinesfor ETL deployments.

Experience with Python, Scala, or Shell scriptingfor data transformation and automation.

Knowledge of Data Governance, Security, and Compliance standards.

We're not looking for perfectly polished resumes or perfect fits. We're looking for people who break limits, ask hard questions, and don't wait to be told what's next. At Leidos, we're not following the roadmap - we're redrawing it.

Original Posting : November 6, 2025

For U.S. Positions : While subject to change based on business needs, Leidos reasonably anticipates that this job requisition will remain open for at least 3 days with an anticipated close date of no earlier than 3 days after the original posting date as listed above.

Pay Range :

Pay Range $104,650.00 - $189,175.00

The Leidos pay range for this job level is a general guideline onlyand not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.

About Leidos

Leidos is an industry and technology leader serving government and commercial customers with smarter, more efficient digital and mission innovations. Headquartered in Reston, Virginia, with 47,000 global employees, Leidos reported annual revenues of approximately $16.7 billion for the fiscal year ended January 3, 2025. For more information, visit www.Leidos.com .

Pay and Benefits

Pay and benefits are fundamental to any career decision. That's why we craft compensation packages that reflect the importance of the work we do for our customers. Employment benefits include competitive compensation, Health and Wellness programs, Income Protection, Paid Leave and Retirement. More details are available at www.leidos.com / careers / pay-benefits .

Securing Your Data

Beware of fake employment opportunities using Leidos' name. Leidos will never ask you to provide payment-related information during any part of the employment application process (i.e., ask you for money), nor will Leidos ever advance money as part of the hiring process (i.e., send you a check or money order before doing any work). Further, Leidos will only communicate with you through emails that are generated by the Leidos.com automated system - never from free commercial services (e.g., Gmail, Yahoo, Hotmail) or via WhatsApp, Telegram, etc. If you received an email purporting to be from Leidos that asks for payment-related information or any other personal information (e.g., about you or your previous employer), and you are concerned about its legitimacy, please make us aware immediately by emailing us at LeidosCareersFraud@leidos.com .

If you believe you are the victim of a scam, contact your local law enforcement and report the incident to the U.S. Federal Trade Commission .

Commitment to Non-Descrimination

All qualified applicants will receive consideration for employment without regard to sex, race, ethnicity, age, national origin, citizenship, religion, physical or mental disability, medical condition, genetic information, pregnancy, family structure, marital status, ancestry, domestic partner status, sexual orientation, gender identity or expression, veteran or military status, or any other basis prohibited by law. Leidos will also consider for employment qualified applicants with criminal histories consistent with relevant laws.