ETL Data Warehouse Developer
- Full Time, onsite
- Bits & Bytes Technology Solutions
- Hybrid2-3 days remote every week, United States of America
Apply on
ETL Data Warehouse Developer
Duration: 24 months
Location: Albany, NY (2-3 days remote every week)
Client: State of New York
Note: Candidates must share 3 references and a copy of their Visa and Passport for submission.
Job Description:
1. | 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. |
2. | 84 months experience Data Modeling (Dimensional & Relational), process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation in a child welfare environment |
3. | 84 months experience working in an Oracle Data Warehouse performing development work using PL/SQL |
4. | 84 months experience using advanced Extract/Transform/Load techniques including bulk select, bulk insert, arrays, dynamic SQL and developing detailed incremental ETL processes. |
5. | 84 months experience developing and testing maps, performing source-to-target mappings, storage capacity planning and developing ETL in Oracle Data Integrator (ODI) |
6. | 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). |
7. | 84 months experience working in UNIX or LINUX environment developing Unix Shell Scripting and sftp protocols |
8. | 84 months experience in build database schemas, tables, views, indexes, and stored procedures |
9. | Bachelor s Degree |