DW/BI/IBM Datastage, MDM Lead

TecTammina; Cranston (RI); On-site; USD 90,000 - 110,000; Full time

Job summary

A leading technology company in Cranston, Rhode Island is seeking a full-time professional with extensive experience in IBM Datastage and Informatica MDM. The ideal candidate will have over 4 years of experience in ETL processes and data warehousing. They must possess strong analytical skills, and the ability to work in a collaborative environment. Eligible candidates include EAD GC, GC, or US Citizens. Share your profile to mkonni(at)1stitsolutions(dot)com.

Qualifications

• 4+ years of experience with IBM Datastage and IBM MDM tool.
• 2+ years of experience in DW/BI related technologies and tools.
• 2+ years of experience in Project life cycle activities for DW/BI projects.
• 2+ years of hands-on experience in design and architecture review.

Responsibilities

• Knowledge and use of IBM Datastage for ETL processes.
• Create Datastage sequences to run batch jobs.
• Understanding of data loading techniques and best practices.

Skills

IBM Datastage Architecture

ETL flow

advanced SQLs

data loading techniques

datastage tools

Unix/Linux system

shell scripting

Informatica MDM

analytical skills

Education

Bachelor’s degree or foreign equivalent

Tools

IBM Datastage

Informatica MDM

Job description

Knowledge of IBM Datastage Architecture, Stages/Transformations, Design, ETL flow, advanced SQLs and basic data modeling

Knowledge of data loading techniques using Datastage

Using Datastage Director for running and monitoring the jobs.

Created Datastage sequences to run the batch jobs.

Knowledge Best Practices in Datastage, Performance improvements, implementing CDC, UDFs

Understanding of Unix/Linux system, file systems, shell scripting

Strong in-depth technical knowledge of Informatica MDM.

Hands-on development mentality, with a willingness to troubleshoot and solve complex problems

Ability to work in team in diverse/ multiple stakeholder environment

Strong analytical skills

Experience and desire to work in a Global delivery environment

Qualifications

Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.

At least 4 years of experience with IBM Datastage and IBM MDM tool

At least 2 years of experience in DW/BI related technologies and tools - MUST

At least 2 years of experience in Project life cycle activities on DW/BI development and maintenance projects

At least 2 years of experience in Design and Architecture review

At least 2 years of hands on experience in Design, Development & Build activities in IBM Datastage ETL Projects

Additional Information

Job Status: Full Time

Eligibility: EAD GC or GC or US Citizen

Share the Profiles to mkonni(at)1stitsolutions(dot)com

Contact: 703 349 1214

Keep the subject line with Job Title and Location