Oracle Developer
Work Location Lincolnshire, IL
Duration 12 months
Mandatory Technical / Functional Skills
• 8+ years of experience in the field of Oracle PL/SQL Development
• 5+ years of experience in Data Warehousing
• Advanced SQL coding skills
• Solid understanding of Data Modeling concepts
• Technical team management experience including offshore team members
• Excellent personal communication, leadership, and organizational skills
• Retail related data warehousing experience a plus
• Hands on Performance tuning (Table partition, hints,indexes)
• Hands on experience on SQL Loader.
• Experience on cron job monitoring
• Strong UNIX command and UNIX Shell scripting experience
• 4+Experience on ETL (Extract, Transform and Load) concepts is mandatory
"
Roles and responsibility " Guide onshore and offshore Oracle Developers to ensure standards are met
Work with the application development teams throughout the development life cycle
Lead or participate in Proof-of-Concept projects
Stay current with emerging industry trends
Ability to take initiative and ownership on tasks
Create Detail design document based on the business requirement
Ability to monitor batch jobs.
Good written and oral communication
Explain complex design items through documents and white-board sessions
SQL knowledge and performance tuning experience needed"
Desirable Technical / Functional Skills "Work with different teams – Business, Solutions – BI,DW team to create overall user interface, Implement solutions with complete considerations on Infrastructure capability, performance, supportability to achieve end user business results.
Total experience in required skill (years) ~8 years
Work Location Lincolnshire, IL
Duration 12 months
Mandatory Technical / Functional Skills
• 8+ years of experience in the field of Oracle PL/SQL Development
• 5+ years of experience in Data Warehousing
• Advanced SQL coding skills
• Solid understanding of Data Modeling concepts
• Technical team management experience including offshore team members
• Excellent personal communication, leadership, and organizational skills
• Retail related data warehousing experience a plus
• Hands on Performance tuning (Table partition, hints,indexes)
• Hands on experience on SQL Loader.
• Experience on cron job monitoring
• Strong UNIX command and UNIX Shell scripting experience
• 4+Experience on ETL (Extract, Transform and Load) concepts is mandatory
"
Roles and responsibility " Guide onshore and offshore Oracle Developers to ensure standards are met
Work with the application development teams throughout the development life cycle
Lead or participate in Proof-of-Concept projects
Stay current with emerging industry trends
Ability to take initiative and ownership on tasks
Create Detail design document based on the business requirement
Ability to monitor batch jobs.
Good written and oral communication
Explain complex design items through documents and white-board sessions
SQL knowledge and performance tuning experience needed"
Desirable Technical / Functional Skills "Work with different teams – Business, Solutions – BI,DW team to create overall user interface, Implement solutions with complete considerations on Infrastructure capability, performance, supportability to achieve end user business results.
Total experience in required skill (years) ~8 years