Database Programmer (DBP)

Bengaluru - India

Monthly Salary: Not Disclosed

Posted on: Yesterday

Vacancies: 1 Vacancy

Job Summary

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 industrys 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

Essentialrequirements 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

Position : Database Programmer (DBP)Experience: 2 4 yearsEducation : Graduate Degree from any streamLocation : Bangalore IndiaAt Algonomy we believe the future of our economy is Algorithmic where businesses will develop resilient adaptive and agile decisioning abilities that will constantly test ...