The Role
Design, develop and maintain batch and real-time integrations using ODI 11g. Customize knowledge modules, build interfaces, packages, load plans, and agents. Perform topology configuration, CDC/journalizing, dimensional modelling, high-volume performance tuning, and write complex PL/SQL for data warehouse and ETL environments.
Summary Generated by Built In
Company Description
SonSoft is an IT Staffing and consulting firm and duly organized under the laws of the Commonwealth of Georgia. We are growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.
Job Description- Oracle Data Integrator (ODI) consultant with overall experience of 4 years and 3+ years of relevant experience in the implementation of Batch/Real-time Integrations using ODI 11g.
- Ability to customize knowledge modules as per the requirement.
- Should have strong design and development skills.
- Ability to design and develop Interfaces, Packages, Load plans, user functions, variables and sequences in ODI.
- Understanding of ODI/ODQ administration, maintenance and configuration skills.
- Experience working with multiple source/target systems such as Oracle, MS SQL Server, XML files, flat files, MS access/excel documents..
- Exposure to OLAP, OLTP, Data warehouse, Data mart development, Fact and Dimensional DB designs..
- Should have experience in developing dimensions and fact tables using ODI.
- Experience in high data volume environments/ performance tuning in ODI.
- Good to have exposure on ODI Administration and Load Balancing.
- Should be able to configure topology for all the technologies.
- Should be able to configure Standalone and Java EE agents.
- Exposure to CDC / Journalizing implementations and customizing knowledge modules.
- Experience in Modelling (logical and Physical) Warehouse and Marts Strong database design, relational and dimensional data modelling.
- Experience in writing complex queries, Stored Procedures in PL/SQL.
- Experience with UNIX Operating System, Windows Systems.
- Experience on ODI version 12c would be an added advantage
- Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
- At least 4 years of experience within the Information Technologies.
** U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.
Note:-
- This is a Full-Time Permanent job opportunity for you.
- Only US Citizen, Green Card Holder, GC-EAD, H4-EAD & L2-EAD can apply.
- No OPT-EAD, TN Visa & H1B Consultants please.
- Please mention your Visa Status in your email or resume.
Skills Required
- Overall 4 years experience with at least 3+ years implementing batch/real-time integrations using ODI 11g.
- Ability to customize and develop ODI knowledge modules.
- Strong design and development skills for ETL and data integration.
- Design and develop Interfaces, Packages, Load plans, user functions, variables and sequences in ODI.
- Understanding of ODI/ODQ administration, maintenance and configuration.
- Experience with source/target systems: Oracle, MS SQL Server, XML files, flat files, MS Access/Excel.
- Exposure to OLAP, OLTP, data warehouse and data mart development, fact and dimensional DB designs.
- Experience developing dimensions and fact tables using ODI.
- Experience in high data volume environments and performance tuning in ODI.
- Exposure to ODI administration and load balancing.
- Ability to configure topology for all technologies and configure Standalone and Java EE agents.
- Exposure to CDC / journalizing implementations and customizing knowledge modules.
- Experience in logical and physical modelling of warehouses and marts; strong relational and dimensional data modelling.
- Experience writing complex queries and stored procedures in PL/SQL.
- Experience with UNIX and Windows operating systems.
- Experience with ODI 12c (added advantage).
- Bachelor's degree or equivalent (or progressive experience in lieu).
- At least 4 years of experience within Information Technologies.
- Must be U.S. citizen, Green Card holder, GC-EAD, H4-EAD, or L2-EAD; employer cannot sponsor visas.
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
SonSoft Inc. is a global consulting and IT services firm specializing in software development, software consultancy, and Information Technology Enabled Services (ITES). The company provides a range of expertise including business consulting, systems integration, application development, and product engineering, helping clients re-engineer and re-invent their businesses to compete in a changing marketplace.
