Senior DataStage ETL Developer

Location: NYC, NY
Date Posted: 11-20-2018
!!! Only US Citizen or Green Card holders, Please !!!

We are looking for a Senior DataStage ETL Developer with technical expertise for the completion of Data Quality, Profiling, Cleansing and Migration efforts as well as ongoing process improvement programs.
 
Responsibilities
  • Analyze business requirements and design applications.
  • Work with data SME’s to modify applications improving the existing business processes.
  • Actively participate in optimization and performance tuning of existing ETL and SQL processes.
  • Transform technical specifications into ETL processes to load the data for cleansing prior to the migration.
  • Provide business units with ad-hoc deep-dive analytical reports in support of business rules parsing effort.
  • Collaborate with technical leads in identifying and addressing production issues and data quality gaps.
  • Support processes that proactively detect, correct, and prevent invalid data values.
 
Required skills
  • Minimum of five (5) years of recent experience developing applications using IBM DataStage ETL.
  • Deep knowledge of DataStage Engine administration.
  • Extensive experience with IBM DataStage Designer and Director.
  • Experience migrating mainframe VSAM data to relational and/or multidimensional SQL databases.
  • Experience with Legacy and Unstructured data.
  • Experience working in multiple development environments/systems: IBM Mainframe, Windows Server, UNIX and SQL Server.
  • Strong SQL knowledge working with complex queries and stored procedures.
  • Proficiency in mainframe applications encompassing JCL, COBOL, VSAM and DB2.
  • Excellent interpersonal, communication, presentation, writing, analytical, problem solving, and information gathering skills along with fundamental technique troubleshooting abilities.
  • Strong analytical skills demonstrated by the ability to receive and analyze requirements and propose a suitable solution that adheres to the team’s methodology.
 
Preferred Experience:
  • Experience with IBM Information Analyzer and IBM WebSphere.
  • Experience extracting business rules from the existing legacy code.
  • Experience with IBM Rational Asset Analyzer.
  • Experience with MS Visual Studio and .NET.
  • Experience developing applications in IBM VSE mainframe environment
 

 
If you are interested in getting more information about this opportunity, please contact Irina Rozenberg irozenberg@arielpartners.com  at your earliest convenience.

At Ariel Partners, we solve the most difficult problems that inhibit technology from enabling our customers to achieve their goals. Our vision is to be recognized by our stakeholders as an elite provider of IT solutions, so when they have their biggest challenges we’re on their short list. We’re looking for team members who share our values of: Integrity to do the right thing even when it hurts; Commitment to the long-term success and happiness of our customers, our people, and our partners; Courage to take on difficult challenges, accept new ideas, and accept incremental failure; and the constant pursuit of Excellence
 
 
Ariel Partners is an Equal Opportunity Employer in accordance with federal, state, and local laws.
 
or
this job portal is powered by CATS