11 ETL Developer II Jobs in New York, NY
Sorry! This job is no longer available. Please explore similar jobs listed on the left.
Aegistech Inc. is Hiring an ETL Developer II Near New York, NY
Job Details
Please Note: Candidates MUST be Aegistechs W2.
The successful candidate's primary role as part of the BI TEC team will be to support a multi-million dollar Infrastructure, which spans multiple regions (NY, LON & Asia). The Infrastructure uses a combination of technologies including MS SQL Server and Oracle database.
The candidate will work closely with various development teams and Business managers to enhance the Data Warehouse and reporting elements of the platform. Good technical knowledge of the SQL Server stack with strong core PL/SQL along with a solid understanding of Data Warehousing design principles Strong SSIS and core TSQL/PLSQL skills are essential, along with a solid understanding of Data Warehousing design principles. Control M knowledge for troubleshooting as well as enhancing the batch is also needed. The role would suit a candidate with at least 5 years' experience of working within capital market domain. Previous experience working within Risk, Finance or Product Control areas is desirable although a strong track record of comparable experience on large scale data warehousing implementations is also acceptable.
DAY-TO-DAY RESPONSIBILITIES:
- Define solutions paying particular attention to ensuring technical requirements have been factored in.
- Work with the overnight batch processes using scheduling software, Control-M.
- Work with wider Technology teams to ensure development and testing is coordinated and best practices are followed.
- Help define test cases and work closely with users assisting them with testing bug fixes or new features and functions.
- Collaborate with end users and help with BAU.
- Develop efficient ETL routines using advanced Oracle database technologies such as PL/SQL.
- Report to the Technology team lead and keep management abreast of status and progress on in-flight issues.
- Ensure due diligence has been carried out on all software changes, paying particular attention to detail on unit, component and systems integration testing.
- Package up artefacts using industry standard tools such as Subversion, SDA & TeamCity.
- Work with BAU teams to ensure project changes are released to live in a coordinated manner.
- Comply with the standard release cycle and deployment controls.
- Understanding of products related to Securities trading / Capital Markets.
- Will be responsible for production support.
- Be comfortable with on-call/out of hours support.
- Must adhere to all internal IT policies and controls while handling sensitive financial production data.
- Create data dictionary's and proper documentation on the Data Warehouse (Oracle DB).
THE SKILLS YOU NEED TO GET THE ROLE:
- 5 years of experience working within capital market domain.
- Solid Oracle Development skills with 11g or later.
- Solid SQL Server Development skills with version 2019 or later.
- Solid Experience of writing ETL Packages using SSIS.
- Data Warehousing Design Experience and Kimball Methodologies.
- Experience of working within a large database development project team.
- Control M Experience.
If youd like to learn more about this opportunity, please contact us directly at.
After you've applied, connect directly to the recruiter at
#Aegis
Job Summary
Full Time
IT Outsourcing & Consulting
$105k-127k (estimate)
03/20/2024
04/15/2024
aegistech.com
NEW YORK, NY
25 - 50
1994
STANLEY ADELMAN
$5M - $10M
IT Outsourcing & Consulting
Related Companies
About Aegistech Inc.
Aegistech is an IT Staffing and Consulting firm based in New York City. For two decades we've helped our clients -- global leaders in Finance, Pharma/Biotech, Publishing, eCommerce, Media and more -- hire the people that keep their brands technically innovative and at the forefront of their industries. Learn more about us and view all of our available IT opportunities at www.aegistech.com.
The job skills required for ETL Developer II include Team Development, Troubleshooting, Attention to Detail, etc. Having related job skills and expertise will give you an advantage when applying to be an ETL Developer II. That makes you unique and can impact how much salary you can get paid. Below are job openings related to skills required by ETL Developer II. Select any job title you are interested in and start to search job requirements.
The following is the career advancement route for ETL Developer II positions, which can be used as a reference in future career path planning. As an ETL Developer II, it can be promoted into senior positions as a Software Engineer III that are expected to handle more key tasks, people in this role will get a higher salary paid than an ordinary ETL Developer II. You can explore the career advancement for an ETL Developer II below and select your interested title to get hiring information.
Similar Jobs
Popular Articles
