What are the responsibilities and job description for the Python Developer position at Avance Consulting?
Role: Python Developer - SQL GCP
Hartford, CT
Fulltime
Required Qualifications:
- At least 4 years of Information Technology experience.
- Experience working with technologies like – GCP with data engineering – data flow / air flow, pub sub/ kafta, data proc/Hadoop, Big Query.
- ETL development experience with strong SQL background such as Python/R, Scala, Java, Hive, Spark, Kafka.
- Strong knowledge on Python Program development to build reusable frameworks, enhance existing frameworks.
- Good experience in end-to-end implementation of data warehouse and data marts.
- Strong knowledge and hands-on experience in Python and SQL.
- Knowledge on CICD pipeline using Terraform in Git.
Preferred Qualifications:
- Good knowledge on Google Big Query, using advance SQL programing techniques to build Big Query Data sets in Ingestion and Transformation layer
- Experience in Relational Modeling, Dimensional Modeling and Modeling of Unstructured Data
- Knowledge on Airflow Dag creation, execution, and monitoring
- Good understanding of Agile software development frameworks
- Ability to work in teams in a diverse, multi-stakeholder environment comprising of Business and Technology teams
- Experience and desire to work in a global delivery environment