3 Sql Fundamentals Jobs

As a Salesforce Marketing Cloud Consultant in Sydney with over 9 years of experience, you are expected to have a strong domain knowledge of the Salesforce Marketing Cloud platform. Your responsibilities will include integrating marketing with Sales/Service Cloud and other external data systems for data push/pull, including CRMs, ERPs, eCommerce platforms, Google Analytics, and SMS. You should have a solid understanding of relational data models, SOAP APIs, REST APIs, and integration techniques, along with advanced SQL skills. Your role will involve designing marketing cloud journeys and campaigns based on data dependencies. Proficiency in Email Studio, Journey Builder, and campaign management is essential, including data configuration, audience creation, and utilizing SFMC platform capabilities. You should be adept at Amp Script for email personalization and creating complex cloud pages with Amp Script. A technical background with a history of understanding complex systems is required, along with the ability to work both independently and collaboratively in a team environment. Strong communication skills and team handling capabilities are crucial. Possession of Salesforce Marketing Cloud Consultant certification is mandatory for this role. Your experience in Email Studio, Journey Builder, Automation Studio, Web Studio/Cloud Pages, Amp Script, and Marketing Cloud API's (REST and SOAP) will be valuable. Key responsibilities include enabling and executing marketing automations, testing marketing automations with dynamic content, and designing and optimizing campaigns with strategies like A/B Testing and throttled sending. You will also be responsible for personalizing marketing campaigns, building and executing email campaigns using Content Builder, and leveraging AmpScript for dynamic content. Subscriber and data management tasks, working with Data Extensions, Profile management, and relational data models, are also part of your responsibilities. Additionally, you should be able to design mobile-responsive creatives, create Microsites using ExactTarget, and configure Exact Target Microsite Activity. Knowledge of UI and front-end web technologies like SSJS, HTML, CSS, and Javascript/jQuery will be considered a value addition to your role as a Salesforce Marketing Cloud Consultant.,

The Applications Development Technology Lead Analyst position is a senior-level role that involves establishing and implementing new or revised application systems and programs in coordination with the Technology team. Your main objective will be to lead applications systems analysis and programming activities. We are currently looking for an experienced Tableau developer with expertise in Tableau, Data Modeling, and Visualization to join our Market Risk team. The ideal candidate will have a strong background in building scalable, efficient, and high-quality solutions using Tableau. As a Tableau Lead with a minimum of 10 to 13 years of experience, you will be responsible for designing, developing, and maintaining business intelligence solutions using Tableau. You will collaborate closely with stakeholders to understand their data visualization needs and translate them into effective Tableau dashboards and reports. Additionally, you will be involved in data modeling, data extraction, and performance tuning to ensure optimal performance of Tableau solutions. Managing a small team of Tableau developers and assisting them in meeting business requirements will also be a part of your responsibilities. Your role will also involve developing interactive and visually appealing Tableau dashboards and reports, studying and brainstorming existing business requirements to suggest implementable solutions, working with business teams to design and deliver high-quality automation solutions, and optimizing Tableau performance through fine-tuning queries, data extracts, and dashboard designs. You will also provide technical guidance and support to other Tableau developers and end-users, stay updated on Tableau best practices and industry trends, and drive the vision for reporting and analytics capability supporting all use cases. To be successful in this role, you should have a finance background with an engineering undergrad degree and at least 10 to 13 years of experience in driving digital or business intelligence tool rollouts. Proficiency in Tableau Desktop, Tableau Server, and Tableau Online, as well as a strong understanding of data visualization principles and best practices, will be essential. Additionally, you should have hands-on knowledge of SQL Fundamentals, SQL Queries, SQL joins, and relational databases, along with strategic thinking around data modeling and anticipating future business requirements. Basic understanding of CICD pipelines, experience in data modeling, data extraction, and performance tuning, ability to work independently in a fast-paced environment, and strong communication and project management skills will be crucial for this role. Knowledge of Agile methodology and experience in managing large-scale projects using Agile will be preferred. A bachelor's degree in Computer Science, Information Systems, Engineering, Finance, or a related quantitative discipline is required for this position. This job description offers a comprehensive overview of the responsibilities and requirements for the Applications Development Technology Lead Analyst role. If you require a reasonable accommodation to use our search tools or apply for this opportunity due to a disability, please review Accessibility at Citi. For further information on Citis EEO Policy Statement and your rights, please refer to the respective documents.,

We Have immediate openings for Postgress SQL Primary Skills: Postgress SQL DBA with a strong focus on PostgreSQLSQL Fundamentals (DDL)Data typesTables and IndexingStored Procedures / FunctionsViewsLocking / Blocking / Deadlocking TSQL Queries (DML)SELECT / INSERT / UPDATE / DELETEJOINS / UNION HA/DRClusteringBackup and restore Install & ConfigurationInstall SQL ServerConfigure instances to best practiceSQL PatchingMaintenance and Capacity PlanningIndex and statistics maintenanceIntegrity checksAnalyse resource use to determine future requirementsMonitoringMonitor Server and Instance resourcesReact to alerts from monitoring toolsProactively review SQL Server healthSQL Profiler / Extended EventsPerfMon CountersPerformance Tuning and OptimisationQuery tuningQuery execution plans analysisSecurityAdminister logins, roles, users and permissionsTroubleshoot login problemsData Extract and ImportTroubleshoot production issues with existing deployed packages