Infotech Spectrum Inc, ยท 3 hours ago
Oracle ODI/OAC Consultant (W2 or 1099 only)
New York, NY
Contract
Remote
Senior Level
5+ years exp
Maximize your interview chancesE-LearningInformation Technology
Insider Connection @Infotech Spectrum Inc,
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
Lead the design & development, and management of end-to-end ETL processes using Oracle Data Integrator (ODI).
Develop and implement BI solutions using Oracle Analytics Cloud (OAC), including dashboards, reports, and data visualizations.
Optimize ETL workflows and BI solutions to enhance performance and scalability.
Collaborate with stakeholders to understand their business needs and develop solutions that meet those needs.
Identify and resolve complex ETL and BI issues in a timely manner.
Create and maintain comprehensive documentation for ETL processes, BI solutions, and best practices.
Provide technical guidance and mentorship to team members
Provide on-call support of Data Integration Batch processes on a rotating basis and other on-call as required.
Lead and oversee technical teams to ensure timely delivery of high-quality solutions.
Must be proficient in understanding and triaging complex software issues.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Lead the design & development, and management of end-to-end ETL processes using Oracle Data Integrator (ODI).
Develop and implement BI solutions using Oracle Analytics Cloud (OAC), including dashboards, reports, and data visualizations.
Optimize ETL workflows and BI solutions to enhance performance and scalability.
Collaborate with stakeholders to understand their business needs and develop solutions that meet those needs.
Identify and resolve complex ETL and BI issues in a timely manner.
Create and maintain comprehensive documentation for ETL processes, BI solutions, and best practices.
Provide technical guidance and mentorship to team members.
Provide on-call support of Data Integration Batch processes on a rotating basis and other on-call as required.
Lead and oversee technical teams to ensure timely delivery of high-quality solutions.
Must be proficient in understanding and triaging complex software issues.
Must have 3+ years of experience in developing and implementing BI solutions using Oracle Analytics Cloud (OAC), including dashboards, reports, and data visualizations.
Must have ability to multitask under pressure handling various deadlines.
Must have at least 5 years of advanced skills in SQL & PL/SQL and data querying (including writing advanced select statements, stored procedures, and functions) experience.
Must have at least 5 years of experience building scalable and reliable ETL to pull large and complex data together from different systems using Oracle Data Integrator.
Must have basic knowledge of REST APIs and able to test using POSTMAN.
Must have hands on experience in Data Model design and development and optimizing the performance of data warehouse.
Must have knowledge of cloud computing principles, including SaaS, PaaS and knowledge of working on a Cloud based database platform like ADW.
Must have strong aptitude to isolate problems, addressing immediate needs, analyzing.
Company
Infotech Spectrum Inc,
Infotech Spectrum delivers comprehensive fully integrated creative IT solutions ranging from IT consulting services to advanced technology deployment and product development.
51-200 employees
H1B Sponsorship
Infotech Spectrum Inc, has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (16)
2022 (16)
2021 (9)
2020 (14)
Funding
Current Stage
Growth StageCompany data provided by crunchbase
