Location
Secunderabad | India
Job description
Role: ODI & SQL Developer
Experience: 1 to 3 Years
Location: Hyderabad
Technovertis not your typical IT services firm. We have to credit two of our successful products generating $8M+ in licensing/SaaS revenues which is rare in the industry.
We are Obsessed with our love for technology and the infinite possibilities it can create for making this world a better place. Our clients find us at our best when we are challenged with their toughest of problems and we love chasing the problems. It thrills us and motivates us to deliver more. Our global delivery model has earned the trust and reputation of being a partner of choice.
We have a strong heritage built on great people who put customers first and deliver exceptional results with no surprises - every time. We partner with you to understand the interconnection of user experience, business goals, and information technology. It's the optimal fusing of these three drivers that deliver.
Must have:
- Experience with data warehouse (DWH) implementation which involves developing source-to-staging area, staging-to-target area, data transformations, EL-T process flows, ETL control tables, error logging, auditing, data quality, etc.
- Adept in DWH concepts
- Expertise in any ETL/ELT tools like Oracle Data Integrator, Informatica, etc.,
- Excellent SQL skills and awareness to PL/SQL skills in Oracle databases
- Created load plans, Scheduling Jobs for various purposes
- Excellent analytical skills to debug data load issues and fix data anomalies
- Maintenance and Monitoring of the infrastructure, simultaneously working with DBAs to keep the environments up & running all the time
- Experience in migration of ELT/ETL code into different environments following best practices
- Ability to carry out ETL unit test cases and DQ test cases
Nice to have:
- Exposure towards Oracle Cloud Infrastructure (OCI) is preferable
- Experience of ODI 12c or marketplace instances would be an added advantage
- Experience in using various knowledge modules in ODI
- Exposure to OAC with capability to build reports in OAC
- Good understanding of Oracle Fusion
Qualification:
- Graduate
- At least (1.5-2)+ years ofexperience in Oracle Data Integrator (ODI), OBIEE/OAC and Oracle Data Integrator Cloud Service (ODICS).
- Must be self-motivated and should have strong attention to detail and accuracy with ability to fill multiple roles within a project
Job tags
Salary