Market $$$ - Per Hour w2
Lower Manhatten (NOHO)
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 firstname.lastname@example.org 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