SQL Server Integration Services (SSIS) Jobs in Bangalore (Bengaluru)

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

We are looking for a Senior Software Engineer to implement functional software solutions. The goal will be to develop high-quality software/s that is aligned with user needs and business goals.Roles & Responsibilities :- Will own a complete platform from initial architecture, design of components, quality and deployment planning- Will act as an evangelist for the product platform. Identify right technologies for the business use cases. Will be involved in creation of user manuals, internal documents and customer API documentations.- Will understand requirements by studying information needs, discussing with the stakeholders, understanding workflow processes, data flows. Create design and architecture documents to explain, justify and evaluate design approaches.- Should be strong in design principles and have implemented them in existing projects.- Involved in troubleshooting existing applications in production. Identify and build tools for troubleshooting.- Will be involved in creating flowcharts and data flow diagrams. Will be involved in code review for peers. Should be able to identify and implement best practises.- Should be an advocate of automating daily tasks. Should have a high inclination towards building self managed systems.- Should be aware of the latest technology trends. Should participate in professional publications, conferences and events.- Will be involved in mentoring junior team members and aligning them towards company goals.- Identify and implement metrics for measuring platform stability and end user feedback.Requirements :- BS/MS degree in Computer Science/Information Science, Engineering or related field from reputed institute.- Experience of 4-7 Yrs- He/She has built distributed systems. Has the capacity to identify a problem and provide a solution- Has experience with scalable applications. Should identify probable bottlenecks and come up with approaches to mitigate them.- Has experience in working in cloud infrastructure. Should have exhibited capability in identifying and working with IaaS and PaaS providers.- Has a good understanding of OOPs and Functional programming concepts.- Has hands on working experience in one or more of the technologies like PHP (laravel, YII, Code Ignitor ), NodeJs (hapi.js express.js, socket.io), Golang, Java.- Have a working knowledge of web technologies like HTML, CSS and Javascript.- Has experience in identifying database solutions for a given problem. Should have experience working with one of RDBMS and NoSQL databases.- Has a good knowledge about API fundamentals.- Should have worked with third party APIs integrations.- Good written and verbal communication skills.- Should be a highly motivated and a quick learner.

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