Search Job

Search

Call Us Now

+1 908 222 8055

Job Detail

Senior ETL Developer

Experience Level

2 years Year(s)

Location

Woodcliff Lake, NJ

Posted Date

03/20/2018

Job Requirements

Job Requirements:

We have a long-term contract position for an experienced SQL Server developer. In this role, candidate will Support the use of Data & Analytics Tools for data extraction, data processing, audit analytics and business reports.

·         2+ years of post-qualification experience in data analytics, with a background and strong affinity in ETL processes, especially handling (large) data files, interpreting these data files (format, data types) and understanding data transformations to make the data fit the Data Analysis tools through which these get processed.

·         Database management knowledge focusing on Microsoft SQL Server technology including writing and understanding SQL stored procedures and data modeling which is documented by a degree in Computer Science or related majors and/or practical field work in extensive data analytics projects.

·         Experience with SQL, ACL, IDEA, Alteryx or similar tools.

·         Experience with SSIS, VBA and Microsoft Excel macros.

·         Knowledge of ERP systems (SAP, Oracle, JD Edwards, PeopleSoft, Microsoft Dynamics, etc.) is a strong advantage.

·         Knowledge of financial accounting and/or business processes (e.g. finance-to-report, order-to-cash, purchase-to-pay) is a strong advantage.

·         Experience working directly with global IT and business personnel is a plus.

·         Proven technical project management skills and ability to handle stakeholder relationships in a shared services organization.

·         Strong project management skills with experience in organizing, prioritizing, planning, and executing support efforts.

·         Strong written and verbal communication skills with the ability to interact with various levels in an organization.               

 

 

 

 

 

 

Job Duties:

 

·         Responsible to work on enhancements of client’s two of the core applications and is widely in production across 120 countries for 50+ Audit routines.

·         Responsible for analyzing, researching and resolving technical piece of the application for various domains as a Tier 3 support and enhancement group.

·         Constantly involved in many small projects as a POC or other R&D efforts to enhance client’s application for General Ledger Audit line of business all over the world. 

·         The process flow is governed using Agile and KANBAN methodologies, where candidate need to work on concurrent projects with different length of deliveries besides being the application support team member for many countries.

·         Responsible to work on the following technologies to troubleshoot and enhance the applications on both backend intelligent automated procedures and the front end functionalities: SQL Server 2014 – Analysis DB processing (1000s of stored procedures that are written dynamically); SSIS Integration Services – Extract Transform Load (ETL) – Dtsx packages are called implicitly as and when the application front end actions from users interact with the backend processing with respect to ETL. SSAS Server – CUBE processing is the final stage of processing for every engagement that is being processed by the user, where the final report and analytical dashboards get created.

·         Besides these core MSBI stack, candidate need to also work on Power BI, Advanced Excel, IDEA and also data extractions from other ERP system environments like SAP BW/BI and Oracle ERP systems.

Work with Global/Regional/Local IT teams to help them configure implementations, plan functional and performance testing as well as facilitate the transition of systems through delivery into formal support processes

Quick Contact

* Name :
*Email ID :
*Phone:
* Message :