65 Star Schema Jobs - Page 3

Primary Skill- currently must have working in ETL testing, expertise in SSIS, SQL query writing, must have handled larger data stack range of 1 million and manual testing SQL & query optimization, ETL Testing & Validation, DB concepts, Testcase Development & Execution, Automation & Tools, Performance Testing & MonitoringStrong SQL Skills (Joins, subqueries, Aggregations, Window functions). Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables)Experience in SQL Server, SSIS Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

Primary Skill- currently must have working in ETL testing, expertise in SSIS, SQL query writing, must have handled larger data stack range of 1 million and manual testing SQL & query optimization, ETL Testing & Validation, DB concepts, Testcase Development & Execution, Automation & Tools, Performance Testing & MonitoringStrong SQL Skills (Joins, subqueries, Aggregations, Window functions). Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables)Experience in SQL Server, SSIS Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

Primary Skill- currently must have working in ETL testing, expertise in SSIS, SQL query writing, must have handled larger data stack range of 1 million and manual testing SQL & query optimization, ETL Testing & Validation, DB concepts, Testcase Development & Execution, Automation & Tools, Performance Testing & MonitoringStrong SQL Skills (Joins, subqueries, Aggregations, Window functions). Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables)Experience in SQL Server, SSIS Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

Primary Skill- currently must have working in ETL testing, expertise in SSIS, SQL query writing, must have handled larger data stack range of 1 million and manual testing SQL & query optimization, ETL Testing & Validation, DB concepts, Testcase Development & Execution, Automation & Tools, Performance Testing & MonitoringStrong SQL Skills (Joins, subqueries, Aggregations, Window functions). Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables)Experience in SQL Server, SSIS Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

Primary Skill- currently must have working in ETL testing, expertise in SSIS, SQL query writing, must have handled larger data stack range of 1 million and manual testing SQL & query optimization, ETL Testing & Validation, DB concepts, Testcase Development & Execution, Automation & Tools, Performance Testing & MonitoringStrong SQL Skills (Joins, subqueries, Aggregations, Window functions). Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables)Experience in SQL Server, SSIS Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

Primary Skill- currently must have working in ETL testing, expertise in SSIS, SQL query writing, must have handled larger data stack range of 1 million and manual testing SQL & query optimization, ETL Testing & Validation, DB concepts, Testcase Development & Execution, Automation & Tools, Performance Testing & MonitoringStrong SQL Skills (Joins, subqueries, Aggregations, Window functions). Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables)Experience in SQL Server, SSIS Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

Primary Skill- currently must have working in ETL testing, expertise in SSIS, SQL query writing, must have handled larger data stack range of 1 million and manual testing SQL & query optimization, ETL Testing & Validation, DB concepts, Testcase Development & Execution, Automation & Tools, Performance Testing & MonitoringStrong SQL Skills (Joins, subqueries, Aggregations, Window functions). Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables)Experience in SQL Server, SSIS Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

Primary Skill- currently must have working in ETL testing, expertise in SSIS, SQL query writing, must have handled larger data stack range of 1 million and manual testing SQL & query optimization, ETL Testing & Validation, DB concepts, Testcase Development & Execution, Automation & Tools, Performance Testing & MonitoringStrong SQL Skills (Joins, subqueries, Aggregations, Window functions). Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables)Experience in SQL Server, SSIS Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

Primary Skill- currently must have working in ETL testing, expertise in SSIS, SQL query writing, must have handled larger data stack range of 1 million and manual testing SQL & query optimization, ETL Testing & Validation, DB concepts, Testcase Development & Execution, Automation & Tools, Performance Testing & MonitoringStrong SQL Skills (Joins, subqueries, Aggregations, Window functions). Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables)Experience in SQL Server, SSIS Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

Primary Skill- currently must have working in ETL testing, expertise in SSIS, SQL query writing, must have handled larger data stack range of 1 million and manual testing SQL & query optimization, ETL Testing & Validation, DB concepts, Testcase Development & Execution, Automation & Tools, Performance Testing & MonitoringStrong SQL Skills (Joins, subqueries, Aggregations, Window functions). Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables)Experience in SQL Server, SSIS Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

Primary Skill- currently must have working in ETL testing, expertise in SSIS, SQL query writing, must have handled larger data stack range of 1 million and manual testing SQL & query optimization, ETL Testing & Validation, DB concepts, Testcase Development & Execution, Automation & Tools, Performance Testing & MonitoringStrong SQL Skills (Joins, subqueries, Aggregations, Window functions). Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables)Experience in SQL Server, SSIS Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

Primary Skill- currently must have working in ETL testing, expertise in SSIS, SQL query writing, must have handled larger data stack range of 1 million and manual testing SQL & query optimization, ETL Testing & Validation, DB concepts, Testcase Development & Execution, Automation & Tools, Performance Testing & MonitoringStrong SQL Skills (Joins, subqueries, Aggregations, Window functions). Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables)Experience in SQL Server, SSIS Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

Project Role : Application Developer Project Role Description : Design, build and configure applications to meet business process and application requirements. Must have skills : Snowflake Data Warehouse Good to have skills : Snowflake Schema Minimum 5 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As an Application Developer, you will design, build, and configure applications to meet business process and application requirements. Your day will involve creating innovative solutions to address business needs and ensuring applications are tailored to meet specific requirements. Roles & Responsibilities:Implement snowflake cloud data warehouse and cloud related architecture. Migrating from various sources to Snowflake.Work on Snowflake capabilities such as Snow pipe, Stages, Snow SQL, Streams, and tasks.Implement snowflake advanced concepts like setting up resource monitor, RBAC controls, Virtual Warehouse sizing, zero copy clone.In-depth knowledge and experience in data migration from RDBMS to Snowflake cloud data warehouseDeploy the snowflake features such as data sharing, event, and lake house patterns.Implement Incremental extraction loads - batched and streaming.Must Have- Snowflake certification Professional & Technical Skills: Must To Have Skills:Proficiency in Snowflake Data Warehouse Good To Have Skills:Experience with Snowflake Schema Strong understanding of data warehousing concepts Experience in ETL processes and data modeling Knowledge of SQL and database management Ability to troubleshoot and debug applications Additional Information: The candidate should have a minimum of 5 years of experience in Snowflake Data Warehouse This position is based at our Hyderabad office A 15 years full-time education is required Qualifications 15 years full time education

Only immediate joiners based in Bangalore apply.Candidates must work from client office 3 days a week in Whitefiled. No relocation candidates Skills and Knowledge: Hands-on experience with Teradata: Proficiency in Teradata utilities (BTEQ, Fast Load, Multiload, and TPT for data loading), SQL, and data warehousing concepts. Deep knowledge of Teradata architecture: Understanding Teradata's architecture, including star schema, snowflake schema, and data modeling techniques. SQL optimization skills: Ability to write and optimize complex SQL queries for performance. ETL process development: Experience in designing and implementing ETL processes using Teradata utilities. Teradata performance tuning: Knowledge of performance tuning techniques, workload management, and partitioning strategies. Data warehousing concepts: Strong understanding of data warehouse concepts and best practices. Ensuring database security and availability: Implementing measures to protect data integrity and maintain system uptime. Database modeling and design: Creating and managing database structures, including star schema and snowflake schema. Troubleshooting and resolving performance issues: Identifying and addressing performance bottlenecks in the Teradata system. Collaborating with business analysts: Understanding data requirements and translating them into technical solutions. Creating and maintaining technical documentation: Documenting database designs, ETL processes, and other technical aspects.

AWS Data Engineer: ***************** As an AWS Data Engineer, you will contribute to our client and will have the below responsibilities: Work with technical development team and team lead to understand desired application capabilities. Candidate would need to do development using application development by lifecycles, & continuous integration/deployment practices. Working to integrate open-source components into data-analytic solutions Willingness to continuously learn & share learnings with others Required: 5+ years of direct applicable experience with key focus: Glue and Python; AWS; Data Pipeline creation Develop code using Python, such as o Developing data pipelines from various external data sources to internal data. Use of Glue for extracting data from the design data base. Developing Python APIs as needed Minimum 3 years of hands-on experience in Amazon Web Services including EC2, VPC, S3, EBS, ELB, Cloud-Front, IAM, RDS, Cloud Watch. Able to interpret business requirements, analyzing, designing and developing application on AWS Cloud and ETL technologies Able to design and architect server less application using AWS Lambda, EMR, and DynamoDB Ability to leverage AWS data migration tools and technologies including Storage Gateway, Database Migration and Import Export services. Understands relational database design, stored procedures, triggers, user-defined functions, SQL jobs. Familiar with CI/CD tools e.g., Jenkins, UCD for Automated application deployments Understanding of OLAP, OLTP, Star Schema, Snow Flake Schema, Logical/Physical/Dimensional Data Modeling. Ability to extract data from multiple operational sources and load into staging, Data warehouse, Data Marts etc. using SCDs (Type 1/Type 2/ Type 3/Hybrid) loads. Familiar with Software Development Life Cycle (SDLC) stages in a Waterfall and Agile environment. Nice to have: Familiar with the use of source control management tools for Branching, Merging, Labeling/Tagging and Integration, such as GIT and SVN. Experience working with UNIX/LINUX environments Hand-on experience with IDEs such as Jupiter Notebook Education & Certification University degree or diploma and applicable years of experience Job Segment Developer, Open Source, Data Warehouse, Cloud, Database, Technology