ETL/MDM Developer - job id 33330

Your Way To Work™

ETL/MDM Developer

Market $$$ - Per Hour w2

Lower Manhatten (NOHO)

How to Apply


Jessica Ohmer


(646) 876-9549


(212) 616-4800 ext-570

A Contract position at Premier New York Education Institution.

Pay Options: w2

Contact Jessica Ohmer call (646)876-9549 / (212)616-4800 ext.570 or email with the Job Code JO33330

Location: Lower Manhatten (NOHO).

Skills required for the position: ETL, MDM, DATA STAGE, DATA WAREHOUSING.

Optional (not required):AWS

Detailed Info: Washington Square has a truly unique opportunity for ETL Developer for MDM project. As part of this team, you will work on the collecting, storing, processing, and analyzing huge sets of data. The primary focus will be to develop the construction and maintenance of our data pipeline, ETL processes and data warehouse. ETL Developer will also be responsible for data quality and understanding the data needs our various source data in order to anticipate and scale our systems.

Candidate must be willing to learn, work well independently, be open to feedback, and enthusiastic, with demonstrated technical aptitude, skills and abilities

Current technology includes (but is not limited to):

ETL - Datastage, Unix Scripting, SQL, PL/SQL, Oracle Change Data Capture (CDC) Data Ingestion to preparation to exploration and consumption using Cloud & Big Data Platform Dimensional and Relation table structures AWS cloud (S3, EC2, EMR, Redshift, etc.) Knowledge of Databricks, Snowflake, Attunity, Airflow Must have good understanding of Master Data Management (MDM) architectures, business processes and various MDM domains like Customer, Product and Organization Must have hands-on experience with MDM solution development - Data modelling, Data Integration, Data validation, Match and Merge rules and Data stewardship Knowledge of Web Services, XML, SOAP, REST, integration middleware such as Mulesoft

Development/Computing Environment: Minimum of 5-7 years of IT work experience focused in Data Acquisition and Data Integration using DataStage

Minimum 4-6 years of experience with ORACLE SQL and PL/SQL Package

Experience working with flat files and XML transformations

Prior experience in data warehouse design and modeling. Data Vault 2.0 / dimensional modeling preferred

Analyzing the statistics of the DataStage jobs in director and conducting performance tuning to reduce the time required to load the tables and the loads on computing nodes involved.

Technical experience in IBM MDM InfoSphere and WebSphere platforms

Programming capability in a high-level programming language such as Python, Java or other language related to automating deployment, configuration and system monitoring

Hands-on experience designing and developing MDM solutions leveraging DataStage or Talend or Reltio or Orchestra Networks

Knowledge/Experience on Data Warehousing applications, directly responsible for the Extraction, Staging, Transformation, Pre Loading and Loading of data from multiple sources into Data Warehouse

Application development, including Cloud development experience, preferably using AWS (AWS Services, especially S3, API Gateway, Redshift, Lambda, etc.)


The position offers competitive rate.

Job Id: 33330