Job Description
Role: SQL+SSIS ETL Engineer
Location: NJ (Hybrid)
Duration: 6+ Months
Job Description:
In person interview required
Must have : SQL strong, SSIS
Please share rating as per below skills (0-10)
Communication -
TSQL -
Dynamic SQL
DB/SQL Server -
DWH/ETL Concepts -
SSIS -
Python Programming-
NumPy-
Pandas -
SnowFlake -
Problem solving/Critical thinking -
Production Support -
Financial domain knowledge
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.
Skills:
• MS 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 Projects
• Knowledge 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 piplines 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 skills
On-point communication skills
Job Tags
Full time
Similar Jobs
Percipia
...Job description: We are seeking an associate with strong Graphic Design knowledge for our Chicago office. Our company serves a large... ...sales department on needed sales materials Job Type: Part-time Schedule: ~5-hour shifts ~ Monday to Friday Education...
Yochana
...Pega CSSA developer Lisle IL Onsite hybrid Sal - 125K Hrly - 60 /hr Qualification Total Experience: 6-8 years Min Experience in Pega: 6 Years Mandatory certification: Pega CSSA Mandatory Skills: Pega...
Westways Staffing Services
...least 2 years of experience in Acute Care ER. This role provides the opportunity to explore new locations while enjoying top industry pay, health benefits, and additional perks including 401K and travel reimbursement. Join a supportive team that prioritizes work-life...
Gold's Gym Washington
Housekeeping Janitor Porter Position Description: Responsible for maintaining the cleanliness of equipment and ensure it is sanitized. Sweeps, dusts, mops scrubs and vacuums hallways, stairs, office space and other assigned areas of the overall gym. Cleans,...
RADcube - A NLogix Company
...This is a remote position. Certified Medical Coder/Medical Record Audit Specialist... ...Medical Record Audit Specialist to support coding accuracy, medical record review, and... ...compliance, or related healthcare reimbursement experience. Familiarity with Indiana Medicaid...