Senior ETL Developer

Senior Etl Developer Strong and senior ETL developer with in-depth knowledge of both Informatica and Oracle. Candidate must be experienced to document design, mapping specifications. Candidate must possess deep knowledge of performance tuning with complex scenarios in both Informatica and Oracle. Candidate must be quickly able to jump start on the projects. Must possess deep understanding of data warehouses, data marts, and semantic layer builds. Candidate must have a thorough knowledge in how the semantic layers or data lakes can clearly support business reporting needs. Must have deep ETL architectural knowledge who should be able to articulate to business users on the whole framework. Candidate must be able to build a highly tuned mappings as well as views in Oracle. Candidate must have deep understanding of Oracle features such as but not limited to indexes, external tables, partitioning, sub-partitioning, calendar formats, metrics and summary building aggregated tables and so on. 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 present the architecture and strategy to management and stakeholders. Must be able to work under tight timelines in complex environments and perform with high quality. Skills: Informatica PowerCenter, Oracle 11g/12c, LINUX, Data Modeling, Informatica on Cloud The Ceres Group