*New opening:*
SQL tuning and Oracle partitioning is very important *Title: *Senior Data Warehouse ETL Consultant, 9591903 *Company: *Sunovion Pharmaceuticals *Location: *84 Waterford Drive, Marlborough, MA. *Start* 11/11/2019 *Duration: *03/31/2020 *Max Pay: *75 C2C *Interview Process: *phone, then MUST GO ONSITE *Job Description**:* Special Project: New Semantic Layer in the DataMart to support Commercial Sale Reporting and Various other Complex ETL Routines *Skills:* •Informatica PowerCenter •Oracle 11g/12c •LINUX •Data Modeling •Informatica on Cloud *PLEASE FOCUS ON AREAS IN BOLD - THAT IS CRITICAL TO RIGHT CANDIDATE * Strong Developer with in Depth Knowledge of Oracle. Candidate must be experienced to document Design Specifications Candidate must be Quickly be able to jump start on the projects, articulate to Business / Reporting users on the whole frame work, Candidate must have a thorough knowledge in how the semantic layers or Data Lakes can clearly support Business reporting needs *Candidate must possess:* *Ability to tune based on:* *Execution plan, * *SQL Tuning Advisory and thorough understanding of SQL Profiles and * *TK prof * *All latest 12C, 18C features such as Out of Place refresh for materialized views* *Must have deep knowledge and ease in writing Strong and complex, parallel data processing / queries in Oracle, External Tables, Partitioning, Sub- Partitioning, Calendar formats, Metrics, enterprise calendar dimensions* *Ability to tune based on:* *Wait events, * *Default parameters set in database, * *Temp space management, * *Understanding file system supporting the database, * *CPU consumption during heavy/big data query processing, * *Oracle Partitioning, Hints, Indexes, Procedures* *Strong knowledge in supporting a dynamic Reporting Platform concepts, * *Rollups based on time-period, geography, roster based hierarchies, data transposing* *Row level security* Must be able to Present the Architecture and Strategy to Management and Stake holders Works on code migration, testing defect resolution, and initial data loads and ongoing data loads. Responsible for whole Project technical implementations and Planning Build all Systems Testing, Integration Testing and UAT Testing Plans and Test Cases. Commercial Sales and Marketing Knowledge in Pharma is Preferred Knowledge on AWS Redshift, S3, Snowflake.net, Veeva CRM, Veeva Network MDM and any other similar technologies is highly Desired Must be a self-learner and a Team Player Demonstrate Excellence in all the work they perform Must be able to work under tight timelines in complex environments and perform with high quality, when required though not a norm. Thanks & Regards, Ben, IT Recruiter, Sagarsoft, Inc [image: cid:clip_image001.jpg@1537287699.9363] E-verify Company Email: b...@sagarsoft.com, Mobile : (203)658-5196, 200 Glastonbury Boulevard, Ste # 304 Glastonbury, CT 06033// www.sagarsoft.com -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To unsubscribe from this group and stop receiving emails from it, send an email to android-developers+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/android-developers/CAFUdJ0GTxzqHzG%2B7cFXCv8f95E%3DtxpGRP_Lx4pBijt7SS4eQXA%40mail.gmail.com.