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

*Apply only if you are serving Notice Period

HIRING SQL Developers with max 30 days Of NOTICE PERIOD

Job ID: TNS2022DB08

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
• No DBA’s & BI Developers please
Why Think n Solutions Software?
• Exposure to latest Technology
• Opportunity working in different platforms
• Rapid Career Growth
• Friendly Knowledge sharing Environment

Criteria:

• BE/MTech/MCA/MSc
• 3+yrs Hands on Experience in TSQL / PL SQL / PG SQL or NOSQL
• Immediate joiners preferred/ Maximum notice period between 15 to 30days
• 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:
a. Experience in MS SQL Server and one of these Relational DB’s, PostgreSQL / AWS
Aurora DB / MySQL / Oracle / NOSQL DBs (MongoDB / DynamoDB / DocumentDB) in
an application development environment and eagerness to switch DB.
b. Design database tables, views, indexes
c. Write functions and procedures for Middle Tier Development Team
d. Work with any front-end developers in completing the database modules end to end
(hands-on experience in parsing of JSON & XML in Stored Procedures would be an
added advantage).
e. Query Optimization for performance improvement
f. Design & develop SSIS Packages or any other Transformation tools for ETL
2. Functional Skills Desired:
a. Banking / Insurance / Retail domain would be a plus.
b. Interaction with a client a plus.
3. Good to Have Skills:
a. Knowledge in a Cloud Platform (AWS / Azure)
b. Knowledge on version control system (SVN / Git)
c. Exposure to Quality and Process Management
d. Knowledge in Agile Methodology
4. Soft skills: (additional)
a. Team building (attitude to train, work along, mentor juniors)
b. Communication skills (all kinds)
c. Quality consciousness
d. Analytical acumen to all business requirement
e. Think out-of-box for business solution

Technical Skills
Mandatory (Minimum 4 years of working experience)
 3+ years of experience leading data warehouse implementation with technical architectures , ETL / ELT ,
reporting / analytic tools and scripting (end to end implementation)
 Experienced in Microsoft Azure (Azure SQL Managed Instance , Data Factory , Azure Synapse, Azure Monitoring ,
Azure DevOps , Event Hubs , Azure AD Security)
 Deep experience in using any BI tools such as Power BI/Tableau, QlikView/SAP-BO etc.,
 Experienced in ETL tools such as SSIS, Talend/Informatica/Pentaho
 Expertise in using RDBMSes like Oracle, SQL Server as source or target and online analytical processing (OLAP)
 Experienced in SQL/T-SQL/ DML/DDL statements, stored procedure, function, trigger, indexes, cursor
 Expertise in building and organizing advanced DAX calculations and SSAS cubes
 Experience in data/dimensional modelling, analysis, design, testing, development, and implementation
 Experienced in advanced data warehouse concepts using structured, semi-structured and un-structured data
 Experienced with real time ingestion, change data capture, real time & batch processing
 Good knowledge of meta data management and data governance
 Great problem solving skills, with a strong bias for quality and design excellence
 Experienced in developing dashboards with a focus on usability, performance, flexibility, testability, and
standardization.
 Familiarity with development in cloud environments like AWS / Azure / Google

Good To Have (1+ years of working experience)
 Experience working with Snowflake, Amazon RedShift
Soft Skills
 Good verbal and written communication skills
 Ability to collaborate and work effectively in a team.
 Excellent analytical and logical skills

Why Think n Solutions Software?
• Exposure to latest Technology
• Opportunity working in different platforms
• Rapid Career Growth
• Friendly Knowledge sharing Environment

Criteria:
• BE/MTech/MCA/MSc
• 3+yrs Hands on Experience in TSQL / PL SQL / PG SQL or NOSQL
• Immediate joiners preferred/ Maximum notice period between 15 to 30days
• 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:
Technical Skills Desired:

• Experience in either of these Relational DB’s MS SQL Server / PostgreSQL / AWS Aurora DB / MySQL / Oracle / NOSQL DBs (MongoDB / DynamoDB / DocumentDB) in an application development environment and eagerness to switch DB.
• Design database tables, views, indexes
• Write functions and procedures for Middle Tier Development Team
• Work with any front-end developers in completing the database modules end to end (hands-on experience in parsing of JSON & XML in Stored Procedures would be an added advantage).
• Query Optimization for performance improvement
• Design & develop SSIS Packages or any other Transformation tools for ETL

Functional Skills Desired:

• Banking / Insurance / Retail domain would be a plus.
• Interaction with a client a plus

Good to Have Skills:

• Knowledge in a Cloud Platform (AWS / Azure)
• Knowledge on version control system (SVN / Git)
• Exposure to Quality and Process Management
• Knowledge in Agile Methodology

Soft skills: (additional)

• Team building (attitude to train, work along, mentor juniors)
• Communication skills (all kinds)
• Quality consciousness
• Analytical acumen to all business requirement
• Think out-of-box for business solution

Job Description:

Candidate need to handle the ticket raised by the team, where they asked to perform the operations on database. Once ticket get’s solved they need to update team for the same.

What would be the key responsibilities expected out of this role

1) Help write and optimize in-application SQL statements

2) Ensure performance, security, and availability of databases

3) Prepare documentations and specifications

4) Handle common database procedures such as upgrade, backup, recovery, migration, etc.

5) Good in DML and DDL

Must Have Skills:

MS-SQL 

Good To Have Skills: 

SSIS & SSRS Or MSBI

Notice Period: 

15 Days - 30 Days (Immediate Joiners Preferred)

· Extensive experience in Appian BPM application development
· Knowledge of Appian architecture and its objects best practices
· Participate in analysis, design, and new development of Appian based applications
· Team leadership and provide technical leadership to Scrum teams
· Must be able to multi-task, work in a fast-paced environment and ability to resolve problems faced
by team
· Build applications: interfaces, process flows, expressions, data types, sites, integrations, etc.
· Proficient with SQL queries and with accessing data present in DB tables and views
· Experience in Analysis, Designing process models, Records, Reports, SAIL, forms, gateways, smart
services, integration services and web services
· Experience working with different Appian Object types, query rules, constant rules and expression
rules
Qualifications
· At least 3 years of experience in Implementing BPM solutions using Appian 19.x or higher
· Over 8 years in Implementing IT solutions using BPM or integration technologies
· Certification Mandatory- L1 and L2 a
· Experience in Scrum/Agile methodologies with Enterprise level application development projects
· Good understanding of database concepts and strong working knowledge any one of the major
databases e g Oracle SQL Server MySQL
Additional information
Skills Required
· Appian BPM application development on version 19.x or higher
· Experience of integrations using web services e g XML REST WSDL SOAP API JDBC JMS
· Good leadership skills and the ability to lead a team of software engineers technically
· Experience working in Agile Scrum teams
· Good Communication skills

Job Description.

DB developer 

 

This position is for Oracle Golden Gate developer and DBA position. The Candidate will implement and support Oracle Golden Gate replication components across many databases. Working closely with many application teams and implementing near real time replications with golden gate. Candidate should provide operational support as well.

 

Roles and responsibilities :

 

Configure and build Golden Gate Extracts/replicate for multiple databases.

 

Configure error handling for restart, logging, production support and status reporting in Golden Gate.

 

Identify and produce documentation of best practices.

 

Trouble shooting and performance tuning Golden Gate replications.

 

Implementing necessary monitoring scripts for Golden Gate in UNIX/PERL scripting

 

 

Provide Golden Gate solutions :

 

- Working with Oracle on SRs for critical issues.

 

- Strong oral and written communication skills along with problem solving skills.

 

 

Individual with min experience of over 5+ years on SQL Server

 

• Good Experience in SQL Server Installation and Configuration
• Backup and Recovery
• Security management
• Troubleshooting & Monitoring
• SSIS/SSRS/SSAS

5+ Yrs in SSIS, SQL
Bangalore
Immediate

• Design, build and deploy effective SSIS packages to validate, synthesize, transform customer data for integrated business planning and analytics
• Understand platform’s data model (table structures, linkages, optimal designs) for designing various planning use cases
• Review and analyse the data provided by customers along with its technical/functional intent and interdependencies
• Participate in the technical design, data requirements gathering and making recommendations on best practices, in case of inaccurate or missing data
• Design and automate the data loading and insights generation process with intelligent checks and balances for sustained value delivery
• Create and execute test plans,document issues and track progress at resolving issues.

Job Requirement – Sr. SQL _PBI Developer

• Minimum 6+ years of expertise in SQL Database Development including SQL queries, data structures, stored procedures, index etc.
• Excellent written and verbal communication
• Advanced knowledge and experience in T-SQL coding: query writing, stored procedures, triggers and user-defined functions.
• Advanced knowledge and experience in development and maintenance of SSIS and SSAS (Tabular and Multidimensional)
• Advanced knowledge and experience in creating dashboards and reports using PowerBI
• Advanced knowledge and experience in DAX
• Experience in creating and publishing reports using SSRS
• Experience in writing MDX queries
• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Optimize and manage SQL server databases
• Independently analyse, solve, and correct issues in real time, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
• Flexible, team player, “get-it-done” personality
• Ability to organize and plan work independently
• Ability to work in a rapidly changing environment
• Ability to multi-task and context-switch effectively between different activities and teams

Optional Skills (Good to have):

• Microsoft certification in Azure data engineering

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.