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……
At PureSpectrum we are continuously focused on our culture, which is rooted in innovation, connection, and providing an exceptional experience at all business……
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
The minimum salary is ₹5L and the max salary is ₹10L.
₹5L – ₹10L/yr (Glassdoor Est.)
₹7L
/yr Median
Bengaluru
If an employer includes a salary or salary range on their job, we display it as "Employer provided". If a job has no salary data, Glassdoor displays a "Glassdoor estimate" if available. To learn more about "Glassdoor estimates", see our FAQ page.
Working here doesn’t have to be a secret
Sign in to browse authentic reviews, anonymous ratings and salary data before you apply.