Job Description:
Trigyn's direct government client has an immediate need for a Systems Developer / Data Modeler in Albany, NY.
Description:
This position is for a systems developer with experience working on a Oracle Data Warehouse/Business Intelligence team. The developer will design/model, construct, load and validate the tables through the enterprise Data Warehouse architecture.
This dedicated resource would:
• Ongoing requests to add new tables, columns to the ODS
• Coding and configuration for initial set up of New Agencies
• Ownership logic needs to be applied for New Agencies ODS Maintenance Activities:
• Responding to missing files questions
• Responding to missing data questions
• Technical issues
• Database and network issues.
Mandatory Qualification:
• Develops and implements applications and programs for the backend processing systems used in businesses and organizations.
• Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
• 84 months experience in reverse engineering Oracle Warehouse Builder (OWB) ETL processes and developing new replacement Oracle Data Integrator (ODI) processes while maintaining consistent functionality.
• 84 months experience Data Modeling (Dimensional & Relational), process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation in a child welfare environment
• 84 months experience working in an Oracle Data Warehouse performing development work using PL/SQL
• 84 months experience using advanced Extract/Transform/Load techniques including bulk select, bulk insert, arrays, dynamic SQL and developing detailed incremental ETL processes.
• 84 months experience developing and testing maps, performing source-to-target mappings, storage capacity planning and developing ETL in Oracle Data Integrator (ODI)
• 84 months experience in SDLC including: requirement gathering, development, testing, debugging, deployment, documentation and production support, load issue resolutions, load inquiries, 2nd level testing of issues and code fixes, infrastructure upgrades and enhancements (Oracle upgrades).
• 84 months experience working in UNIX or LINUX environment developing Unix Shell Scripting and sftp protocols
• 84 months experience in build database schemas, tables, views, indexes, and stored procedures
• Bachelor’s Degree.
For Immediate Response call 732-876-7635, or send your resume to RecruiterVS@Trigyn.com
TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 9001:2015, , ISO 27001:2013 (ISMS),ISO 20000:2018 and CMMI Level 5 certified company.