Senior Data Warehouse Developer
2 weeks ago
Ideal candidate for this role will not only help us procure, curate and model various transactional data but also turn it into information, generating insights and aid in business decisions based on the analytical results. Incumbent's responsibilities will include conducting full development lifecycle — requirements, analysis, development, testing and production deployment whilst managing various everyday data warehouse related processes (SSIS, SSRS, SSAS) and MS SQL Server performance.
We expect you to possess analytical mindset with creative approach to tasks and experience in working with entire Microsoft BI stack with sound understanding of SQL Server and advanced SQL tuning for performance.
A typical day as a senior data warehouse developer:-
Design and develop ETL and reporting processes using SSIS/SSRS tools based on established enterprise standards
-
Engage with business units to gather requirements and perform iterative data analysis in a fast paced agile environment
-
Architect SQL Server database structures and objects, fine tune SQL queries for performance and monitor latencies during batch processes
-
Identify, analyze, and interpret trends or patterns in complex data sets
-
Design and develop reports, and flat file extracts for consumption by business users and external vendors
-
Collaborate with management to prioritize business and information needs
-
Find and evaluate new process improvement opportunities
8+ years' experience of working as a data warehouse developer or ETL specialist with a deep understanding of relational databasesSolid experience of working with data models, database design development, performance tuning techniques
Solid experience in working with voluminous databases, creating database objects and tuning complex SQL queries for performance
Solid experience using ETL and reporting tools like SSIS, SSRS, SSAS, Informatica and Business Objects
Strong analytical thinking is vital to succeed in this role. You will be constantly asked to understand the business premise before employing your technical skills
Ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
Good knowledge of documentation and code versioning
Good knowledge of working with enterprise automation tools
BS degree in Computer Science or relevant experience in lieu of a college degree for exceptional candidates
Complimentary skills sets like background in Java programming, Python and/or experience in other databases like Oracle, Netezza, Mongo DB, Teradata is a huge plus
-
Senior Data Migration Developer
1 week ago
Chicago, IL, United States eTeam Full timeTitle: Data Migration Developer(Netezza to Snowflake) Location: Remote Duration: 6 Months of ContractMust-Have Skills: Strong hands-on experience with Python or Jython scripting for data extraction and synchronization Proficiency with Stream Sets for orchestration, scheduling, and automation of data pipelines Advanced knowledge of Snowflake, including...
-
Data Warehouse ETL Developer
1 week ago
Chicago, IL, United States Georgia IT Inc Full timeData Warehouse ETL Developer - Remote Skills for Data Warehouse ETL Developer (with Informatica tool): Data Warehousing: Strong understanding of data warehousing concepts and architectures. Data Modeling: Understanding of dimensional data modeling principles including ETL Tools Proficiency: Expertise in Informatica PowerCenter and Power Exchange. ...
-
Data Warehouse ETL Developer
2 days ago
Chicago, IL, United States Georgia IT Inc Full timeData Warehouse ETL Developer - Remote Skills for Data Warehouse ETL Developer (with Informatica tool): Data Warehousing: Strong understanding of data warehousing concepts and architectures. Data Modeling: Understanding of dimensional data modeling principles including ETL Tools Proficiency: Expertise in Informatica PowerCenter and Power Exchange. ...
-
Day Warehouse Lead
6 days ago
Chicago, IL, United States Chefs’ Warehouse Full timeThe Chefs' Warehouse The Chefs' Warehouse, Inc. combines exceptional quality and brand building with broadline food service distribution for more than 35 years. With Protein, Specialty, Produce, and Broadline offerings, we service the most discerning chefs in a hybrid approach of convenience and superior quality. We introduce more than 2,000 artisan...
-
Day Warehouse Lead
6 days ago
Chicago, IL, United States Chefs’ Warehouse Full timeThe Chefs' Warehouse The Chefs' Warehouse, Inc. combines exceptional quality and brand building with broadline food service distribution for more than 35 years. With Protein, Specialty, Produce, and Broadline offerings, we service the most discerning chefs in a hybrid approach of convenience and superior quality. We introduce more than 2,000 artisan...
-
Day Warehouse Lead
6 days ago
Chicago, IL, United States Chefs’ Warehouse Full timeThe Chefs' Warehouse The Chefs' Warehouse, Inc. combines exceptional quality and brand building with broadline food service distribution for more than 35 years. With Protein, Specialty, Produce, and Broadline offerings, we service the most discerning chefs in a hybrid approach of convenience and superior quality. We introduce more than 2,000 artisan...
-
Day Warehouse Lead
1 week ago
Chicago, IL, United States Chefs’ Warehouse Full timeThe Chefs' Warehouse The Chefs' Warehouse, Inc. combines exceptional quality and brand building with broadline food service distribution for more than 35 years. With Protein, Specialty, Produce, and Broadline offerings, we service the most discerning chefs in a hybrid approach of convenience and superior quality. We introduce more than 2,000 artisan...
-
Day Warehouse Lead
1 week ago
Chicago, IL, United States Chefs’ Warehouse Full timeThe Chefs' Warehouse The Chefs' Warehouse, Inc. combines exceptional quality and brand building with broadline food service distribution for more than 35 years. With Protein, Specialty, Produce, and Broadline offerings, we service the most discerning chefs in a hybrid approach of convenience and superior quality. We introduce more than 2,000 artisan...
-
Day Warehouse Lead
1 week ago
Chicago, IL, United States Chefs’ Warehouse Full timeThe Chefs' Warehouse The Chefs' Warehouse, Inc. combines exceptional quality and brand building with broadline food service distribution for more than 35 years. With Protein, Specialty, Produce, and Broadline offerings, we service the most discerning chefs in a hybrid approach of convenience and superior quality. We introduce more than 2,000 artisan...
-
Day Warehouse Lead
1 week ago
Chicago, IL, United States Chefs’ Warehouse Full timeThe Chefs' Warehouse The Chefs' Warehouse, Inc. combines exceptional quality and brand building with broadline food service distribution for more than 35 years. With Protein, Specialty, Produce, and Broadline offerings, we service the most discerning chefs in a hybrid approach of convenience and superior quality. We introduce more than 2,000 artisan...