Position Database Programmer DBP Experience 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 solid 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