Japanese IT company seeks an Japanese Bilingual ETL/Python Developer in Credit Risk.

Job Overview:

This role is based in New York, requiring the successful candidate to be on-site (NY and/or NJ office) a couple of times a week (up to 5 times a week if it's needed). US. Visa/Work Permit could be offered to the eligible candidate. We are also open to a contract-based assignment such as C2C.

The unmatched combination of two world-class companies and ISID's daring spirit to explore new business areas is the DNA that fuels our success. Leveraging our four strengths –

• Fusion of business expertise and IT implementation power
• Global network for worldwide collaboration
• Research and development excellence
• Unmatched synergies as part of the Group
• We provide valuable solutions to our clients.

Responsibilities:

• Support and enhance existing SSIS SQL Projects.
• Migrate existing SSIS ETL scripts to Python.
• ETL pipelines in and out of data warehouse using combination of SSIS, Python and Snowflakes SnowSQL.
• Writing SQL queries against Snowflake.
• Developing scripts Python etc. to do Extract, Load and Transform data.
• 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.

Required Qualifications:

• 8 years of development experience using Python.
• Designing and implementing highly performant data ingestion pipelines from multiple sources.
• Direct experience of building data pipelines using Azure Data Factory and (preferably Databricks).
• Extensive experience in software development and the entire SDLC.
• Solid understanding of a variety of programming tools and development platforms.
• 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.
• Strong understanding and proficent experience of using SSIS as ETL developer.
• General development expertise, use of version control, ticketing, and continuous integration systems.
• Experience in using an Enterprise Scheduler (Tidal).
• Experience in an Agile Development environment.
• On-point communication skills to concisely report status of work/issues and next action, and articulate technical complexity to Business analysts,
• Project manager and Business users.
• Experience of using Azure Databricks is a plus.

Work Style:

This role is based in New York, requiring the successful candidate to be on-site (NY office) a couple of times a week.

Contract:  Full Time Employee or C2C(negotiable)

Compensation:

The expected daily rate ranges from $480-640. Daily rate offers are based on a wide range of factors including relevant skills, training, experience, education, and, where applicable, certifications and licenses obtained. Market and organizational factors are also considered.