Greetings from Sligo Software Solutions, Inc. !! This is Dasharatham from SLIGO. We have an urgent requirement for Sr. ETL Datastage Developer position with our client. Title : Sr. ETL Datastage Developer Location : Albany, New York Duration : 30 Months Client : NY State - NYS Department of Labor Job ID: SLG - 19 - 10747 Respond by: 06/17/25 5:00 PM Description This position will document existing legacy DW System processes and assist in the transition of legacy processes to the NYS Data Warehouse System. Duties • Ensuring application documentation is complete, organized, accessible, and follows office standards. • Writing, testing, debugging new and existing code based on program area knowledge, conceptual and technical design specifications. • Write and test procedures, parameters and other specifications required to implement programs. • Develop or assist with the development of unit, component and program test plans. • Implement program changes and provides user support as required. • Data Warehouse design, development, support and data mining related to new and existing complex Extract, Transform, Load (ETL) routines related to Fraud Detection/Improper Payment algorithms; • Develop, test and implement program logic for data mining and ETL development; • Implement ETL technical specifications from development through test, staging and production environments; • Optimize ETL data load jobs to improve performance and automate; • Investigating and resolving data loading and/or data integrity issues; • Create solutions to improve system performance and availability Mandatory Requirements • Experience (12+ Years) • Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer. Requirements • This is an 100% Onsite • 84 Months Experience developing and testing query solutions using Oracle PL/SQL query. • 84 Months UNIX Shell Scripting experience • 84 Months ETL design/Data Warehouse development experience using SQL and PL/SQL programming/ IBM DataStage • 84 Months Experience tuning SQL within an Oracle environment to ensure timely and efficient execution of queries • 72 Months ETL development experience in Oracle environment with IBM DataStage • 84 Months DataStage Administrator experience on AIX environments that includes implementing and maintaining business and technical rules; automating ETL code migration process and standards for Stop/start services; monitor logs; setting up security; assigning roles; project permissions; Create/Delete projects; create/modify environmental parameters; Platform Issue resolution; troubleshooting and root cause analysis; Configuration and tuning of production and lower-level environments; and capacity planning. • 60 months experience in program and unit testing. • 60 months experience working with PPI and SSA data security requirements (working with data contained in Employee Records in a State Agency, Federal Agency or Private Organization) for production system error diagnosis, debugging, and code modification • 60 months experience in program code documentation, mentoring and assisting other developers. • Bachelor's Degree or Higher • Résumé • Copy of Candidate Identification (i.e., Driver’s License/Green Card/Visa and Passport if applicable) • Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.) Thank you, Katta Dasharatham Recruiting Team Lead Sligo Software Solutions Inc. dasharatham.katta@sligosoft.com www.sligosoft.com Direct: (518) 818-6239 Office: (518) 444 0459 x 116 Fax : (518) 444 0457 https://www.linkedin.com/in/dasharatham/ • Due to my back-to-back calls, there are times when I might miss your calls. Email is the best way to reach me • •