ETL Developer Python

Overview

Hybrid
Depends on Experience
Contract - W2
Contract - Independent
Contract - 6 Month(s)
No Travel Required

Skills

python
SQL

Job Details

Our client, a major bank in Iselin, NJ or New York City (Midtown Manhattan) is looking for hands-on ETL Developer (banking or financial experience is preferred)
Hybrid commute 2 day from office, 3 days remote.
 
This is 6+ months contract with possible extensions or option to hire.
** Must be authorized to work for ANY employer in US   - NO H1 Visa support for this role
ETL Developer Role:

•   Migrate existing SSIS ETL scripts to Python; develop new ETL scripts
•   Support existing SSIS SQL Projects
•   Maintain ETL pipelines in and out of data warehouse using combination of Python and Snowflakes SnowSQL
•   Write SQL queries against Snowflake.
•   Understanding data pipelines and modern ways of automating data pipeline using cloud-based
•   Work closely with existing senior integration staff to flush out design, priority and build.
•   Scaffolding and framework will be needed for staging and transforming datasets.
•   Use existing DevOps pipeline for Python and enhance if necessary.
•   Automate Python scripts on our Enterprise scheduler.
Strong troubleshooting skills to identify root cause and resolve production issues

QUALIFICATIONS:

•    5+ years of full-time development experience using Python.
•    Designing and implementing highly performant data ingestion pipelines from multiple sources using Azure Databricks.
•    Direct experience of building Data Pipelines using Azure Data Factory and (preferably Databricks).
•    Extensive experience in software development and the entire SDLC.
•    Experience in creating high-level product specifications and design documents.
•    Experience in writing Python applications with the benefit of frameworks like Django, Flask, Pyramid, or Tornado.
•    Experience in Python testing and code analysis tools like Pytest and Pylint.
•    Integration experience (ETL, ELT) with Python. 
•    Strong SQL skills.
•    Familiarity with SSIS is a big plus
•    General development expertise, use of version control, ticketing, and continuous integration systems.
•    Experience in using an Enterprise Scheduler (Tidal is preferred)
•    Experience in an Agile Development environment

  • On-point communication skills to concisley report status of work/issues and next action, and articulate technical complexity to Businss analysts, Project manager and Business users
  • Bachelor’s Degree in Computer Science or Finance or equivalent experience

Please email your resume or use this link to apply directly:
brainsworkgroup.catsone .com/careers/index.php?m=portal&a=details&jobOrderID=16106870
Or email: igork@brainsworkgroup .com
Check ALL our Jobs: brainsworkgroup.catsone .com/careers

 

 

 

Keywords: ETL sql ssis informatica dwh data warehousing banking financial azure snowflake databricks ELT market risk jira confluence tidal django flask pyramid tornado pytest pylint