64 Advanced Sql Jobs - Page 2

As an Analyst, you will be responsible for analyzing business requirements and converting them into technical specifications. You will collaborate with stakeholders to elicit and document user requirements, design and implement system solutions using SQL Server and other technologies, and perform data analysis and reporting to support business decision-making. Your role will involve developing and maintaining technical documentation for system processes and functionalities, conducting system testing and troubleshooting, and working closely with IT development teams to facilitate system enhancements and integrations. In this role, you will also be expected to assist in project management acti...

Responsibilities Analyzing existing data sources Expert understanding of data models and various 1 to many, many to many and other patterns, normalization and denormalization patterns and purposes Profile data sources to reverse engineer data model and relationships between tables, identify key fields, and infer meaning of attributes Meet with system owners to tie observations of data patterns with business processes and use cases that lead to those patterns Conduct root cause analysis (RCA) to identify underlying issues and drive effective solutions. Perform frequency distribution analysis to identify patterns and trends in the data.Architecting data strategy for Future State Profile the da...

Responsibilities Analyzing existing data sources Expert understanding of data models and various 1 to many, many to many and other patterns, normalization and denormalization patterns and purposes Profile data sources to reverse engineer data model and relationships between tables, identify key fields, and infer meaning of attributes Meet with system owners to tie observations of data patterns with business processes and use cases that lead to those patterns Conduct root cause analysis (RCA) to identify underlying issues and drive effective solutions. Perform frequency distribution analysis to identify patterns and trends in the data.Architecting data strategy for Future State Profile the da...

As an Azure Data Engineer at our company, you will be responsible for designing, developing, and deploying scalable data pipelines using Azure Data Factory, Databricks, and PySpark. Your role will involve working with large datasets (500 GB+) to optimize data processing workflows. Collaborating with cross-functional teams to prioritize project requirements and ensuring data quality, security, and compliance with organizational standards will be essential tasks. Troubleshooting data pipeline issues, optimizing performance, and effectively communicating technical solutions to non-technical stakeholders are key aspects of the role. To excel in this position, you should have at least 4 years of ...

You should have a minimum qualification of MCA/B.E./B.Tech in IT/CS/ECE with 4-7 years of relevant experience. Excellent communication skills are a must for this role. Your technical competencies should include advanced SQL knowledge, proficiency in Basic and Advanced Excel, strong understanding of SDLC methodologies such as agile and waterfall model, familiarity with tracking tools like JIRA, and proficiency in HTML/CSS. In terms of personal attributes, you should possess strong verbal and written communication skills to effectively collaborate with cross-functional teams. Additionally, strong interpersonal, analytical, and problem-solving skills will be essential for success in this role. ...

As a Senior Azure Data Engineer based in Chennai, India, you will play a crucial role in designing and implementing data pipelines using Azure Synapse to integrate data from various sources and file formats into SQL Server databases. Your responsibilities will include developing batch and real-time data pipelines to facilitate the transfer of data to data warehouses and data lakes. Collaborating with the Data Architect, you will work on new Data projects by constructing Data pipelines and managing Master Data. Your expertise in data analysis, extraction, cleansing, column-mapping, data transformations, and data modeling will be essential in meeting business requirements. You will be tasked w...

You will be responsible for designing, building, and maintaining scalable and efficient data pipelines to facilitate the movement of data between cloud-native databases (e.g., Snowflake) and SaaS providers using AWS Glue and Python. Your role will involve implementing and managing ETL/ELT processes to ensure seamless data integration and transformation while adhering to information security and compliance with data governance standards. Additionally, you will be tasked with maintaining and enhancing data environments, including data lakes, warehouses, and distributed processing systems. It is crucial to utilize version control systems (e.g., GitHub) effectively to manage code and collaborate...

The Tech Lead Power BI position at ValueMomentums Engineering Center in Hyderabad requires 7-10 years of experience and expertise in Advanced SQL, Power BI, Cognos, and SSRS. As a Tech Lead Power BI, you will be responsible for designing, developing, and implementing business intelligence reports and dashboards using Power BI and related BI tools. Your role will involve converting business requirements into technical specifications, creating visual interactive reports, identifying KPIs, and analyzing data to support decision-making. You will also be mentoring other BI teammates and providing end-user support. ValueMomentums Engineering Center is a team of passionate engineers dedicated to ad...

As an ETL Developer with our team, you will be responsible for a range of tasks including enhancements, new development, defect resolution, and production support of ETL development utilizing AWS native services. Your expertise will be crucial in integrating data sets through AWS services such as Glue and Lambda functions. Additionally, you will be utilizing AWS SNS for sending emails and alerts, authoring ETL processes using Python and PySpark, and monitoring ETL processes using CloudWatch events. Your role will also involve connecting with various data sources like S3, validating data using Athena, and implementing CI/CD processes using GitHub Actions. Proficiency in Agile methodology is e...

Were seeking a Senior Software Engineer or a Lead Software Engineer to join one of our Data Layer teams. As the name implies, the Data Layer is at the core of all things data at Zeta. Our responsibilities include: Developing and maintaining the Zeta Identity Graph platform, which collects billions of behavioural, demographic, locations and transactional signals to power people-based marketing. Ingesting vast amounts of identity and event data from our customers and partners. Facilitating data transfers across systems. Ensuring the integrity and health of our datasets. And much more. As a member of this team, the data engineer will be responsible for designing and expanding our existing data ...

As a Senior Software Engineer in the Software department, you will be responsible for the following key tasks: - Demonstrating proven work experience as a backend developer - Utilizing your hands-on experience with Java, specifically emphasizing Java 8 as a requirement. Knowledge of Java 11/17 will be an added advantage - Showing a strong understanding of Spring Framework, Spring Boot, and proficient skills in RESTful API design - Leveraging AI-assisted development tools like GitHub Copilot and ChatGPT to improve code quality, hasten development processes, and automate repetitive tasks - Employing AI models and frameworks such as Llama for tasks related to natural language understanding and ...

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 managemen...

The ideal candidate should have 1 to 2 years of experience in providing technical training and mentoring. You must possess a strong understanding of Data Analytics and hands-on experience with Python, Advanced Python, R programming, SAS, and machine learning. Proficiency in SQL and Advanced SQL is essential, along with a basic understanding of Statistics. Knowledge of operating systems such as GNU/Linux and Network fundamentals is required. Additionally, familiarity with MS Office applications (Excel, Word, PowerPoint) is necessary. The candidate should be self-motivated, technology-driven, possess excellent analytical and logical skills, and be a good team player. Exceptional communication ...

You are a Mid-Level ETL Tester SQL Python Data Quality Engineer with 4-8 years of experience, specializing in data quality, functional testing, and advanced SQL skills. Your role at EIL Global, a prominent IT services provider based in Adelaide, Australia, involves ensuring data integrity and accuracy across systems in Chennai or Pune. You will be required to work on-site for 3 days a week. You must have a strong proficiency in Python or Java for automating testing processes and scripts. Additionally, proven experience in functional testing methodologies and advanced SQL skills are essential for efficiently extracting, manipulating, and validating large amounts of data. Experience in CI/CD p...

As a senior data consultant, you will serve as a trusted advisor and subject matter expert, utilizing data to drive actionable business insights. Your role involves leading client engagements, delivering high-quality data solutions, and collaborating with sales teams to create accelerators, architectural artifacts, and pre-sales assets for RFPs. In this position, you will lead strategic data consulting projects, working directly with clients to design and implement data-driven solutions. You will be responsible for developing and maintaining a library of accelerators, frameworks, and artifacts to support sales proposals and RFP responses. Additionally, you will collaborate with cross-functio...

As a Documentation Specialist, you will be responsible for creating world-class customer-facing documentation that delights and excites customers. Your role involves removing ambiguity by documenting information effectively, leading to increased team efficiency and effectiveness. Your efforts will help convert tacit knowledge into implicit knowledge. You will manage a full region or multiple customers within a region, owning end-to-end communication and status reporting to both leadership and customers. Your responsibilities include managing your portfolio, estimates, asset projection, unit metrics, tracking CARR (Contracted Annual Recurring Revenue), asset transfers, and cloud costs for ful...

At EY, you'll have the opportunity to shape a career that is as unique as you are, benefiting from global support, an inclusive culture, and cutting-edge technology to empower you to reach your full potential. Your distinctive voice and perspective are crucial in contributing to EY's continuous improvement. Join us in creating an exceptional experience for yourself and in fostering a better working world for all. As a part of the EY-ER-Regulatory Compliance team, you will play a key role in understanding clients" business requirements and delivering solutions in alignment with EY guidelines and methodologies. In your role as a Regulatory Compliance Senior, you will actively cultivate and enh...

You should have good knowledge in System Replication server Architecture and a deep understanding of Sybase architecture, including installation, configuration, maintenance, and applying security patches. Your responsibilities will include DB Shrink, SRS configuration, and troubleshooting latency issues. Performance tuning will be a key aspect of your role. Additionally, you should have experience with high availability and disaster recovery planning and solutions. Knowledge of scripting languages for automation is essential. Advanced SQL knowledge is required, including stored procedures, triggers, and complex query optimization techniques. You should also be familiar with backups, restores...

As a Data Analytics Lead at Cummins Inc., you will be responsible for facilitating data, compliance, and environment governance processes for the assigned domain. Your role includes leading analytics projects to provide insights for the business, integrating data analysis findings into governance solutions, and ingesting key data into the data lake while ensuring the creation and maintenance of relevant metadata and data profiles. You will coach team members, business teams, and stakeholders to find necessary and relevant data, contribute to communities of practice promoting responsible analytics use, and develop the capability of peers and team members within the Analytics Ecosystem. Additi...

Greetings, We have an opening for one of our clients " Mphasis " for " Scala Developer " position. Role & responsibilities Bachelor's or Master's degree in Computer Science, Engineering, or a related quantitative field. Minimum 5 years of professional experience in Data Engineering, with a strong focus on big data technologies. Proficiency in Scala for developing big data applications and transformations, especially with Apache Spark. Expert-level proficiency in SQL; ability to write complex queries, optimize performance, and understand database internals. Extensive hands-on experience with Apache Spark (Spark SQL, DataFrames, RDDs) for large-scale data processing and analytics. Solid unders...

Design and manage scalable, secure, and high-performance database systems aligned with business goals. Optimize performance, ensure data integrity, and implement modern data solutions. Lead cross-functional collaboration.

Role & responsibilities Responsibilities Manage end-to-end data pipelines, ensuring seamless flow and integrity of data from diverse sources to analytical systems Collaborate with data scientists, analysts, and business teams to understand data needs and develop efficient solutions. Implement robust data governance practices to maintain data quality standards and facilitate reliable analysis and reporting Conduct thorough data validation procedures to ensure accuracy and reliability of analytical outputs Monitor data systems and pipelines, troubleshoot issues, and ensure the continuous availability of data Ensure data quality, integrity, and consistency across different data sources and stor...

Role & responsibilities Responsibilities Mine and analyse data to identify patterns and correlations among the various data points. Perform end-to-end analysis across all digital touchpoints, including data gathering from large and complex data sets, data processing, and analysis. Conduct in-depth analysis of user behaviour, customer journeys and other relevant metrics to understand the effectiveness of digital initiatives and identify areas for improvement. Present findings from analytics and research and make recommendations to business teams. Preferred candidate profile Skills & Requirement Must Have... 3-5 years of experience working in the field of analytics, reporting out metrics and d...

Job Title: Lead ETL Developer Job Location: Pune Job Description: Company Introduction Join Nitor Infotech, an Ascendion company, where we harness data to drive impactful solutions. Our innovative team is dedicated to excellence in data processing and analytics, making a significant difference in the retail domain. Be part of a collaborative environment that values your expertise and contributions. Job Overview We are seeking an ETL Developer with expertise in Advanced SQL, Python, and Shell Scripting. This full-time position reports to the Data Engineering Manager and is available in a hybrid work model. This is a replacement position within the SRAI - EYC Implementation team. Key Responsib...

As a Databricks Engineer-Lead, you will be responsible for designing and developing ETL pipelines using Azure Data Factory for data ingestion and transformation. You will collaborate with various Azure stack modules such as Data Lakes and SQL Data Warehouse to create robust data solutions. Your role will involve writing efficient SQL, Python, and PySpark code for data processing and transformation. It is essential to understand and translate business requirements into technical designs, develop mapping documents, and adhere to transformation rules as per the project scope. Effective communication with stakeholders to ensure smooth project execution is a crucial aspect of this role. To excel ...