MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious
6

Data Warehouse Developer

Location Rensselaer, United States
Posted 27-October-2021
Description


TECH VALLEY TALENT (TVT) IS YOUR LOCAL SMALL BUSINESS LEADER IN PROVIDING IT SERVICES TO THE PUBLIC SECTOR. TVT IS A CERTIFIED WOMAN-OWNED BUSINESS WITH NUMEROUS IT POSITIONS AVAILABLE AND WE ARE SEEKING IT TECHNOLOGISTS TO ADD TO OUR GROWING PRACTICE AREAS AS WELL AS INDIVIDUAL CONTRACT OPPORTUNITIES.

TVT is a NYS HBITS Prime Vendor!

We have a 24-month project with our client in Rensselaer, NY that requires an Expert Systems Developer.

This 24-month position for a Systems Developer with experience working on a Oracle Data Warehouse/Business Intelligence team is needed to work on the data collection requirements for state and federal reporting on the Family First Prevention Services Act (FFPSA) Act. The bill aims to prevent children from entering foster care by allowing federal reimbursement for mental health services, substance use treatment, and in-home parenting skill training. It also seeks to improve the well-being of children already in foster by providing an incentive to states to reduce placement of children in congregate care.

The developer will design/model, construct, load, and validate the data tables through the enterprise Data Warehouse architecture.

In addition, this resource will share responsibilities for managing the Data Warehouse daily processing operations and job schedules, load issue resolutions, load inquiries, 2nd level testing of issues and code fixes, infrastructure upgrades and enhancements.

Day-to-Day Tasks include, but not limited to:



Work in coordination with a team of developers to expand the current Data Warehouse.
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.
Respond to Family First data requests.
The individual in this position will work under the direction of a Technical Lead & Project Manager.
Perform writing of complex stored procedures/triggers in an Oracle database utilizing OWB and ODI.

Mandatory Qualifications:



Develops and implements applications and programs for the backend processing systems used in businesses and organizations.
84+ Months-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.

Preferred Qualifications:



60 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.
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.
Bachelors Degree.

TVT IS AN INFORMATION TECHNOLOGY (IT) PROFESSIONAL SERVICES FIRM LOCATED IN UPSTATE NYS SARATOGA COUNTY. WE ARE FOUNDED ON THE VALUES OF HIGH INTEGRITY, TRUST, HONESTY, AND COMMITMENT AND PRIDE OURSELVES ON PROVIDING EXCEPTIONAL VALUE TO OUR CLIENTS BY SUPPLYING AND DELIVERING THE BEST IT PROJECT-BASED AND HOURLY TALENT ACROSS THE NATION. TVTS FOUNDER AND PRESIDENT HAS WORKED IN THE IT CONSULTING INDUSTRY FOR OVER 25 YEARS AND OUR CORPORATE LEADERS HAVE HELD LONG-STANDING, C-LEVEL ROLES WITHIN LARGE FORTUNE 500 OR PUBLIC SECTOR ORGANIZATIONS BEFORE JOINING TVT. WE ARE THE ONLY SMALL IT PROFESSIONAL SERVICES FIRM IN THE CAPITAL DISTRICT AREA SUPPORTED BY AN INTERNAL PMO. IN ADDITION, TVT SUPPORTS MANY ENTERPRISE-WIDE CLIENTS (SUCH AS IBM), VARIOUS SYSTEM INTEGRATORS, AND MULTIPLE STATE GOVERNMENTS (INCLUDING EXTENSIVE IT SERVICES WORK FOR NYS) AND WE ARE BUSINESS PARTNERS WITH MANY TECHNOLOGY SOLUTION PROVIDERS SUCH AS IBM, AWS, GOOGLE, MICROSOFT, ORACLE, TABLEAU, SALESFORCE, AND OTHERS.

TECH VALLEY TALENT PROVIDES EQUAL EMPLOYMENT OPPORTUNITIES TO ALL EMPLOYEES AND APPLICANTS FOR EMPLOYMENT AND PROHIBITS DISCRIMINATION AND HARASSMENT OF ANY TYPE PROTECTED BY FEDERAL, STATE, OR LOCAL LAWS. THIS POLICY APPLIES TO ALL TERMS AND CONDITIONS OF EMPLOYMENT.

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url