Job Description Generating data and reporting requirements to support solution design and future business requirements Build Oracle BI Publisher (BIP) reports using data models.Assist with data mapping between Oracle Fusion data tables and current database table structures in Snowflake Create business reports, info tiles, and related dashboards with Oracle FusionDesign and implement custom reports using Oracle Fusion reporting tools to address company needs and business requirements Maintain expert product knowledge and use an analytical approach to identifying opportunities for enhancements; understand the Oracle out-of-the-box standard reporting options Create documentation and maintain custom reports, dashboard, and info tiles throughout quarterly upgrades; develop test scripts and manage execution Create and maintain standards and controls around productivity metrics and reporting for consistency across the department; maintain documentation for report creation and procedures Monitor and analyze key performance indicators to assess reports, performance, user engagement, and impacts on business outcomes Assist users with personalization, mobile features, report scheduling, and processing Required Knowledge, Skills and Experience: 3-5 years of experience in Oracle Cloud ERP Financials applications, including General Ledger, Payables, Expenses, Assets and Receivables Hands-on experience in building Oracle BIP, OTBI reports, and Analysis reports using data models.Proficiency in creating templates such as RTF, eText, Excel, etc.Expertise in Oracle technologies such as OTBI, BIP/XML Publisher, SQL, PL/SQL, and Oracle ReportsExperience in customizing reports using BI templates.Familiarity with using SOAP UIBachelors degree in finance, Accounting, IT, Computer Science or related field Excellent problem-solving skills with experience in solutioning and troubleshooting Strong analytical skills and ability to think in a complex and rapidly changing environment Excellent oral and written communication and interpersonal skills, with the ability to effectively collaborate with diverse stakeholders, both technical and non-technical Extensive experience in working with reporting software, including knowledge of SQL and basic table structures Strong business acumen and the ability to translate business requirements into technical specifications and vice versa Deep understanding of corporate reporting standards Project management skills to coordinate and oversee reporting strategies for current and future implementations Training and presentation skills to effectively educate and support employees in utilizing the dashboards, info tiles, and reports Analytical mindset and problem-solving abilities to identify process inefficiencies and propose effective solutions Proficient in Office 365 Suitewith emphasis on Microsoft Excel Proficiency in data analysis tools (e.g., Sigma, Python, R, SQL) and data visualization tools (e.g., MicroStrategy, Tableau, Power BI) Preferred Qualifications: Oracle Cloud Financial Certification Physical Requirements Work is primarily performed at a desk and/or in an office environment for 3/4 of the day and up The office noise level in the work environment is typically, moderate Generally, spend the workday sitting at a workstation and operating computer devices, such as, but not limited to keyboard, mouse, and screen Generally, spend the workday performing repetitive motions that involve or affect the hands, head, and other parts of your body

Job Title: Senior Database Administrator - SnowflakeWork Location: Bangalore (Bhartiya City)Job Type: Full-Time/PermanentExperience Level: 5+ YearsPosition Overview:This position is responsible for execution of standard tasks that fall under the database administration domain.Responsibilities:Snowflake Datawarehouse Administration - Configuring warehouses, databases, and other Snowflake objects and ensuring optimal configuration settings for performance and cost-efficiencyTime travel, Fail safe, Clustering, Cloning, Metadata managementCloud Platform - Aws Storage (S3), Azure Blob Storage and ContainersExpertise in SQL, Snowflake stored procedures.Creation & Management of Snowflake Objects like Database/Schema /Tables/Views/MV's /Pipes, Streams, Task Creation & ManagementAccount level Objects like Warehouse, Resource Monitor, Network Policies, Integration (Storage, Notification), Shares Connectivity issues resolution with respect to ODBC, JDBC, Python Connecters.Create replication and failover groups and restore data from Fail safe or from time travel dataTroubleshoot data loading issues, connection issues and Snow pipe issues.User management, Implementation of RBAC best practices.Design and develop secure access to objects in Snowflake with Role-Based Access Control (RBAC).Access Rights Management, experience with privileged roles Accountadmin, sysadmin and SecurityadminAnalyzing and Planning the Workload, Warehouses with Multi-clusters, Scaling policies and Application Specific warehouse creation and management for efficient Compute consumptionGenerate, manage and analyze Cost/credits Consumption reports and identify cost optimization areasPII data management using Dynamic data masking, Secure views implementation, managing Account level Security using network policies.Secure Data Sharing using managed accounts Creation, Reader Account provisioning and managing resource monitor, credit Quota, IP whitelistingIn depth knowledge of Micro partition, Caching, Table Clustering, Recommendation for Cluster key, Analysing the SQLs using query profile, identifying gaps, patterns and trends, recommendation to BI team based upon the analysisWorking experience in writing Procedures (PLSQL, Python) / UDF and calling them from Unix shell Scripts using SnowSql to automate day to day DBA BAU'sExperience working with Snowflake Utilities SnowSql, SnowPipeMonitor and coordinate all data replication system operations, including security procedures, and liaison with infrastructure, security, DevOps, Data Platform and Application team.Ensure that necessary system backups are performed, and storage and rotation of backups is accomplished.Manage and maintain the Snowflake environment, including provisioning resources, configuring databases, and monitoring performance to ensure optimal functionality with Qlik.Implement strategies to optimize the performance of Snowflake databases, including warehouse tuning, indexing, and data partitioning.Monitor Snowflake resource utilization and plan for capacity expansion to accommodate future growth and workload demands.Identify opportunities for cost optimization within the Snowflake environment, such as optimizing resource utilization, implementing auto-scaling policies, and leveraging cost-effective storage options. Nothing in this job description restricts managements right to assign or reassign duties and responsibilities to this job at any time.Required Knowledge, Skills, Abilities, and ExperienceUndergraduate degree with 5 to 7 years of experience with a relational database platform. Minium 2+ years experience with Snowflake admin. Minium 16 years of formal education is preferred. Advanced knowledge of relational database management system and principles, and database security.Advanced proficiency with SQL and SQL tuning.Solid knowledge of scripting/stored procs.Demonstrate ability to acquire knowledge of new database technologies while on the job.Be self-reliant and self-driven.Have strong analytical and problem-solving skills.Ability to pay meticulous attention to details.Ability to meet goals and deadlines.Ability to quickly diagnose issues and come up with solutions and/or workarounds.Ability to work independently or collaboratively and maintain a positive attitude.Strong verbal and written communication skills.Demonstrate honesty, integrity, and professionalism always.Exercise self-control under trying or tough circumstances, situations, or under any kind of pressure.Availability for 24x7 on-call on a rotation basis.Nice to have: Any replication technology QLIK, Stream, etc. Oracle, Mongo DB experience.