Hi,
Please let me know if you are comfortable with the below job description.
Position Title – ETL Python developer
Start date – ASAP
Location – Atlanta/Charlotte
Job Description:
The ideal candidate will have experience in developing and maintaining ETL pipelines using Python, integrated with SQL server database and working with CI/CD environment. A strong grasp of Data warehousing concepts and good communication skills are essential for success in this role.
Key Responsibilities
1. Design, Develop, and Maintain ETL workflows and data pipelines using Python.
2. Extract data from various sources like File, Databases, API, and MS Outlook and transform/load into SQL server databases.
3. Automate data processing and ensure data accuracy, quality, completeness and consistency
4. Collaborate with Data engineers and data stakeholders to gather requirements and deliver solutions.
5. Optimize and troubleshoot SQL queries and stored procedures.
6. Integrate ETL flows into the CI/CD pipeline using Git
7. Document the ETK process and maintain version control for scripts and configurations.
8. follow best practices for data security, compliance, and privacy.
Technical skills
- Programming: String experience in Python (Pandas, SQLAlchemy, pyodbc, etc)
- Database: Proficient in Microsoft SQL server, stored Procedures, performance tuning
- ETL tools: Knowledge of MS SSIS tool is advantageous
- CI/CD: basic understanding of CI/CD concepts.
- SQL: proficient in writing SQL queries and analyzing complex queries.
Non-Technical Skills:
- Strong problem-solving and debugging skills
- Effective Communication and collaboration with cross-function teams.
- Ability to document work clearly and concisely
- Willingness to learn and adopt new technology.
Thanks & Regards,
Pankaj Kumar Sr. Technical Recruiter Tanisha Systems Inc |