This site uses cookies. To find out more, see our Cookies Policy

ETL/MDM Developer in New York, NY at Eliassen Group

Date Posted: 5/29/2019

Job Snapshot

  • Employee Type:
  • Location:
    New York, NY
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:

Job Description

Our Client 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. 

Roles & responsibilities may include: 
  • Integrate data from a variety of data sources (Data warehouse, Data marts) utilizing on-premises or cloud-based data structures; 
  • Develop and implement streaming, data lake, and analytics big data solutions 
  • Create Applications using Change Data Capture Tools 
  • Application Performance and System Testing Analyst 
  • Responsible for configuration identification & control, and build management of all components of MDM development life cycle. Manage Data & Code configuration across MDM Prod/Non-Prod Ecosystem 
  • Implement Master data management standards, enforce data governance procedures and ensure data integrity across multiple platforms 
  • Design, develop, deploy and support end to end ETL specifications based on business requirements and processes such as source-to-target data mappings, integration workflows, and load processes using IBM Datastage 
  • Developing ETL jobs using various stages such as Sequential, Dataset, Transformer, Copy, Lookup, filter, Join, Merge, Funnel, Sort, Remove Duplicates, Modify and Aggregator etc. 
  • Involve in day to day support and providing solutions/troubleshooting Production Outages/Issues using Datastage tool for business requirements, enhancements and handling service requests 

Experience, knowledge, skills or abilities: 
  • 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.) 
  • Python, Spark and AWS experience is a big plus.

Keywords: ETL, MDM, Data Warehouse, Developer, App Developer, Python, AWS, Oracle, SQL, Data Acquisition

Job ID: 319636

About Eliassen Group:

Eliassen Group provides strategic talent solutions to drive our clients’ innovation and business results. Leveraging over 30 years of success, our expertise in IT staffing, Agile consulting, creative services, managed services, and life sciences enables us to partner with our clients to execute their business strategy and scale effectively. Headquartered in Reading, MA and with offices from coast to coast, Eliassen Group offers local community presence, deep networks, as well as national reach. For more information, visit

Eliassen Group is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

Don’t miss out on our referral program! If we hire a candidate that you refer us to then you can be eligible for a $1,000 referral check!