Mid ETL Specialist-Engineer-Developer
Full Time • Hybrid - US
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 client’s 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.
- Bachelor’s 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
Desired Skills and Competencies:
- 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.
Flexible work from home options available.
Compensation: $115,000.00 - $122,000.00 per year
About Us
Our Approach
We firmly believe in the uniqueness of every business, necessitating a personalized approach to transformation. This conviction drives us to invest time in comprehending an organization's historical challenges and operational framework. Our commitment is to foster innovation by adopting a tailored strategy that optimizes the utilization of an organization's human resources and data assets. With a wealth of experience, we specialize in guiding organizations through the implementation of post-quantum security, protocols for autonomy, and artificial intelligence.
We are committed to working with clients to positively disrupt, modernize, and transform their organizations and business processes. Noteworthy achievements include initiatives aimed at enhancing human resilience in the food supply chain, leveraging autonomy for streamlined operations, establishing root-of-trust capabilities for high-quality, trusted data, and designing ecosystems and tools for securing and transferring digital value through digital wallets. . Our proficiency extends to using artificial intelligence and data to fortify security and enhance visibility in data assets, aiding in the management of health issues at local, state, and national levels. We've developed a modern security posture to effectively mitigate risks associated with cyber attacks from nation-states. Our wealth of experience is underpinned by collaborative work with diverse multidisciplinary teams, thriving in highly complex and rapidly changing environments.
Our Mission
Imagineeer's mission is to empower transformation through the operationalization of intuition. We establish an innovation pipeline, reimagining operations by delving into data analysis to optimize outcomes for our valued customers.
Collaborating closely with our clients, we strive to actualize the inherent genius embedded within their organizational structure. Our efforts focus on the transformation of organizations, emphasizing the development of foundational strengths in key areas, including data, personnel, hypothesis development, and the cultivation of a learning-from-failure mindset.
(if you already have a resume on Indeed)