124 Sql Optimization Jobs - Page 5

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

Project Role : Software Development Engineer Project Role Description : Analyze, design, code and test multiple components of application code across one or more clients. Perform maintenance, enhancements and/or development work. Must have skills : Microsoft SQL Server Analysis Services (SSAS) Good to have skills : Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services, No Function Specialty Minimum 5 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As a Software Development Engineer, you will analyze, design, code, and test multiple components of application code across one or more clients. You will perform maintenance, enhancements, and/or development work. Your typical day will involve analyzing requirements, designing solutions, writing code, and conducting testing to ensure the quality of the application. You will collaborate with team members, participate in code reviews, and contribute to the overall success of the project. Roles & Responsibilities: Expected to be an SME, collaborate and manage the team to perform. Responsible for team decisions. Engage with multiple teams and contribute on key decisions. Provide solutions to problems for their immediate team and across multiple teams. Analyze requirements and design solutions for application components. Write high-quality code following coding standards and best practices. Conduct unit testing and participate in code reviews to ensure code quality. Collaborate with team members to troubleshoot and resolve issues. Contribute to the overall success of the project by meeting project milestones and deliverables. Professional & Technical Skills: Must To Have Skills:Proficiency in Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services. Strong understanding of database concepts and SQL query optimization. Experience in designing and developing data models using Microsoft SQL Server Analysis Services (SSAS). Hands-on experience in writing complex SQL queries and stored procedures. Experience in performance tuning and optimization of SQL queries. Good To Have Skills:Experience with data visualization tools such as Tableau or Power BI. Solid grasp of data munging techniques, including data cleaning, transformation, and normalization to ensure data quality and integrity. Additional Information: The candidate should have a minimum of 5 years of experience in Microsoft SQL Server Analysis Services (SSAS). This position is based in Mumbai. A 15 years full-time education is required. Qualifications 15 years full time education

Overview Deputy Director - Data Engineering PepsiCo operates in an environment undergoing immense and rapid change. Big-data and digital technologies are driving business transformation that is unlocking new capabilities and business innovations in areas like eCommerce, mobile experiences and IoT. The key to winning in these areas is being able to leverage enterprise data foundations built on PepsiCos global business scale to enable business insights, advanced analytics, and new product development. PepsiCos Data Management and Operations team is tasked with the responsibility of developing quality data collection processes, maintaining the integrity of our data foundations, and enabling business leaders and data scientists across the company to have rapid access to the data they need for decision-making and innovation. What PepsiCo Data Management and Operations does: Maintain a predictable, transparent, global operating rhythm that ensures always-on access to high-quality data for stakeholders across the company. Responsible for day-to-day data collection, transportation, maintenance/curation, and access to the PepsiCo corporate data asset Work cross-functionally across the enterprise to centralize data and standardize it for use by business, data science or other stakeholders. Increase awareness about available data and democratize access to it across the company. As a data engineering lead, you will be the key technical expert overseeing PepsiCo's data product build & operations and drive a strong vision for how data engineering can proactively create a positive impact on the business. You'll be empowered to create & lead a strong team of data engineers who build data pipelines into various source systems, rest data on the PepsiCo Data Lake, and enable exploration and access for analytics, visualization, machine learning, and product development efforts across the company. As a member of the data engineering team, you will help lead the development of very large and complex data applications into public cloud environments directly impacting the design, architecture, and implementation of PepsiCo's flagship data products around topics like revenue management, supply chain, manufacturing, and logistics. You will work closely with process owners, product owners and business users. You'll be working in a hybrid environment with in-house, on-premises data sources as well as cloud and remote systems. Responsibilities Data engineering lead role for D&Ai data modernization (MDIP) Ideally Candidate must be flexible to work an alternative schedule either on tradition work week from Monday to Friday; or Tuesday to Saturday or Sunday to Thursday depending upon coverage requirements of the job. The can didate can work with immediate supervisor to change the work schedule on rotational basis depending on the product and project requirements. Responsibilities Manage a team of data engineers and data analysts by delegating project responsibilities and managing their flow of work as well as empowering them to realize their full potential. Design, structure and store data into unified data models and link them together to make the data reusable for downstream products. Manage and scale data pipelines from internal and external data sources to support new product launches and drive data quality across data products. Create reusable accelerators and solutions to migrate data from legacy data warehouse platforms such as Teradata to Azure Databricks and Azure SQL. Enable and accelerate standards-based development prioritizing reuse of code, adopt test-driven development, unit testing and test automation with end-to-end observability of data Build and own the automation and monitoring frameworks that captures metrics and operational KPIs for data pipeline quality, performance and cost. Collaborate with internal clients (product teams, sector leads, data science teams) and external partners (SI partners/data providers) to drive solutioning and clarify solution requirements. Evolve the architectural capabilities and maturity of the data platform by engaging with enterprise architects to build and support the right domain architecture for each application following well-architected design standards. Define and manage SLAs for data products and processes running in production. Create documentation for learnings and knowledge transfer to internal associates. Qualifications 12+ years of engineering and data management experience Qualifications 12+ years of overall technology experience that includes at least 5+ years of hands-on software development, data engineering, and systems architecture. 8+ years of experience with Data Lakehouse, Data Warehousing, and Data Analytics tools. 6+ years of experience in SQL optimization and performance tuning on MS SQL Server, Azure SQL or any other popular RDBMS 6+ years of experience in Python/Pyspark/Scala programming on big data platforms like Databricks 4+ years in cloud data engineering experience in Azure or AWS. Fluent with Azure cloud services. Azure Data Engineering certification is a plus. Experience with integration of multi cloud services with on-premises technologies. Experience with data modelling, data warehousing, and building high-volume ETL/ELT pipelines. Experience with data profiling and data quality tools like Great Expectations. Experience building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets. Experience with at least one business intelligence tool such as Power BI or Tableau Experience with running and scaling applications on the cloud infrastructure and containerized services like Kubernetes. Experience with version control systems like ADO, Github and CI/CD tools for DevOps automation and deployments. Experience with Azure Data Factory, Azure Databricks and Azure Machine learning tools. Experience with Statistical/ML techniques is a plus. Experience with building solutions in the retail or in the supply chain space is a plus. Understanding of metadata management, data lineage, and data glossaries is a plus. BA/BS in Computer Science, Math, Physics, or other technical fields. Candidate must be flexible to work an alternative work schedule either on tradition work week from Monday to Friday; or Tuesday to Saturday or Sunday to Thursday depending upon product and project coverage requirements of the job. Candidates are expected to be in the office at the assigned location at least 3 days a week and the days at work needs to be coordinated with immediate supervisor Skills, Abilities, Knowledge: Excellent communication skills, both verbal and written, along with the ability to influence and demonstrate confidence in communications with senior level management. Proven track record of leading, mentoring data teams. Strong change manager. Comfortable with change, especially that which arises through company growth. Ability to understand and translate business requirements into data and technical requirements. High degree of organization and ability to manage multiple, competing projects and priorities simultaneously. Positive and flexible attitude to enable adjusting to different needs in an ever-changing environment. Strong leadership, organizational and interpersonal skills; comfortable managing trade-offs. Foster a team culture of accountability, communication, and self-management. Proactively drives impact and engagement while bringing others along. Consistently attain/exceed individual and team goals. Ability to lead others without direct authority in a matrixed environment. Comfortable working in a hybrid environment with teams consisting of contractors as well as FTEs spread across multiple PepsiCo locations. Domain Knowledge in CPG industry with Supply chain/GTM background is preferred.

Sr Data Analyst About us: As a Fortune 50 company with more than 400,000 team members worldwide, Target is an iconic brand and one of America's leading retailers. Joining Target means promoting a culture of mutual care and respect and striving to make the most meaningful and positive impact. Becoming a Target team member means joining a community that values different voices and lifts each other up. Here, we believe your unique perspective is important, and you'll build relationships by being authentic and respectful. Overview about TII At Target, we have a timeless purpose and a proven strategy. And that hasn t happened by accident. Some of the best minds from different backgrounds come together at Target to redefine retail in an inclusive learning environment that values people and delivers world-class outcomes. That winning formula is especially apparent in Bengaluru, where Target in India operates as a fully integrated part of Target s global team and has more than 4,000 team members supporting the company s global strategy and operations. As a Sr Data Analyst for Target s Merch Data Analytics team you ll: Support our world-class Merchandising leadership team at Target with critical data analysis that helps Merch business team to make profitable decisions. Enable faster, smarter and more scalable decision-making to compete and win the modern retail market. Collaborate with stakeholders and understand their priorities/roadmap to drive business strategies using data. Interface with Target business representatives to validate business requirements/requests for analysis and present final analytical results. Designs, develops, and delivers analytical solutions resulting in decision support or models Gathers required data and performs data analysis to support needs. Communicate impact of proposed solutions to business partners Evaluates processes, analyzes and interprets statistical data Develop business acumen and cultivate client relationships Presents results in a manner that the business partners can understand. Translate scientific methodology to business terms. Documents analytical methodologies used in the execution of analytical projects Participate in knowledge sharing system to support iterative model builds Adheres to corporate information protection standards. Keep up to date on industry trends, best practices, and emerging methodologies / About You: ExperienceOverall 5-8 years exp and relevant 3-5 years exp Qualification B.Tech / B.E. or Masters in Statistics /Econometrics/Mathematics equivalent 1. Extensive exposure to Structured Query Language (SQL), SQL Optimization and DW/BI concepts. 2. Proven hands-on experience in BI Visualization tool (i.e. Tableau, Domo, MSTR10, Qlik) with ability to learn additional vendor and proprietary visualizations tools. 3. Strong knowledge of structured (i.e. Teradata, Oracle, Hive) and unstructured databases including Hadoop Distributed File System (HDFS). Exposure and extensive hands-on work with large data sets. 4. Hands on experience in R, Python, Hive or other open-source languages/database 5. Hands on experience in any advanced analytical techniques like Regression, Time-series models, Classification Techniques, etc. and conceptual understanding of all the techniques mentioned above 6. Git source code management & experience working in an agile environment. 7. Strong attention to detail, excellent diagnostic, and problem-solving skills 8. Highly self-motivated with a strong sense of urgency to be able to work both independently and in team settings in a fast-paced environment; capability to manage urgency timelines 9. Competent and curious to ask questions and learn to fill gaps, desire to teach and learn. 10. Excellent communication, service orientation and strong relationship building skills 11. Experience with Retail, Merchandising, Marketing will be strong addons Useful Links- Life at Target- https://india.target.com/ Benefits- https://india.target.com/life-at-target/workplace/benefits Culture- https://india.target.com/life-at-target/belonging

Performance Testing & AnalysisDesign, develop, and executeload, stress, endurance, and scalability tests using tools like JMeter, LoadRunner, or Gatling. Bottleneck IdentificationAnalyze performance issues related to CPU, memory, disk I/O, network latency, and application code. Optimization & TuningWork oncode optimizations, database query tuning, JVM tuning, and configuration adjustments to improve performance. Monitoring & ProfilingUseAPM tools (New Relic, Dynatrace, AppDynamics, Prometheus, Grafana) to track application performance in real-time. Automation & ScriptingDevelop test scripts usingPython, Java, or Shell scripting for continuous performance validation. CollaborationWork closely with developers, DevOps, and infrastructure teams totroubleshoot and resolve performance-related issues. Benchmarking & ReportingDefine performance benchmarks and generate reports with detailed insights and recommendations. Required education Bachelor's Degree Preferred education Bachelor's Degree Required technical and professional expertise 2+ years of experience in Performance Engineering or Performance Testing. Proficiency inperformance testing tools such as JMeter, LoadRunner, Gatling. Strong knowledge ofprofiling and monitoring tools like New Relic, Dynatrace, AppDynamics, Prometheus, Grafana. Experience withAPIs, microservices performance testing, and cloud-based performance testing. Hands-on expertise inJVM tuning, SQL query optimization, GC analysis, and thread dump analysis. Proficiency inscripting languages (Python, Bash, Groovy, or PowerShell). Familiarity withCI/CD pipelines, Kubernetes, Docker, AWS, or Azure for performance testing in cloud environments. Strong analytical and troubleshooting skills for identifying and resolving performance issues.

Senior Cloud Database Administrator Req number: R5945 Employment type: Full time Worksite flexibility: Onsite Who we are CAI is a global technology services firm with over 8,500 associates worldwide and a yearly revenue of $1 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right—whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise. Job Summary We are looking for a motivated Senior Cloud Database Administrator ready to take us to the next level! If you understand Postgres/Snowflake/Erwin/MySQL preferably on AWS and are looking forward to your next career move, apply now. Job Description We are looking for a Senior Cloud Database Administrator . This position will be full-time and Onsite Gurugram. What You’ll Do Provision Postgres/MySQL instances, both in clustered and non-clustered configurations. Managing and Administering Cloud based relational Database solutions. Strong skills in Snowflake administration are expected. Have strong experience on configuring and troubleshooting of primary/replica configurations in clustered and non-clustered environment. Data migration from on-premises databases to Cloud based database platforms. Design data models based on requirements/SRS/HLD/LLDs using tools like ERWIN etc. Ability to create ERDs. Clarity w.r.t Conceptual, Logical & Physical data models. Be a contributor to the database Projects team. Design & Implement Disaster Recovery and Business Continuity Solutions for database systems. Production Support model on call basis for critical incident handling and emergency support (24X7). Strong experience in database administration and production support tasks including Replication, SQL Optimization & Tuning, Monitoring, Backup/Recovery, Troubleshooting and Database Security on large Database environments. Exposure to AWS technology Stacks with experience in provisioning. Experience in Performance Tuning and troubleshooting complex database issues. Process Improvement: Continuously identify opportunities to improve processes and governance frameworks. Ensure compliance with organizational policies and standards. Risk Management: Identify potential risks and issues, implementing proactive measures to mitigate these within the scope. What You'll Need Bachelor’s degree in IT, or Equivalent. At least 10+ years of experience as Database Administrator. Postgres Database Administration on cloud preferably AWS Aurora. Snowflake administration. Data modelling using tools like Erwin. Desired Skills MySQL Database Administration. Oracle Database Administration. Exposure to SQL & PL/SQL, shell scripting etc. Physical Demands Sedentary work that involves sitting or remaining stationery most of the time with occasional need to move around the office to attend meetings, etc. Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor. Reasonable accommodation statement If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to application.accommodations@cai.io or (888) 824 – 8111.

Must Haves o Strong experience with SQL Development/NZSQL including Stored Procedures o Must have strong experience with advanced SQL development and SQL optimization . o Must have used external table, NZLOAD for file loading and unloading o Experience on Materialized views, CBTs o Worked in AWS Redshift development or Netezza for at least 2-3 years o Strong on Unix/Linux Shell Scripting o Ability to interpret data models (3NF or Kimbal) and code SQL accordingly o Must have used DevOps Jenkins, Bitbucket/Git/Sourcetree, Automated Test Scripts using Unix etc. o Must have strong analytic and problem-solving skills. o Must have implemented end to end BI DWH application. Good to Have o Good to have an understanding of Control M , IBM CDC, EC2 etc. o Good to have an understanding of AWS S3 , AWS DMS services. o Good to have an understanding of reporting tools like Tableau or Cognos o Insurance Domain Knowledge would be an added advantage. o Good to have experience in Agile ways of working

Database Administrator Req number: R5943 Employment type: Full time Worksite flexibility: Remote Who we are CAI is a global technology services firm with over 8,500 associates worldwide and a yearly revenue of $1 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right—whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise. Job Summary Job Description Areas of Responsibility 1. Design data models based on requirements/SRS/HLD/LLDs using tools like ERWIN etc. 2. Ability to create ERDs 3. Clarity w.r.t Conceptual, Logical & Physical data models 4. Provision Postgres/MySQL instances, both in clustered and non-clustered configurations. 5. Managing and Administering Cloud based relational Database solutions. 6. Have strong experience on configuring and troubleshooting of primary/replica configurations in clustered and non-clustered environment. 7. Data migration from on-premises databases to Cloud based database platforms. 8. Be a contributor to the database Projects team. 9. Design & Implement Disaster Recovery and Business Continuity Solutions for database systems. 10. Production Support model on call basis for critical incident handling and emergency support (24X7). 11. Strong experience in database administration and production support tasks including Replication, SQL Optimization & Tuning, Monitoring, Backup/Recovery, Troubleshooting and Database Security on large Database environments. 12. Exposure to AWS technology Stacks with experience in provisioning 13. Experience in Performance Tuning and troubleshooting complex database issues. 14. Process Improvement: Continuously identify opportunities to improve processes and governance frameworks. Ensure compliance with organizational policies and standards. 15. Risk Management: Identify potential risks and issues, implementing proactive measures to mitigate these within the scope Reasonable accommodation statement If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to application.accommodations@cai.io or (888) 824 – 8111.

About the Role We are looking for a Senior Data Engineer with an architects mindset and thought leadership approach on the Data & Analytics team. This role goes beyond developmentit's about end-to-end thinking, mentoring and collaborating with a global team. As a key technical leader, you will align data strategies with business needs, and drive best practices in data modeling, governance, and performance optimization. you will play a pivotal role in streamlining tooling for Democratized Development within Snowflake, DBT related data platforms and build high impact data models. You will drive performance optimization, cost efficiency, data governance, and model architecture, ensuring that our data infrastructure is scalable, secure, and high-performing. This role requires deep expertise in cloud-based data engineering, a strong problem-solving mindset, and the ability to collaborate with business and analytics teams . You will work on optimizing compute resources, improving data quality, and enforcing governance standards , support code reviews, and mentor team members, fostering a high-performing data engineering culture. Key Responsibilities Data Acquisition & Pipeline Development Develop and maintain scalable data pipelines for efficient data ingestion, transformation, and integration. Work with Fivetran, Python, and other ETL/ELT tools to automate and optimize data acquisition from various sources. Ensure reliable data movement from SaaS platforms (e.g., Salesforce, Gong, Google Analytics) and operational databases into Snowflake. Monitor and enhance pipeline performance, identifying areas for optimization and fault tolerance. Evaluate and recommend new technologies for data ingestion, transformation, and orchestration. Democratized Development & Tooling Enable and streamline self-service data development for analysts and data practitioners. Drive best practices in DBT and Snowflake for modular, reusable, and governed data modeling. Design and maintain CI/CD pipelines to support version control, testing, and deployment in a modern data stack. Performance Optimization & Cost Efficiency Optimize and tune Snowflake queries and workloads for performance and cost efficiency. Implement warehouse resource scaling strategies to reduce compute costs while maintaining SLAs. Monitor and analyze query performance, storage consumption, and data usage patterns to identify optimization opportunities. Data Quality, Governance & Security Establish data quality monitoring frameworks, integrating automated validation and anomaly detection. Enforce data governance policies, including access controls, lineage tracking, and compliance standards. Work closely with security teams to implement data protection strategies in Snowflake. Data Model Development & Architecture Review Design and develop scalable, well-structured data models in Snowflake. Perform data model reviews to ensure consistency, efficiency, and alignment with business needs. Collaborate with Analytics & BI teams to define metrics layers and transformation logic in DBT. Collaboration & Agile Execution Collaborate with BI teams to ensure data models meet reporting requirements in Power BI. Partner with cross-functional teams including Sales, Marketing, Customer Support, Finance, and Product to deliver trusted, high-quality data solutions. Work within an Agile framework, delivering iterative improvements to data infrastructure. Stay ahead of industry trends in modern data engineering, Snowflake, and DBT to drive innovation. Qualifications Bachelors or Masters degree in Computer Science, Information Technology, or a related field. 5+ years of experience in Data Engineering with strong expertise in Snowflake. 2+ years of hands-on experience in DBT for data modeling and transformation. 2+ years of experience in Python, particularly for data pipelines and automation. Strong expertise in SQL optimization and performance tuning. Deep understanding of ETL/ELT architectures, data warehousing, and cloud data management best practices. Experience implementing cost monitoring and optimization techniques in Snowflake. Strong problem-solving skills and ability to troubleshoot complex data issues. Excellent communication skills and ability to work in collaborative, cross-functional teams. Experience with Agile methodologies and iterative data development processes is a plus.

Position: Sr. Solutions Architect 100% Remote Time: 3PM onwards Job Summary: Role - Sr. Solutions Architect This project is working on a new analytic platform, consolidation, and implementation and will identify, lead, and deliver data analysis and architecture optimization. Must haves: Must have experience with Data Lake Infrastructure, Data warehousing and Data Analytics Tools. Expertise in SQL Optimization and performance tuning and development of procedures Experience with Database technologies such as SQL Oracle or Informatica Working knowledge of Agile based development including DevOps, DataOps Good problem-solving skills including debugging skills Experience leading 3-4 projects as the Technical Architect. Interested Candidate can apply: dsingh15@fcsltd.com

Description: Note that this is an authentic "Data Analyst" role. Must Have skills/competencies 5 years hands-on experience with data analysis to extract inferences and trends from huge amounts of data using a variety of techniques for analyzing data to gain valuable insights that can enhance various aspects of business/operations.The data can be qualitative, quantitative and time series. including Exploratory data analysis Causal data analysis Statistical data analysis (descriptive and inferential) Regressions, correlation, experiments, hypothesis testing etc Some experience with data visualization tools like PowerBI or data visualization libraries (for example MatPlotLib, Seaborn etc.) 2 to 3 years strong hands on experience with writing complex SQL queries Ability to work with multiple stakeholders to understand the data, come-up with several options to analyse, slice & dice the data to bring out trends and action items for better business outcome. Good to have Hands-on experience with Python Understanding of no-SQL db Requirements: Note that this is an authentic "Data Analyst" role. Must Have skills/competencies 5 years hands-on experience with data analysis to extract inferences and trends from huge amounts of data using a variety of techniques for analyzing data to gain valuable insights that can enhance various aspects of business/operations.The data can be qualitative, quantitative and time series. including Exploratory data analysis Causal data analysis Statistical data analysis (descriptive and inferential) Regressions, correlation, experiments, hypothesis testing etc Some experience with data visualization tools like PowerBI or data visualization libraries (for example MatPlotLib, Seaborn etc.) 2 to 3 years strong hands on experience with writing complex SQL queries Ability to work with multiple stakeholders to understand the data, come-up with several options to analyse, slice & dice the data to bring out trends and action items for better business outcome. Good to have Hands-on experience with Python Understanding of no-SQL db Job Responsibilities: Note that this is an authentic "Data Analyst" role. Must Have skills/competencies 5 years hands-on experience with data analysis to extract inferences and trends from huge amounts of data using a variety of techniques for analyzing data to gain valuable insights that can enhance various aspects of business/operations.The data can be qualitative, quantitative and time series. including Exploratory data analysis Causal data analysis Statistical data analysis (descriptive and inferential) Regressions, correlation, experiments, hypothesis testing etc Some experience with data visualization tools like PowerBI or data visualization libraries (for example MatPlotLib, Seaborn etc.) 2 to 3 years strong hands on experience with writing complex SQL queries Ability to work with multiple stakeholders to understand the data, come-up with several options to analyse, slice & dice the data to bring out trends and action items for better business outcome. Good to have Hands-on experience with Python Understanding of no-SQL db What We Offer: Exciting Projects: We focus on industries like High-Tech, communication, media, healthcare, retail and telecom. Our customer list is full of fantastic global brands and leaders who love what we build for them. Collaborative Environment: You Can expand your skills by collaborating with a diverse team of highly talented people in an open, laidback environment — or even abroad in one of our global centers or client facilities! Work-Life Balance: GlobalLogic prioritizes work-life balance, which is why we offer flexible work schedules, opportunities to work from home, and paid time off and holidays. Professional Development: Our dedicated Learning & Development team regularly organizes Communication skills training(GL Vantage, Toast Master),Stress Management program, professional certifications, and technical and soft skill trainings. Excellent Benefits: We provide our employees with competitive salaries, family medical insurance, Group Term Life Insurance, Group Personal Accident Insurance , NPS(National Pension Scheme ), Periodic health awareness program, extended maternity leave, annual performance bonuses, and referral bonuses. Fun Perks: We want you to love where you work, which is why we host sports events, cultural activities, offer food on subsidies rates, Corporate parties. Our vibrant offices also include dedicated GL Zones, rooftop decks and GL Club where you can drink coffee or tea with your colleagues over a game of table and offer discounts for popular stores and restaurants!

Sr Data Analyst As a Fortune 50 company with more than 400,000 team members worldwide, Target is an iconic brand and one of America's leading retailers. Joining Target means promoting a culture of mutual care and respect and striving to make the most meaningful and positive impact. Becoming a Target team member means joining a community that values different voices and lifts each other up. Here, we believe your unique perspective is important, and you'll build relationships by being authentic and respectful. Overview about TII At Target, we have a timeless purpose and a proven strategy. And that hasnt happened by accident. Some of the best minds from different backgrounds come together at Target to redefine retail in an inclusive learning environment that values people and delivers world-class outcomes. That winning formula is especially apparent in Bengaluru, where Target in India operates as a fully integrated part of Targets global team and has more than 4,000 team members supporting the companys global strategy and operations. As a Sr Data Analyst for Targets Merch Data Analytics team youll: Support our world-class Merchandising leadership team at Target with critical data analysis that helps Merch business team to make profitable decisions. Enable faster, smarter and more scalable decision-making to compete and win the modern retail market. Collaborate with stakeholders and understand their priorities/roadmap to drive business strategies using data. Interface with Target business representatives to validate business requirements/requests for analysis and present final analytical results. Designs, develops, and delivers analytical solutions resulting in decision support or models Gathers required data and performs data analysis to support needs. Communicate impact of proposed solutions to business partners Evaluates processes, analyzes and interprets statistical data Develop business acumen and cultivate client relationships Presents results in a manner that the business partners can understand. Translate scientific methodology to business terms. Documents analytical methodologies used in the execution of analytical projects Participate in knowledge sharing system to support iterative model builds Adheres to corporate information protection standards. Keep up to date on industry trends, best practices, and emerging methodologies / About You: ExperienceOverall 5-8 years exp and relevant 3-5 years expQualificationB.Tech / B.E. or Masters in Statistics /Econometrics/Mathematics equivalent 1. Extensive exposure to Structured Query Language (SQL), SQL Optimization and DW/BI concepts. 2. Proven hands-on experience in BI Visualization tool (i.e. Tableau, Domo, MSTR10, Qlik) with ability to learn additional vendor and proprietary visualizations tools. 3. Strong knowledge of structured (i.e. Teradata, Oracle, Hive) and unstructured databases including Hadoop Distributed File System (HDFS). Exposure and extensive hands-on work with large data sets. 4. Hands on experience in R, Python, Hive or other open-source languages/database 5. Hands on experience in any advanced analytical techniques like Regression, Time-series models, Classification Techniques, etc. and conceptual understanding of all the techniques mentioned above 6. Git source code management & experience working in an agile environment. 7. Strong attention to detail, excellent diagnostic, and problem-solving skills 8. Highly self-motivated with a strong sense of urgency to be able to work both independently and in team settings in a fast-paced environment; capability to manage urgency timelines 9. Competent and curious to ask questions and learn to fill gaps, desire to teach and learn. 10. Excellent communication, service orientation and strong relationship building skills 11. Experience with Retail, Merchandising, Marketing will be strong addons Useful Links- Life at Target- https://india.target.com/ Benefits- https://india.target.com/life-at-target/workplace/benefits Culture- https://india.target.com/life-at-target/belonging

Job Overview We are seeking a skilled MySQL Database Administrator to join our team in Guwahati. This mid-level position requires a minimum of 4 years of relevant experience. The successful candidate will play a vital role in managing and maintaining our database systems, utilizing both on-premises and cloud environments. Qualifications and Skills Must have 5+ years relevant experience in PostgreSQL Core DBA Mandatory Skills/Knowledge 1. Excellent Knowledge on PostgreSQL Installation, configuration and troubleshooting replication tools - -Troubleshoot issues involving Unix levels commands 2. Fix issues related to Backup and Recovery with commands. -Migration tool from Oracle to Postgresql setup. 3. Good Hands-on on troubleshooting related to any user related problem like access management, space management, generic errors, etc 4. database upgrades and migrations on any Cloud Enviorment 5. Different type of replication concepts like Group replication, Multi master replication 6. Excellent performance troubleshooting using pgadmin commands, tools like pgpool, repmgr, oswatcher, etc 7. Troubleshooting issues related Database upgrades and migrations. -Install, configure and troubleshooting replication tools 8. Troubleshoot issues involving Unix, storage or network problem 9. Knowledge on VCS Cluster -Knowledge on, Grafana, kibana will be an added advantage Mentor and team builder. Reliable, hardworking, self-motivated, able to work independently or as a team member with the ability to meet deadlines. Adoption attitude based of situation.

Cloud Database Administrator Req number: R5888 Employment type: Full time Worksite flexibility: Onsite Who we are CAI is a global technology services firm with over 8,500 associates worldwide and a yearly revenue of $1 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right—whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise. Job Summary We are looking for a motivated Cloud Database Administrator ready to take us to the next level! If you understand Postgres/Snowflake/Erwin/MySQL preferably on AWS and are looking forward to your next career move, apply now. Job Description We are looking for a Cloud Database Administrator . This position will be full-time and Onsite Gurugram. What You’ll Do Provision Postgres/MySQL instances, both in clustered and non-clustered configurations. Managing and Administering Cloud based relational Database solutions. Strong skills in Snowflake administration are expected. Have strong experience on configuring and troubleshooting of primary/replica configurations in clustered and non-clustered environment. Data migration from on-premises databases to Cloud based database platforms. Design data models based on requirements/SRS/HLD/LLDs using tools like ERWIN etc. Ability to create ERDs. Clarity w.r.t Conceptual, Logical & Physical data models. Be a contributor to the database Projects team. Design & Implement Disaster Recovery and Business Continuity Solutions for database systems. Production Support model on call basis for critical incident handling and emergency support (24X7). Strong experience in database administration and production support tasks including Replication, SQL Optimization & Tuning, Monitoring, Backup/Recovery, Troubleshooting and Database Security on large Database environments. Exposure to AWS technology Stacks with experience in provisioning. Experience in Performance Tuning and troubleshooting complex database issues. Process Improvement: Continuously identify opportunities to improve processes and governance frameworks. Ensure compliance with organizational policies and standards. Risk Management: Identify potential risks and issues, implementing proactive measures to mitigate these within the scope. What You'll Need Bachelor’s degree in IT, or Equivalent. At least 6 years of experience as Database Administrator. Postgres Database Administration on cloud preferably AWS Aurora. Snowflake administration. Data modelling using tools like Erwin. Desired Skills MySQL Database Administration. Oracle Database Administration. Exposure to SQL & PL/SQL, shell scripting etc. Physical Demands Sedentary work that involves sitting or remaining stationery most of the time with occasional need to move around the office to attend meetings, etc. Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor. Reasonable accommodation statement If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to application.accommodations@cai.io or (888) 824 – 8111.