The MSBI Developer provides solutions using the most appropriate Microsoft and SQL BI feature and should have a solid understanding of the architecture, features available and limitations of various SQL BI solutions. He/ She will also be playing DBA role and responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications. Responsibilities: Work with a SQL Server\Microsoft stack-based Business Intelligence System Develop SSIS ETL packages based on business requirements Develop Business Intelligence solutions using Multidimensional and Tabular Cube technologies Assist in DBA responsibilities, backups, performance tuning, troubleshooting Identifying opportunities for Automation and implement them through required approval Complex query tuning and schema refinement. Responsible for reviewing requirements, contributing to design components of ongoing and upcoming projects, and effectively estimating development effort Responsible for developing and documenting the systems, processes and logic required to build system to system integrations Responsible for contributing to data modelling/database design efforts Responsible for delivering quality data integration projects Responsible for hands on development using SSIS and ETL tools and processes Lead and recommend viable solution for Azure implementation methodology (as required) Stay up-to-date on techniques and components being used in the industry through research and applies this knowledge to systems being developed Pro-actively identifying changes needed in the environment lifecycle and make recommendations for improvements with the subsequent implementation Monitor ETL applications for performance and improvement opportunities Ensure the quality, consistency and security of company data and data warehouse systems Requirements: 4 - 7 years SQL Server Development experience required (SQL Server 2014 onwards) Deep understanding of SQL Server Integration Services Knowledge of optimisation techniques for both SSIS and SQL Familiar with Data Warehouse concepts and experience with Star Schema a plus Knowledge of data modelling and designing databases XML, JSON, PowerShell, Rest API experience Good knowledge in Azure implementation Good knowledge in Dashboarding through Power BI or any other equivalent tools. Good knowledge of metadata, and using/managing metadata Experience with SQL Server Analysis services, Tabular and Multidimensional Experience with Performance Tuning and Optimisation (PTO), using native monitoring and troubleshooting tools Experience with backups, restores and recovery models. Experience with Redgate Backup tools a plus Excellent written and verbal communication Flexible, team player, get-it-done personality Ability to organise and plan work independently Ability to work within an Agile and ITIL framework Ability to multi-task and context-switch effectively between different activities Microsoft certifications a plus Experience with API based integrations a plus (we use various cloud applications as data sources)
About Increasingly:Increasingly is an award-winning, fast-growing retail technology company focused specifically on the automation of cross-selling for online retailers. Our clients include large global corporations like Samsung & Canon to several small to medium size retailers across the globe. Our AI-based algorithms help a customer buying a TV on Samsung to find the matching soundbar & purchase both together. Increasingly is headquartered in London with offices in Lisbon & Bangalore. We work with clients in over 30 countries & 20 languages.We are looking to rapidly expand our technology & product development operations in India. And we need smart, ambitious people like you who enjoy a fun yet challenging work environment. We believe strongly that diversity & inclusion are the foundations for a lasting, incredible culture. We also believe that it's important to get the balance right between work & life.The job and its impact:- Be solely responsible for designing databases and ensuring their stability, reliability, and performance. Ensure that the database system is efficient and error-free. - Optimize your queries when a website is too slow due to database performance, write queries for heavy traffic databases, and design tables and indexes for the best database architecture and performance.- Lead a team of developers and successfully solve issues and make improvements to databases, while ensuring all work meets the necessary requirements.- Learn new technology. There's a ton of stuff in there that falls outside the classical SQL model, and learning how to use it will improve your craft.- Find a problem to solve and don- t be afraid to fail. Learn by making mistakes.- Be fluent in the current technology and able to learn how to correctly utilize new technology, often on the fly. As a result, you are must be the most versatile member of any team.- Everything changes so fast the fundamentals you learned five or 5 years ago may no longer be applicable. Architect skills. Developers must be architects these days. Understand the big picture of mapping. Try to find the next set of standards.What essential skills you need:- Schema design, data modeling, data upgrades, develop distributed and highly scalable applications with a focus on scalability performance availability reliability security and maintainability of the applications or technologies.- Code review, SQL query tuning, SQL patches, ownership, attention to detail ad-hoc queries & automation in support of internal and external customers data exchange and integration needs.- Research, troubleshoot, and resolve data issues impacting extract delivery, application design enhancements, development, debugging, and optimization with respect to data concerns and new product features.- Cloud-managed database engines such as Amazon RDS. NoSQL solutions such as Redis, Cassandra, MongoDB, make regular recommendations for system improvements.- Extensive experience with backups monitoring performance tuning and troubleshooting tools & techniques. Ability to identify bad SQL statements & optimize them.- Support QA & development team in project queries, test plans and test cases to improve the database with an ability to communicate effectively within a team.- Self-starter collects data, analyzes the collected information, designs algorithms, draws flowcharts and then implements code for the logic developed through algorithms and flowcharts.What are the benefits:- You'll get to work in one of the hottest & fastest growing retail technologies in Europe right now. - You'll get paid a competitive salary & be working directly with a super experienced team of people. - You'll get a great place to come to work every day. Varied, complex, challenging & with a great culture that you can shape & change.
Exciting opportunity for any contractor to work with a start-up firm which is into product cum service based industry. We are looking for someone who has got rich experience in below mentioned skills to join us immediately.This role is for 1 month where the person will be working from Client site in Paris to understand the system architecture and documenting them. Contract extension for this role will be purely on the performance of individual. Since the requirement is immediate and critical, we need someone who can join us soon and travel to Paris in December- Hands on experience handling multiple data sources/datasets- experience in data/BI architect role- Expert on SSIS, SSRS, SSAS- Should have knowledge writing MDX queries- Technical document preparation- Should have excellent communication- Process oriented- Strong project management- Should be able to think Out of the Box and provide ideas to have better solutions- Outstanding team player with positive attitude
Power BI Experience: 2-3 years Skills: Power BI Start date : Looking out for Immediate Joiners Contract position for 3 months Location Bangalore Job Designation Power BI Developer : 1. To Develop Power BI reports & effective dashboards after gathering and translating end user requirements. 2. To have Ability to turn large amounts of raw data into actionable information. 3. Be responsible for the performance and usability of the system 4. To Perform optimization of MS SQL Queries and SSIS packages 5. To Provide solutions using SSAS cubes (Tabular/Multidimensional Models) 6. Must have excellent experience in MS SQL Server - writing queries, joints, stored procedures, functions etc Candidate should have the knowledge of: Power BI with DAX query, Multiple Data Sources and Relationships of data Power BI Architecture Data modelling, Calculations, Conversions, Scheduling Data refreshes in Power BI Desktop Hands-on professional with thorough knowledge of scripting, data source integration and advanced GUI development in Power BI. Familiar with Power BI custom add-on development & deployment. Connecting Power BI with on-premise and cloud computing platforms. To provide optimized SQL Scripts for complex scenarios Business Intelligence Systems & Tools (Microsoft Power BI, SQL Server Reporting Services) Good understanding of the processes of data quality, data cleansing and data transformation
Position – SQL Developer /Sr.SQL Developer with 4-8yrs experience Who Should apply? Only for Serious job seekers Technically Strong Candidates who are willing to take up challenging roles and want to raise their Career graph. Why Think n Solutions Software? Exposure to latest Technology. Opportunity working in different platforms Direct client interaction Rapid Career Growth Friendly Knowledge sharing Environment Criteria: BE/MTech/MCA with Min 70% GPA 4-8yrs Hands on Experience in TSQL Immediate joiners preferred/ Maximum notice period of 1 month Candidates will be selected based on logical / technical and scenario-based testing Note: Candidates who have attended the interview process with TnS in the last 6 months will not be eligible. Job Description: 1. Technical Skills Desired: o Writing SQL Server / PostgreSQL stored procedures in an application development environment. o Design database tables, views, indexes, functions and develop the various reports using SQL and Stored Procedures. o Work with other front-end developers in completing the database modules end to end (experience in parsing of JSON in Stored Procedures would be an added advantage). o Query optimization for performance improvement. o Design & develop SSIS Packages, SQL Procedures, and Transform data from different data sources. 2. Functional Skills Desired: o Banking / Insurance / Retail domain is a plus. o Interaction with a client a plus. 3. Add on Skills Good to Have: o Knowledge on Mongo DB o Experience in some version control system is a plus o Exposure to Quality and process Management o Knowledge in Agile Methodology Company: Think n Solutions Software Pvt Ltd Work Location: HSR Layout, Bangalore Send Resumes to: hr-indiaatthinknsolutionsdotcom