TechnoGen
ETL SSIS Developer
TechnoGen, Iselin, New Jersey, us, 08830
Title:
ETL SSIS Developer
Location: Iselin, NJ (Hybrid)
Duration: Long-term Contract
In person interview required
Must have: SQL, Snowflake, ADF, Databricks, Python, Tidal scheduling
.
Duties
Integration engineer responsible for daily support and project based development of credit risk management systems.
ETL developers are responsible for designing and creating the data warehouse and all related extraction, transformation and load of data functions.
This is an opportunity to gain experience in risk management processing using new technologies.
SkillsMS SQL Server Development skills.Strong
T-SQL knowledge
and skills required.Min 5 years' experience in writing DDL/DML SQL scripts, stored procedures, functions required.Troubleshoot production issues; perform root cause analysis and implement technical resolutions in a timely manner.Data modelling experience.Support existing SSIS SQL ProjectsKnowledge of Azure/Databricks/Python is a plus (good to have).Candidate will be primarily responsible for maintaining and resolving etl/database related issues.Works independently and drives assign tasks to completion.Writing SQL queries against Snowflake.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.Strong troubleshooting skills to identify root cause and resolve production issues.Strong SQL skills (Mandatory)
SSIS (mandatory)5 years of full-time development experience using Python (good to have)Experience building data pipelines using
Azure Data Factory and Databricks (good to have)Experience with
Python application frameworks (Django, Flask, Pyramid, Tornado)Experience with
Python testing and code analysis tools (Pytest, Pylint)Strong troubleshooting skillsOn-point communication skills
ETL SSIS Developer
Location: Iselin, NJ (Hybrid)
Duration: Long-term Contract
In person interview required
Must have: SQL, Snowflake, ADF, Databricks, Python, Tidal scheduling
.
Duties
Integration engineer responsible for daily support and project based development of credit risk management systems.
ETL developers are responsible for designing and creating the data warehouse and all related extraction, transformation and load of data functions.
This is an opportunity to gain experience in risk management processing using new technologies.
SkillsMS SQL Server Development skills.Strong
T-SQL knowledge
and skills required.Min 5 years' experience in writing DDL/DML SQL scripts, stored procedures, functions required.Troubleshoot production issues; perform root cause analysis and implement technical resolutions in a timely manner.Data modelling experience.Support existing SSIS SQL ProjectsKnowledge of Azure/Databricks/Python is a plus (good to have).Candidate will be primarily responsible for maintaining and resolving etl/database related issues.Works independently and drives assign tasks to completion.Writing SQL queries against Snowflake.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.Strong troubleshooting skills to identify root cause and resolve production issues.Strong SQL skills (Mandatory)
SSIS (mandatory)5 years of full-time development experience using Python (good to have)Experience building data pipelines using
Azure Data Factory and Databricks (good to have)Experience with
Python application frameworks (Django, Flask, Pyramid, Tornado)Experience with
Python testing and code analysis tools (Pytest, Pylint)Strong troubleshooting skillsOn-point communication skills