Data Warehouse Developer
Data Warehouse Developer
Posted on :
15-02-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Monthly Salary
Not Disclosed
Salary Not Disclosed
Vacancy
1 Vacancy
Posted on :
15-02-2025
Job Description
For more details please connect with Brij Kishore atExt 329 or email me at
Client: State of New York
Job Title: Data Warehouse Developer
Duration: 24 Months
Start Date: ASAP
Location: Albany NY 12210 (Hybrid)
Position Type: Contract
Interview Type: In Person/ Web Cam
Working Hours: 40 Hours per Week
Job Title: Data Warehouse Developer
Duration: 24 Months
Start Date: ASAP
Location: Albany NY 12210 (Hybrid)
Position Type: Contract
Interview Type: In Person/ Web Cam
Working Hours: 40 Hours per Week
Short Description:
This 24month position for a Systems Developer with experience working on an Oracle Data Warehouse/Business Intelligence team is needed to work on the fiscal and child welfare component of the OCFS Data Warehouse. The OCFS Data Warehouse supports various mandated Child Welfare federal reporting including: Adoption and Foster Care Analysis and Reporting System (AFACRS); and IVE reporting. This resource will work on AFCARS 2.0 redesign and modifications to the IVE and Fiscal data marts.
This 24month position for a Systems Developer with experience working on an Oracle Data Warehouse/Business Intelligence team is needed to work on the fiscal and child welfare component of the OCFS Data Warehouse. The OCFS Data Warehouse supports various mandated Child Welfare federal reporting including: Adoption and Foster Care Analysis and Reporting System (AFACRS); and IVE reporting. This resource will work on AFCARS 2.0 redesign and modifications to the IVE and Fiscal data marts.
Responsibilities:
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.
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.
Required Skills:
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/denormalization 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 sourcetotarget 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
V Group Inc. is an IT Services company that supplies IT staffing project management and delivery services in software network help desk and all IT areas. Our primary focus is the public sector including state and federal contracts. We have multiple awards/ contracts with the following states: CA FL GA MD MI NC NY OH OR PA SC VA and WA CT TN. If you are considering applying for a position with V Group or partnering with us on a position please feel free to contact me with any questions you may have regarding our services and the advantages we can offer you as a consultant.
Please share my contact information with others working in Information Technology.
Website:
LinkedIn:
Facebook:
Twitter:
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/denormalization 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 sourcetotarget 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
V Group Inc. is an IT Services company that supplies IT staffing project management and delivery services in software network help desk and all IT areas. Our primary focus is the public sector including state and federal contracts. We have multiple awards/ contracts with the following states: CA FL GA MD MI NC NY OH OR PA SC VA and WA CT TN. If you are considering applying for a position with V Group or partnering with us on a position please feel free to contact me with any questions you may have regarding our services and the advantages we can offer you as a consultant.
Please share my contact information with others working in Information Technology.
Website:
LinkedIn:
Facebook:
Twitter:
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
