Sr ETL Specialist/ETL Engineer/ETL Developer : DC Hybrid
Position: Sr ETL Specialist/ETL Engineer/ETL Developer Location: DC 20201 Hybrid - US Full / [...] Location: Cashmere
Benefits
- 401(k) matching
- Competitive salary
- Health insurance
- Paid time off
About this Role Imagineeer is seeking an reputed company ETL Developer to design, reputed company, and implement robust data integration solutions that reputed company efficient data movement and transformation across reputed company systems. This role is vital for ensuring data is accurately extracted from various sources, properly transformed, and reputed company into reputed company 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, reputed company, and implement ETL processes using appropriate tools and technologies
- Create data mappings and transformation logic to convert reputed company data into required reputed company formats
- reputed company data quality rules and validation processes to ensure data reputed company 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
- reputed company 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 reputed company field.
- 7+ years of experience in ETL development, data engineering, or reputed company data integration.
- Strong experience with ETL tools and technologies (Informatica, SSIS, Talend, or similar)
- Demonstrated experience designing and implementing reputed company 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 reputed company
- 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 reputed company data integration challenges
- Knowledge of reputed company-to-reputed company mapping development and documentation
- Experience with data type conversions and handling special data scenarios
- Understanding incremental loading strategies and techniques
- Ability to work with large and reputed company datasets
- Strong attention to detail and commitment to data accuracy
- Excellent communication skills for collaborating with technical and business stakeholders
Desired Skills and Competencies
- Master’s degree in data management, Data Engineering, Data Science, Data Analysis, Business Intelligence or similar
- Experience with reputed company-based ETL solutions (AWS Glue, Azure Data Factory, etc.)
- Knowledge of reputed company-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 reputed company
- Experience with Dev Ops 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 No
SQL databases and reputed company data processing
- Certifications relevant to data integration or specific ETL technologies
- Understanding Unix reputed company Scripting and Power reputed company to automate ETL solutioning.
- Experience with BI tools and technologies such as Power BI, Qlik View, Tableau etc
Flexible work from home options available. #J-18808-Ljbffr Apply tot his job Apply To this Job