IBM Datastage Developer Job at ACS Consultancy Services, Albany, NY

eHFTSys0SHVjWWJYd2g1S1kwNDF4ajlRdFE9PQ==
  • ACS Consultancy Services
  • Albany, NY

Job Description

Job Title: IBM Datastage Developer(US Citizen Only)

Location: Remote

We are currently seeking candidates who meet the following qualifications:

Responsibilities:

  • Design develop and optimize ETL jobs and workflows using IBM InfoSphere DataStage to extract transform and load data from diverse data sources into target systems.
  • Integrate and transform data from multiple sources (e.g. RDBMS flat files APIs) to ensure data quality consistency and availability for analytics and reporting.
  • Monitor troubleshoot and improve ETL performance by tuning DataStage jobs and resolving any data integration issues.
  • Work closely with data architects database administrators business analysts and other stakeholders to understand requirements and deliver efficient ETL solutions.
  • Implement data validation and reconciliation techniques to ensure the accuracy and consistency of data in target systems.
  • Prepare and maintain detailed documentation including ETL design specifications data mappings and operational support documents.
  • Provide support for ETL processes resolve production issues and ensure timely data delivery for business processes.
  • Ensure ETL processes comply with organizational standards and data security regulations.

Qualifications:

  • Proficiency in IBM InfoSphere DataStage including parallel job development and debugging.
  • Strong SQL skills for data manipulation and querying in relational databases like Oracle SQL Server or DB2.
  • Knowledge of scripting languages (e.g. Shell Python) for ETL automation.
  • Experience working with APIs JSON XML and other data interchange formats.
  • Strong understanding of data warehousing concepts dimensional modeling and ETL best practices.
  • Experience with data governance quality and security practices.
    Ability to troubleshoot ETL job failures identify root causes and implement robust solutions.
    Handson experience in handling large datasets data migration or modernization projects in cloud or onpremises environments.
  • Experience with cloud platforms (e.g. Azure AWS GCP) and cloudbased ETL tools.
  • Experience with Agile/Scrum development methodologies.
  • Knowledge of additional IBM tools like InfoSphere QualityStage or Data Governance.
  • Certification in IBM DataStage or related ETL/BI tools.
  • Federal Experience is a plus.
  • Required Security clearance.


    If you meet these qualifications please submit your application via link provided in Linkedin.
    Kindly do not call the general line to submit your application.

Job Tags

Remote job,

Similar Jobs

Rutland Regional Medical Center

Medical Assistant - Clinic Job at Rutland Regional Medical Center

Under the direction and supervision of practice providers or nursing staff, the Medical Assistant is responsible for clinical duties to prepare the patient for the encounter, assist the clinicians in the delivery of care, and maintains examination rooms, equipment, and...

Delaware Park Casino & Racing

Security Officer (FT/PT) Job at Delaware Park Casino & Racing

 ...exciting environment where the flawless delivery and execution of service excellence is paramount. Maintain a constant vigilance to...  ...Delaware Park Policy and Procedure. Responsible for enforcing security procedures at all assigned posts. Assists in the transfer of... 

Warren Henry Automotive Group

Parts Counter Representative - Jaguar Land Rover West Broward Job at Warren Henry Automotive Group

Our brand new Jaguar Land Rover West Broward store is coming soon! With another JLR store coming to the Warren Henry family, we can provide more options and better service to our customers. We are seeking a Parts Consultant (Front Counter) for the team...

Western Welding Academy

Sales Representative - Student Selection Job at Western Welding Academy

: ~ As a Sales Representative for Student Selection , you will play a vital role in identifying and recruiting prospective students...  ...encouragement throughout the enrollment process. Team Collaboration : Work closely with the Student Selection Team to ensure a seamless... 

PacifiCorp

SR. T&D Data Scientist, Portland, OR or Salt Lake City, UT #112797 Job at PacifiCorp

 ...SR. T&D Data Scientist, Portland, OR or Salt Lake City, UT #112797 Date: Nov 1, 2024 Location: PORTLAND, OR, US, 97232 Company: PacifiCorp JOIN OUR TEAM PacifiCorp is seeking customer-centric candidates to grow and sustain our commitment...