Python Developer

Job Overview:

• We are in search of a proficient Python SQL and ETL Developer responsible for the design, construction, and maintenance of scalable data pipelines along with data integration solutions.
• The successful candidate will collaborate closely with data engineers, analysts, and business partners to guarantee dependable and high-quality data delivery for reporting, analytics, and downstream applications.

Primary Duties:

• Design, develop, and sustain Python applications.
• Create clean, efficient, and reusable Python code.
• Develop scripts for data processing and automation tasks.
• Engage with databases using SQL.
• Conduct code reviews and mentor junior developers.
• Diagnose application and data-related issues.
• Assist with production deployments and enhancements.
• Create, maintain, and optimize ETL pipelines to ingest, transform, and load data from various sources.
• Craft efficient, scalable, and well-documented Python scripts for data processing and automation.
• Design and enhance complex SQL queries, views, and stored procedures with a focus on performance and accuracy.
• Execute data validation, quality checks, and reconciliation to ensure data integrity.
• Identify and resolve failures and performance issues within data pipelines.
• Work in partnership with data analysts, data scientists, and business teams to comprehend data needs.
• Adopt best practices for data security, governance, and compliance.
• Maintain technical documentation for ETL workflows and data models.

Technical Qualifications:

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

Additional Qualifications:

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

Preferred Expertise:

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