ETL / ODI Developer

ETL / ODI DEVELOPER

6+ MONTHS CONTRACT

GREATER BOSTON, MA

HYBRID (2-3 DAYS / WEEK)

VISA- NO CPT / H1B

CLIENT DOMAIN- IT

Looking for OAS experience, and preference given to people with Oracle cloud experience

Position Specifics

1. Experience with ODI 12C

2. Experience in Data warehousing

3. Strong Communication Skills

4. Work directly with users to gather requirements and create ETL solutions.

SUMMARY :

The ETL Developer provides expertise in data mapping from transactional application to data warehouse and creation of Extract, Transform and Load ( "ETL") software programs. The incumbent will be responsible for designing, developing, testing and documenting ETL programs. The incumbent will be responsible for creating and maintaining logical and physical data models using established enterprise tools and best practices. The incumbent is expected to have solid understanding of database design principles as well as database administration methods and techniques.

ESSENTIAL DUTIES :

• Develop and maintain ETL processes that meet project-specific business and technical requirements and those of the overall enterprise data warehouse data integration portfolio
• Document all processes and support source code control using standard tools and processes
• Perform transactional applications (source) to data warehouse (target) data mapping
• Maintain current knowledge of the technology industry, including leading tools and best practices
• Perform data integrity checks and data validations
• Assist with ensuring the integrity and performance of data structures
• Set standards for technical documentation