Python ETL Developer

Location: San Francisco, CA
Title: Python ETL Developer 
Location: San Francisco, CA
Job Type: Long Term Contract
The developer works with architects, data analysts and business analysts to accept requirements, translates these requirements into solution design and participates in the full development process life-cycle from concept through testing, implementation, and support using the Agile development methodology. This includes leveraging/improving established Data Model, ETL framework, identifying approaches to creatively solve data and application problems.

  • Design and development of Data Warehouse/Data Mart. Be able to develop a project through its entire lifecycle.
  • Build distributed backend application in the cloud.
  • Understand repeatable automated processes for building the application, test it, document it, and deploy it at scale.
  • A desire to work as part of a growing, fast-paced, and highly-flexible team. Ability to quickly learn new technologies and adapt to a fast-paced development environment.
  • Work closely with Database Administrators and Data Integration (ETL) developers resulting in effective data driven solutions
  • Work closely with, and incorporate feedback from, product designers and other stakeholders in the company.
  • Establish quality processes to deliver a stable and reliable solution
  • Complex SQL, stored proc development
  • Understand the project proposal and assist the team in analyzing how the new system or functionality can be integrated in the current environment.
  • Ability to identify and resolve any performance and/or data related issues
  • Provide documentation (Data Mapping, Technical Specifications, Production Support, data dictionaries, test cases, etc.) for all projects  
Experience & Education:
  • 7+ Years of experience in ETL Developer role with deep knowledge of Informatica tool.
  • 3+ Years of experience in Python, Pandas, Django
  • 2+ Years of experience in Cloud implementation
  • Experience with Celery, RESTful APIs and server-side APIs integration
  • Strong experience in building data warehouse solutions using Python.
  • Strong ETL performance-tuning skills and the ability to analyze and optimize production volumes and batch schedules.
  • Experience in SQL, PL/SQL / T-SQL
  • Experience with ETL, SFTP/SSH, Unix/Linux, as well as Git or other version control systems
  •  Expertise in operational data stores and real time data integration 
  • Experience with Development Methodologies, Databases Platforms and Data Modeling tools (ERwin/Model Manager) 
  • 10+ Years of in MS SQL Server Database Design/Development
  • Expert level skill in modelling, managing, scaling and performance tuning high volume transactional database.
  • Bachelor's Degree in computer science or equivalent experience.
this job portal is powered by CATS