Mid ETL Specialist-Engineer-Developer
IMAGINEEER LLCWashington, DC, US12 days ago
Job type
- Full-time
Job descriptionDesign, develop, and implement ETL processes using appropriate tools and technologies Create data mappings and transformation logic to convert source data into required target formats Develop data quality rules and validation processes to ensure data integrity throughout the ETL lifecycle Optimize and automate ETL jobs for performance, efficiency, and scalability Troubleshoot and resolve ETL process failures and data quality issues Implement error handling, logging, and notification mechanisms in ETL workflows Create and maintain technical documentation for ETL processes, including data mappings and transformations Collaborate with data architects to understand data models and integration requirements Work with business analysts to translate business requirements into technical ETL solutions Work with stakeholder on understanding clients existing ETL solution and propose a future modernization ETL solution Develop and implement data reconciliation processes to validate ETL accuracy Create and execute test cases to verify ETL functionality and data quality Implement incremental load strategies and change data capture mechanisms Monitor ETL job execution and ensure timely completion of scheduled processes Support data migration activities and system integration projects Implement metadata management practices for ETL processes U.S. Citizen with ability to obtain and maintain a Public Trust clearance . Bachelors degree in Computer Science, Data Engineering, Information Systems, or related field. 5 + years of experience in ETL development, data engineering, or enterprise data integration. Strong experience with ETL tools and technologies (Informatica, SSIS, Talend, or similar) Demonstrated experience designing and implementing complex data integration solutions Experience with SQL and relational database systems Expert knowledge of ETL methodologies, patterns, and best practices Proficiency with at least one major ETL platform or framework Strong SQL skills for data extraction, transformation, and querying Experience with data profiling and data quality assessment techniques Knowledge of data warehouse concepts and dimensional modeling Experience implementing error handling and exception management in ETL processes Understanding of performance optimization techniques for data processing Experience with scheduling and orchestration of ETL workflows Strong problem-solving skills for addressing complex data integration challenges Knowledge of source-to-target mapping development and documentation Experience with data type conversions and handling special data scenarios Understanding of incremental loading strategies and techniques Ability to work with large and complex datasets Strong attention to detail and commitment to data accuracy Excellent communication skills for collaborating with technical and business stakeholders Experience with cloud-based ETL solutions (AWS Glue, Azure Data Factory, etc.) Knowledge of real-time data integration and streaming technologies Experience with big data technologies (Hadoop, Spark, etc.) Familiarity with data governance principles and practices Experience with version control systems for ETL code management Knowledge of API integration and web services Experience with metadata management tools and practices Understanding of master data management concepts Experience with DevOps practices for ETL deployment Knowledge of data privacy regulations and secure data handling practices Experience supporting federal government data systems, HHS experience preferred Familiarity with Agile and Hybrid development methodologies Experience with data migration projects Knowledge of NoSQL databases and unstructured data processing Certifications relevant to data integration or specific ETL technologies Understanding Unix Shell Scripting and PowerShell to automate ETL solutioning.
Job Description
Job Description
Benefits :
- 401(k) matching
- Competitive salary
- Health insurance
- Paid time off
About this Role :
Imagineeer is seeking an experienced ETL Developer to design, develop, and implement robust data integration solutions that enable efficient data movement and transformation across enterprise systems. This role is vital for ensuring data is accurately extracted from various sources, properly transformed, and loaded into target systems to support business intelligence, reporting, and analytics initiatives. The ideal candidate possesses strong technical expertise in ETL tools and methodologies, combined with excellent problem-solving skills and data management knowledge. This position may require the ability to obtain and maintain a Public Trust clearance.
Key Responsibilities :
Qualifications and Skills :
Desired Skills and Competencies :
Flexible work from home options available.
Create a job alert for this search
Etl • Washington, DC, US
Related jobs Mid-Level ETL Specialist / ETL Engineer.Department of Health and Human Services (HHS).The role is responsible for designing, developing, and maintaining Extract, Transform, Load (ETL) processes tha...Show moreLast updated: 26 days ago 
As the nation's largest producer of clean, carbon-free energy, Constellation is focused on our purpose : accelerating the transition to a carbon-free future.
We have been the leader in clean ener...Show moreLast updated: 3 days ago
VTG is seeking a highly qualified.Submarine Warfare Federated Tactical Systems (SWFTS) to lead development and deployment of the next generation tactical systems being deployed to US Navy submarine...Show moreLast updated: 30+ days ago
DRS RADA Technologies, a subsidiary of Leonardo DRS, is focused on proprietary radar solutions and legacy avionics systems supporting the defense industry globally.
The company is a global pioneer o...Show moreLast updated: 27 days ago
Acclaim Technical Services, founded in 2000, is a leading language, operations, and technology services company supporting a wide range of U.
We are an Employee Stock Ownership Plan (ESOP) comp...Show moreLast updated: 9 days ago
Are you interested in shaping the future of transportation? Consider joining the Leidos team operating FHWA’s.Saxton Transportation Operations Laboratory (STOL),.
USDOT research lab focused on...Show moreLast updated: 30+ days ago The applicant shall join the Leidos Gibbs & Cox Survivability Department as an Electrical Engineer to the naval ship design team located in Washington, D.
The applicant must work well in a team ...Show moreLast updated: 7 days ago The Leonardo DRS Airborne and Intelligence Systems business is a global leader and strategic partner committed to delivering world-class, full life-cycle defense and intelligence products that prot...Show moreLast updated: 27 days ago As the nation's largest producer of clean, carbon-free energy, Constellation is focused on our purpose : accelerating the transition to a carbon-free future.
We have been the leader in clean ener...Show moreLast updated: 3 days ago The Leonardo DRS Airborne and Intelligence Systems business is a global leader and strategic partner committed to delivering world-class, full life-cycle defense and intelligence products that prot...Show moreLast updated: 27 days ago As the nation's largest producer of clean, carbon-free energy, Constellation is focused on our purpose : accelerating the transition to a carbon-free future.
We have been the leader in clean ener...Show moreLast updated: 3 days ago DRS RADA Technologies, a subsidiary of Leonardo DRS, is focused on proprietary radar solutions and legacy avionics systems supporting the defense industry globally.
The company is a global pioneer o...Show moreLast updated: 27 days ago 
Are you a systems thinker with model-based systems engineering (MBSE) experience that wants to have impact on nationally important defense programs.
Do you enjoy developing and deploying cutting edg...Show moreLast updated: 30+ days ago Imagineeer is seeking an experienced ETL Developer to design, develop, and implement robust data integration solutions that enable efficient data movement and transformation across enterprise syste...Show moreLast updated: 26 days ago Are you looking for exciting opportunities to lead efforts to model, analyze, and develop state of the art concepts in integrated and layered missile defense involving kinetic and non-kinetic capab...Show moreLast updated: 30+ days ago As the nation's largest producer of clean, carbon-free energy, Constellation is focused on our purpose : accelerating the transition to a carbon-free future.
We have been the leader in clean ener...Show moreLast updated: 3 days ago As the nation's largest producer of clean, carbon-free energy, Constellation is focused on our purpose : accelerating the transition to a carbon-free future.
We have been the leader in clean ener...Show moreLast updated: 3 days ago 
BAE Systems is seeking an experienced Lead Engineer to join our Integrated Defense Solutions team in an exciting program supporting the U.
Navy's next generation of strategic deterrent and integ...Show moreLast updated: 30+ days ago
- Promoted
Mid-Level ETL Specialist-ETL Engineer-ETL Developer
IMAGINEEER LLCWashington, DC, USFull-time
- Promoted
I&C, Engineer
Constellation EnergyBenedict, MD, USFull-time
- Promoted
SWFTS Lead Engineer
VTGManassas, VA, USFull-time
- Promoted
Project Engineer (Not remote)
Leonardo DRSGermantown, MD, United StatesRemote
Full-time
- Promoted
ETL Developer (2025-0117)
Acclaim Technical ServicesBethesda, MD, USFull-time
- Promoted
V2X Test and Development Engineer
LeidosGermantown, MD, USFull-time
- Promoted
Electrical Engineer (EMI Support)
LeidosMount Vernon, VA, USFull-time
- Promoted
Senior Principal Digital Design Engineer
Leonardo DRSFrederick, MD, United StatesFull-time
- Promoted
Engineer, Mechanical
Constellation EnergyHuntingtown, MD, USFull-time
- Promoted
Senior Embedded Software Engineer
Leonardo DRSFrederick, MD, United StatesFull-time
- Promoted
Engineer, Electrical
Constellation EnergyBenedict, MD, USFull-time
- Promoted
Algorithm Engineering Team Manager
Leonardo DRSGermantown, MD, United StatesFull-time
- Promoted
Senior Model Based Systems Engineer
The Johns Hopkins University Applied Physics LaboratoryLaurel, MD, United StatesFull-time
- Promoted
Sr ETL Specialist / ETL Engineer / ETL Developer
IMAGINEEER LLCWashington, DC, USFull-time
- Promoted
Senior Missile Defense Systems Modeling and Analysis Engineer
The Johns Hopkins University Applied Physics LaboratoryLaurel, MD, United StatesTemporary
- Promoted
Electrical, Engineer
Constellation EnergyBenedict, MD, USFull-time
- Promoted
Mechanical, Senior Engineer
Constellation EnergyHuntingtown, MD, USFull-time
- Promoted
Engineering Support Lead Engineer
BAE SystemsRockville, MD, USFull-time