Systems Developer

Title: Systems Developer (OWB / ODI / Child Welfare Environment) Location: Albany, NY – onsite Duration: 24 Months Description: This position is for a Systems Developer working on an Oracle Data Warehouse/Business Intelligence team. • Work in coordination with a team of developers to expand the current Data Warehouse. • Design/model, construct, load, and validate the data tables through the enterprise Data Warehouse architecture. • Work with Business Analyst & customers on analysis and logical design for mappings and ETL. • Perform unit testing and correct all identified bugs. • Perform complex PL/SQL coding in a Data Warehouse environment. • Responsible for load issue resolutions, load inquiries, 2nd level testing of issues and code fixes, infrastructure upgrades and enhancements • Perform writing of complex stored procedures/triggers in an Oracle database utilizing OWB and ODI • The individual in this position will work under the direction of a Technical Lead & Project Manager. 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 building database schemas, tables, views, indexes, and stored procedures • Bachelor’s Degree. Thanks & Regards, Jennifer |Sr Technical Recruiter Minisoft Technologies LLC 832-301-9876| jennifer@minisofttech.com