Logo
Technogen International Company

Senior ETL Developer

Technogen International Company, Mc Lean, VA


Senior ETL Developer with Python

12+ months contract

Remote

Senior Candidate

Must be good in Python Coding.

Position Overview
We are seeking a skilled and motivated ETL (Extract, Transform, Load) Developer with strong expertise in AWS (Amazon Web Services) and Python to join our dynamic team. The ideal candidate will be responsible for designing, developing, and maintaining robust ETL processes to support our data integration and analysis needs. This role requires a deep understanding of data warehousing, data modelling, and a keen ability to translate business requirements into effective ETL solutions.
Key Responsibilities
• Design and Develop ETL Processes: Create and maintain efficient ETL pipelines to extract data from various sources, transform it to meet business requirements, and load it into data warehouses and other storage solutions.
• AWS Integration: Leverage AWS services such as S3, Redshift, Glue, Lambda, and RDS to design and implement scalable and secure data integration solutions.
• Data Modelling: Develop and maintain data models to support analytical reporting and data visualization needs.
• Python Scripting: Utilize Python for scripting and automation tasks within the ETL processes, ensuring data accuracy and reliability.
• Performance Optimization: Monitor and optimize ETL processes for performance and efficiency, identifying and resolving bottlenecks and issues.
• Documentation: Maintain comprehensive documentation of ETL processes, data flow diagrams, and data mappings.
• Troubleshooting: Provide support and troubleshooting for ETL issues, ensuring timely resolution of problems.
Qualifications
• Education: Bachelor's degree in Computer Science, Information Technology, or a related field.

Experience:
• Minimum of 10+ years of experience in ETL development.
• Proven experience with AWS services related to data integration and storage.
• Strong proficiency in Python for ETL scripting and automation.
Technical Skills:
• Expertise in data warehousing concepts and best practices.
• Experience with SQL and relational databases (e.g., PostgreSQL, MySQL).
• Familiarity with data modelling tools and techniques.