SQL Server Integration Services (SSIS) Jobs in Bangalore (Bengaluru)
Exp-8-12 Years
Job location-Hyderabad, Bengaluru, Mumbai, Pune and Goa
CTC – As per market standard
Notice Period-Max 15 -30 days joiners
Responsibilities:
- Work with Database Architect to understand the design considerations for the BI Next Gen Data Warehouse.
- Take accountability of the development / update of the DW Database Objects and Code as per the requirement.
- Take accountability of the development / update of the PowerBI and SSRS Reports.
- Take accountability of Unit Testing the developed solution.
- Be available for weekend job monitoring and troubleshooting, as necessary.
- Ensure that all delivery timelines are adhered to.
- Work with QA (Testing) team to test the DW / Report Solution and fix as necessary.
Job Requirements:
- 8 - 10 years of experience in SQL Server database development.
- Excellent understanding of SQL Server 2016 and above.
- Excellent understanding of T-SQL. Must have the ability to analyze, debug and write complex T-SQL code.
- Very good hand-on knowledge on query tuning and performance optimization.
- Excellent understanding of SQL Server Integration Services and SQL Server Reporting Services.
- Excellent understanding of PowerBI.
- Should be completely aware of coding standards and should be able to develop high performance & scalable database applications.
- Exceptional Problem Solving and Analytical Skills.
Excellent communication skills (oral and written).
Criteria:
- BE/MTech/MCA/MSc
- 3+yrs Hands on Experience in TSQL / PL SQL / PG SQL or NOSQL
- Immediate joiners preferred*
- 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 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
- 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
- Interaction with a client a
3. 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 requirements
Think out-of-box for business solution
SQL Server DBA duties and responsibilities
- Experience in both sql server DBA and DBA developer
• Configure and maintain database servers and processes
• Monitor system's health and performance
• Ensure high levels of performance, availability, sustainability and security
• Analyze, solve, and correct issues in real time
• Provide suggestions for solutions
• Refine and automate regular processes, track issues, and document changes
• Assist developers with query tuning and schema refinement
• Perform scheduled maintenance and support release deployment activities
• Database programming skills(writing and understanding Procedures , scripts..)
Good to have experience to SSIS,SSAS SSRS or any reporting tools.
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
• 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
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)
· 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
This position is for Oracle Golden Gate developer and DBA.
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
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
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