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
American Logistics Authority
...CDLA Tanker Truck Driver Hazmat Endorsement ( Pay: $2,100$2,800+ per week We are hiring experienced CDLA drivers with tanker and Hazmat endorsements to safely operate tanker trucks and transport materials following all federal and state regulations. Responsibilities...
HCA Florida Brandon Hospital
...eligibility for a Sign-On Bonus up to $15,000!** Service Line: Operating Room Clinical Coordinator (Evening Board Runner) Hours: Tues-... ...: Tues-Fri: 1230-2300 What you will do in this role: Assists with admission and discharge processes to ensure efficient...
All Medical Personnel
...from the worksite within a 20-25 minute commute Flexibility to work scheduled shifts, including covering breaks and staffing... ...availability that does not conflict with school or other commitments for student candidates Adherence to punctuality and attendance policies;...
TriMas Corporation
...A leading packaging solutions provider offers a Summer Internship in Engineering based in Denver, Colorado. Interns will work on meaningful... ...GPA and be currently enrolled in an engineering program. This paid internship aims to provide real-world experience and may lead...
ATSU Work Study
...: None Purpose : Department office help and other duties as needed and assigned. Job Description : The department of audiology is seeking work-study students to perform the following tasks as assigned by the department. Your assigned scheduled hours will...