Hello,
Good Morning.
Hope you are doing well.
This is Mansoor from COOLSOFT Currently one of our Direct Clients has this below given job opportunity. If you are interested or know someone who is looking for projects, please apply by emailing the updated resume ASAP to mkhan@coolsofttech.com . You can call me @ 408-533-0000 Ext: 608 to discuss this opportunity or please forward your updated resume.
Coolsoft is a company with extensive Consulting experience in the Information Technology Industry. We bring 10 years of experience in providing IT talent to most of Government Clients and FORTUNE 1000 Companies across the nation.
Job Title: Oracle Data Integrator
Location: Boston, MA
Duration: 10 Months
Responsibilities:
• Design and implement ODI Extract, Load and Transform (ELT) processes, programs and scripts. Design of data warehouse tables, including source to target mappings, configuration of ODI knowledge modules…etc.
• Develop and document the ODI ELT process. Help in Creation and maintenance of the source to Client data mappings, ELT specifications and complex transformation rules and technical documentation.
• Strong development experience in ODI, Oracle SQL and PL/SQL. Must have the ability to write Stored Procedures, Functions, Packages. Support testing, deployment and ongoing support of data warehouse system.
• Knowledge of database indexing and tuning in Oracle Database. Ability to interpret requirements and technical specifications and translate them into visual representations of information.
• Assist in developing and publishing data management standards, policies and procedures, including the management and maintenance of related tools and environments. Collaborate with Oracle Database Administrators for the Warehouse database design, data model, storage, security, performance and data environment requirements.
• Perform maintenance and support of existing applications. Establish, Maintain and Adhere to ELT and Data Integration Standards.
• Participate in peer reviews on specifications, design and code. Validate the data in the database and also responsible for testing the routines developed. Work closely with QA and Operations to ensure smooth QA and deployment of applications. Work with project teams to plan integration and implementation strategies.
• Experience performing Unit, Functional, Regression, Integration and User Acceptance Testing (UAT).
• Should have a strong verbal and written skills
Required Skills:
• Minimum 8 plus years hands on experience in Knowledge of Data Warehousing such as dimensional modeling, Star and Snowflake schemas, Data mart and Fact, Dimension tables, Slowly Changing Dimensions -Type I & II & III.
• Person must have extensive knowledge of ODI with at least 5 years of experience using ODI and Oracle PL/SQL. In addition, candidate should have data migration experience. Experience in Oracle Warehouse builder is a plus.
• Must be fully proficient in writing scalable and high volume ELT jobs for large volume data warehouses.
• Must have a very good understanding of the ODI Architecture and setting up agents on Oracle WebLogic Server, Setting up Master and Work repositories.
• Must have a solid experience in creating Interfaces to move data from source to target schema. Must be experienced in creating and writing cleansing routines to work with ODI Interfaces while creating load plans.
• Experience in setting up Topology in complex environments is a must. Manage and monitor production ETL Manage and monitor non-production ETL sessions and ascertain success of steps or failures with root cause analysis.
• Understand & be able to tailor Knowledge Modules.
• Design and develop the architecture for all data warehousing components (e.g. source system data ELT strategy, data staging, movement and aggregation; information and analytics delivery; and data quality strategy)
• Setting up, debugging and implementing end-to-end ETL jobs. Do performance tuning of ODI ELT Mappings. Develop unit, system, and integration test plans
• Ability to analyze existing database schema DDL/Instance layout and make changes where required.
Thanks & Best Regards
Mansoor Ali Khan
Lead Recruiter
Contact: 408-533-0000 Ext: 608
Email: mkhan@coolsofttech.com
COOLSOFT
An Information Technology Company
For all open positions please check http://www.jobsinhand.com/
--Request: Please do not send any messages to this group which are nor related to IT staffing.
You received this message because you are subscribed to the Google
Groups "Technical Recruiters" group.
To post to this group, send email to
technical-recruiters@googlegroups.com
To unsubscribe from this group, send email to
technical-recruiters+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/technical-recruiters?hl=en?hl=en
0 comments:
Post a Comment