Python Developer

Job Overview:

• We are seeking an experienced Python SQL and ETL Developer to create, construct, and uphold scalable data pipelines and integration solutions.
• The successful applicant will collaborate closely with data engineers, analysts, and business stakeholders to guarantee dependable, high-quality data delivery for reporting, analytics, and downstream applications.

Primary Duties:

• Design, develop, and sustain Python applications.
• Produce clean, efficient, and reusable Python code.
• Create data processing and automation scripts.
• Engage with databases utilizing SQL.
• Conduct code reviews and mentor junior developers.
• Diagnose application and data-related issues.
• Assist with production deployments and enhancements.
• Develop, maintain, and optimize ETL pipelines for data ingestion, transformation, and loading from diverse sources.
• Write efficient, scalable, and well-documented Python scripts for data processing and automation.
• Design and enhance complex SQL queries, views, and stored procedures for optimal performance and accuracy.
• Conduct data validation, quality checks, and reconciliation to ensure data integrity.
• Identify and resolve data pipeline failures and performance challenges.
• Work together with data analysts, data scientists, and business teams to comprehend data requirements.
• Implement best practices for data security, governance, and compliance.
• Maintain technical documentation for ETL processes and data models.

Technical Qualifications:

• Extensive experience in Python development.
• Solid understanding of SQL and data management.
• Experience in production environments.
• Strong proficiency in Python for data manipulation, scripting, and automation.
• Advanced knowledge of SQL joins, subqueries, window functions, and performance tuning.
• Practical experience with ETL/ELT tools or frameworks.
• Experience with relational databases such as e.g. MySQL, PostgreSQL, SQL Server, Oracle.
• Comprehensive understanding of data warehousing concepts, including fact and dimension tables, and star schemas.
• Capability to work with large datasets and enhance data processing workflows.
• Strong analytical, problem-solving, and debugging abilities.

Additional Duties:

• Experience with cloud platforms such as AWS, Azure, or GCP.
• Familiarity with big data technologies like Spark and Hadoop.
• Exposure to workflow schedulers such as Airflow, Prefect, or Cron.
• Knowledge of CI/CD pipelines and version control using Git.
• Understanding of data governance and lineage tools.

Preferred Expertise:

Technology->Open System->Open System- ALL->Python