IBM DataStage ETL Developer
Trenton, NJ - USA
Job Summary
Position Type: Hybrid
Hybrid Schedule: 3 days onsite 2 days remote
Contract Length: 12 months
Position Overview:
We are looking for anIBM DataStage ETLDeveloperto support the optimization project of our clients Cost Allocation Recovery System and other background systems. This position will be full-time and hybrid (3-days onsite) in Trenton NJ.
Duties:
Support existing and new development underIBM DataStage ETLver11 using flat file (CSV)MS SQL ServerExcel andOracledata for OITs CAR billing system
Intake usage billing data from about 20 different internal service provider sources and transform it into a common billing application running underOracle
Maintain existing billing processes using DataStage ETL for 34 billed services and develop new ETL processes for IBM mainframe billing replacing existing legacyCOBOLprocessing
Developerror reportingprocessing out of DataStage for business users to correct errors
Improve existing DataStage processes where production anomalies exist and enhance pain-points where possible
Required Skills:
5 years or more experience and knowledge of IBM DataStage v11 ETL processes including:DataStage development lifecycle: code test verify deploy and handling inputs inCSVfile SQL ServerOracle orExcel; outputs inOracle
5 years or more experience and knowledge ofOracle SQL including: extensive knowledge of SQL functions triggers and stored procedures and the ability to research processing errors debug and implement corrective actions
Strongdata analysisand problem-solving skills
Ability to work independently
Excellentcommunication skillsfor collaboration with co-developers supervisors and client business users
Preferred Skills:
Basic knowledge ofTOAD(database utility)
Required Experience:
Senior IC
About Company
Careers at LingaTech: Love Where You Work! Welcome to the vibrant world of LingaTech, where technology meets fun and innovation! Are you ready to join the adventure? As a premier employer of top-notch technology consultants, we're on a mission to assemble the most talented and passion ... View more