Sr ETL Specialist/ETL Engineer/ETL Developer
Company: IMAGINEEER LLC
Location: Washington
Posted on: February 16, 2026
|
|
|
Job Description:
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: Design, 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 Qualifications and Skills: 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. 7 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 Desired Skills and
Competencies: Masters degree in data management, Data Engineering,
Data Science, Data Analysis, Business Intelligence or similar
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. Experience with BI tools and
technologies such as Power BI, QlikView, Tableau etc Flexible work
from home options available.
Keywords: IMAGINEEER LLC, Dale City , Sr ETL Specialist/ETL Engineer/ETL Developer, IT / Software / Systems , Washington, Virginia
