Python, ETL Developer_Truist

About the Role

This role involves developing and maintaining ETL pipelines using Python to extract, transform, and load data from multiple sources. You will work on writing efficient SQL queries for data extraction, validation, reconciliation, and performance tuning. Additionally, you will implement data cleansing, transformation logic, and business rules to ensure high-quality datasets.

Key Responsibilities

• Develop and maintain ETL pipelines using Python to extract, transform, and load data from multiple sources.
• Write efficient SQL queries for data extraction, validation, reconciliation, and performance tuning.
• Implement data cleansing, transformation logic, and business rules to ensure high-quality datasets.
• Collaborate with stakeholders to gather requirements and translate them into technical specifications and workflows.
• Monitor pipeline execution, troubleshoot failures, perform root-cause analysis, and implement preventive fixes.
• Create and maintain technical documentation for ETL jobs, data mappings, and operational runbooks.

Skills & Qualifications

• Proficiency in Python programming language.
• Strong understanding of SQL concepts and ability to write efficient SQL queries.
• Experience with ETL tools and technologies.
• Good understanding of data structures and algorithms.
• Bachelor's degree in Computer Science or related field.
• Knowledge of version control systems like Git.

What You'll Learn

In this role, you will gain hands-on experience with ETL development, data transformation, and data quality assurance. You will learn to work with multiple data sources, develop efficient data pipelines, and ensure high-quality datasets. This role will also help you develop skills in collaboration, problem-solving, and technical documentation.

Resume Tip

When applying for this role, make sure to highlight your experience with Python, SQL, and ETL tools. Include specific examples of projects where you have worked with data pipelines, data transformation, and data quality assurance. This will help you stand out from other applicants and demonstrate your relevant skills and experience.