Zynga is looking for a Senior Oracle Integrations Engineer who is experienced in writing code, reports, interfaces, integrations etc for OLTP and Data-warehouse/Data-Marts/Decision Support Systems built on Oracle technologies. The Engineer should be capable designing and developing programs and procedures around Oracle Open Systems and Oracle Data-warehouses.
Design and Develop custom applications, data-warehouse and data-marts using Oracle tools and technologies
Interact with peer developers, DBAs, Unix administrators, System Administrators to diagnose and implement patches/bug fixes in production environments
Diagnose production issues, identifying and implementing fixes in collaboration with Oracle DBAs, System Administrators, UNIX administrators etc.
Use various Oracle diagnostics tools and scripts to diagnose production and user reported issues
Develop, implement and maintain integration with third-party applications
Troubleshoot and work closely with end-users to resolve data issues
Work closely with business users to design, implement and test application extensions, conversions, interfaces and reports
Develop technical documentation as required
Follow change management processes
5+ years of experience in designing, developing, implementing interfaces, extensions and reports in Oracle based custom applications and data-warehouse/data-marts.
Strong experience with Oracle tools and technologies
Bachelors degree in Computer Science or Electrical/Electronics or Applied Mathematics
Complete understanding of Data-Warehouse, OLAP systems, Star-schemas and Data-marts
Proficiency in one or more ETL tools and other Data warehouse techniques like job scheduling and workflow.
Strong Enterprise Application Integration (EAI) skills to integrate Zynga’s systems with third party systems.
Hands-on development / support experience of Oracle based custom systems.
Proficiency in SQL Plus, PL/SQL, Reports 10g, Forms 10g, Discoverer Reports, SQL Loader,and LINUX scripting.
Experience working with Toad, and some Enterprise reporting solutions
Experience with Oracle EBS R12 a solid plus.
Knowledge of MS Office products, including MS Access and Visio
Excellent sense of judgment to report and escalate issues to superiors in a timely manner
Self motivated with an ability to take up initiatives and execute tasks with full ownership and deliver agreed upon deliverables in a timely manner
Excellent verbal, written, and interpersonal communication skills
Zynga - 16 months ago