Database Programmer (DBP)

2 – 4 years Education : Graduate Degree from any stream Location : Bangalore, India At Algonomy, we believe the future of our economy is Algorithmic, where businesses will develop resilient, adaptive and agile decisioning abilities that will constantly test and refine AI-driven actions to create the best personal experience for every individual customer at scale. We aim to become the algorithmic bridge between consumers and brands/retailers, and to lead our customers through the Algorithmic transformation imperative. The name Algo-nomy signifies an expertise in algorithms. As technology evolves our lives (and our clients’) at hyper-speed, Algonomy stands as a bold, creative and agile brand; and these are also the very qualities that every digital-first business needs in order to be successful in the new normal. We are ambitious, we create category leading solutions in our markets, and we are constantly learning, inventing and adapting to stay ahead of our industry’s needs Broad Responsibilities Key individual contributor to the Product Deployment team Will need to perform ETL, ETL performance tuning Will be required to do fine tuning of complex queries of analytical database warehouse The role will require good knowledge of database and data warehouse architecture Will need to work effectively with other team members and share best practices Will need to work closely with Team Members, Team Leads, including Business Analysts, and Quality Assurance, and Project Managers Essential requirements for the role Minimum 4 years of relevant hands-on experience in design & develop data warehouse and database programming. SQL & DB Programming: In-depth knowledge of T-SQL / PL-SQL Programming, performance tuning of complex queries Knowledge in creating various database objects - Stored Procedures, User Define Functions, Views, indexes ETL: Design and develop Scripts and Programs required to extract, transform, clean, and move data, in a manner that quality data can be loaded into the Data Warehouse. This will require previous experience in “incremental and history data load” Will need ETL performance handling experience using MS - SSIS/any standard ETL Tool and strong in handling large volume of data extraction and loading (500gb to 5tb) Should have above average skills in ETL, ETL performance tuning as well as above average skills in fine tuning complex queries of analytical Database Warehouse etc DW & BI: Should have designed and developed small to medium Data Base/Data Warehouses Should have been part of at least 1-2 end to end BI projects or product deployments Should have good skills in logical and physical design of Data Base & Data Warehouse as well as logical & physical data model according to the customer deployment scenarios & scope Nice to have Experience in SSRS/SSAS 2005/2008 and knowledge of standard BI tools which is an added advantage Retail / CPG domain exposure