NewYorkRecruiter Since 2001
the smart solution for New York jobs

Data Warehouse Engineer - Informatica, ETL, SQL

Company: Emergent365 Inc (Formerly Blackstone Professional
Location: Whippany
Posted on: September 17, 2020

Job Description:

Data Warehouse - ETL, Informatica, SQL Financial Firm / Whippany, NJTarget Experience Level:--3-8 years--Job Summary:--A data warehousing / data engineering team is seeking an ETL Analyst/Engineer to take responsibility for Data Sourcing and Data Transformation with Informatica ETL.--Will be the junior member of a 3 person team.--The focus of the role will be sourcing data from internal API's and FTP feeds from upstream applications AND utilizing Informatica to transform that data.----The core tech stack includes SQL Server and Informatica.--The team is seeking someone with at least 2-3 years of experience sourcing and transforming data with an ETL tool - Informatica is preferred but not required and must also be very proficient with SQL Server.----Other tools and technologies you'll gain exposure to include Tableau, MongoDB, AWS and variety of CI/CD and DevOps tools.----This role can lead to multiple career paths such as Data Engineer, Data Architect, Data Warehouse Architect.--Must have: BS in Comp Sci or similar2+ years SQL Server - min basic SQL - preferably some data modeling exp2+ years of ETL, preferably with InformaticaStrong Data Sourcing and Data Transformation experienceJob Description: The purpose of this role is to deliver enhancements to a pre-existing Data Warehouse solution that involves technology transformation which will be delivered in an Agile way.--The candidate will be responsible for delivering to the needs of the Data Analytics team within the Internal Audit business. This will include working through prioritized user stories as part of Agile sprints, as well as developing and consuming data integrations between internal systems that exist outside the Internal Audit function using a variety of technology solutions such as ETL software, ad hoc database scripting, SFTP and API data exchange.Responsibilities: The primary function of this role is to deliver the functionality requested by the HOF function by closely working with the development manager:Rapidly learn applications in the HOF Technology environmentWork with architects and team leads to design & implement appropriate technical solutionsDesign low-level technical solutionsCome up with effort estimates for assigned workWrite code and automated unit test cases as requiredCollaborate with testers to analyze defects, verify behavior, and resolve issuesRequirements:--A Bachelor's degree in engineering, computer science or a quantitative discipline e.g. statistics, physics or mathematics preferred2-3 years of experience in banking / finance or BIA experience advantageous2-3 years of experience working with data visualization and reporting tools, e.g. Tableau, Qlikview, Business Objects2-3 years of experience with platforms such as Mongo, DocumentDB2-3 years of programming experience with high-level language such as Java or C#2-3 years of experience with DevOps pipeline technologies, e.g. Jenkins, TeamCity, Maven, Gradle, Nolio, Nexus, Artifactory, Chef2-3 years of experience with Database schema version control tooling, e.g. Flyway, LiquibaseNice to Have:--Excellent knowledge of a SQL scripting dialect, preferably Microsoft T-SQLStrong knowledge of an RDMS platform such as Microsoft SQL Server, Oracle, MariaDB, PostgresSQL, MySQLExperience with data integration platforms such as Microsoft SSIS, Informatica, Ab Initio, IBM MQEvidence of consuming and producing data feeds exposed via SFTP, web APIs, etcGood understanding of the full software development lifecycle, e.g. Waterfall, Agile, LEAN methodologiesGreat communication and problem-solving skills, and a good team player

Keywords: Emergent365 Inc (Formerly Blackstone Professional , New York , Data Warehouse Engineer - Informatica, ETL, SQL, Accounting, Auditing , Whippany, New York

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Accounting, Auditing Jobs


Remote Credentialed Tax Professional
Description: Overview 10 10 If you are a highly motivated individual with an active unrestricted credential CPA/EA/Practicing Attorney and excellent communication skills, we need you to help our customers complete (more...)
Company: Intuit
Location: Roslyn
Posted on: 09/24/2020

New York - Financial Restructuring (Mid-Senior Level Associate)
Description: Qualifications: Mid-Senior level associate with 3 years of financial restructuring experience. Candidates should have experience representing
Company: Milbank, Tweed, Hadley & McCloy LLP
Location: New York
Posted on: 09/24/2020

Operations Analyst
Description: About Cadence Cadence is the leading fintech securitization platform for private credit. We have developed a platform to streamline the securitization process for specialty finance originators at every (more...)
Company: Cadence
Location: New York
Posted on: 09/24/2020


NAM Head of Collateral & Client Valuations (CCV)
Description: We are seeking an outstanding candidate to be the NAM Head of Collateral Client Valuations CCV . br br Independent Price Verification IPV is a key function within Citi and the team is a vital (more...)
Company: Citi
Location: New York
Posted on: 09/24/2020

Senior Accountant
Description: Senior Accountant: Hold Brothers Capital, LLC, a leading-clearing proprietary broker-dealer, is seeking a Senior Accountant to join the team. This person will report into the CFO and assist on all financial-related (more...)
Company: Hold Brothers
Location: New York
Posted on: 09/24/2020

Group Insurance Business Segments Internship: Prudential
Description: 2021 Group Insurance Business Segments Internship: Prudential - Prudential Financial ga Cookie Value Careers-Job Search-Job DetailsJob Description - Prudential Financial Human Resources WT FPC Cookie (more...)
Company: Prudential Financial, Inc.
Location: Roseland
Posted on: 09/24/2020

AVP of Accounting & Finance
Description: Job Summary: Hold Brothers Capital, LLC, a leading self-clearing broker-dealer, is seeking a Mandarin speaking AVP for our Finance department. This individual will provide support to the CFO and the Finance (more...)
Company: Hold Brothers
Location: New York
Posted on: 09/24/2020

Glide Relaunch Internship
Description: Job Description Important Note During the application process, ensure your contact information email and phone number is up to date and upload your current resume when submitting your application for (more...)
Company: Wells Fargo
Location: New York
Posted on: 09/24/2020

Project Manager, USAID Contracts
Description: Sector:Grants Employment Category: Fixed Term Employment Type: Full-Time Open to Expatriates: No Job Description Job Overview/Summary: The Project Manager PM , USAID Contracts will play a vital role (more...)
Company: International Rescue Committee
Location: New York
Posted on: 09/24/2020

Quantitative Analytics Spec 4 Senior Front Office/Java Financial Engineer
Description: Job Description Important Note During the application process, ensure your contact information email and phone number is up to date and upload your current resume prior to submitting your application (more...)
Company: Wells Fargo
Location: New York
Posted on: 09/24/2020

Log In or Create An Account

Get the latest New York jobs by following @recnetNY on Twitter!

New York RSS job feeds