SSIS Job Vacancies in Hyderabad

Shift Time: 7:30 PM to 4:30 AM (Night Shift) Must-Have:Proficiency in C# and Microsoft Power Apps.Strong experience with SQL Server and database management.Knowledge of web development and APIs.Expertise in Integration experience using tools like SSIS.API Development and troubleshooting.Hands-on experience with Azure Identity (Microsoft Entra ID).Send resume toanand@kpiconsulting.in

Position SSRS Developer Experience: 5-7 yearsSkillset: SQL Server SSIS/SSRS/SSAS, Data Modeling, MS Excel, pivot tablesResponsibilities:- Experience in SQL Server 2008 R2 or greater database tools and design.- Strong understanding of database structures/Data Modeling.- Working experiences in design and modeling normalized and dimensional - Develop reports using Microsoft Reporting Services (SSRS) from a variety of data sources including Analysis Services Cubes and relational databases.- Development of complex SQL Code (stored procedures, triggers, views, and functions)- Modify/Create/maintain and optimize ETL processes using SSIS.- Create Data extraction and Import programs using SSIS.- Interact with all stakeholders not limited to IT to ensure an accurate and comprehensive understanding of business requirements.- Liaise with network administrators, systems analysts, and software engineers to assist in resolving problems and provide issue escalation in a timely fashion.- Will work as part of the Database Management team to ensure data security and best practice adherence for all data.- Ensure design and development standards are current and being followed - Develop scalable solutions to meet business needs- Codes, tests, and debugs new software/applications or makes enhancements to existing software/applications.- Offers limited application recommendations for defined business needs.- Contributes to root cause analysis based on system and incident knowledge.- Works on assignments in resolving problems and making choices, recommendations, or decisions- Experience in Business Objects and other business intelligence platforms is an advantage.- Candidate should have excellent communication and facilitation skills.- Responsible for ETL Development and maintenance in the MS BI area.- The candidate will be expected to adhere to core hours, report work accomplished, and finish assigned tasks in a timely manner.Qualifications:- BE/B Tech in Computer

Roles and Responsibilities1. Execute and lead the requirements gathering process to define and document the functional requirements for RPA solutions.2. Develop and document process flows, use cases, and other artifacts to support RPA solution design.3. Develop test plans, scenarios, scripts, and other documentation to support the development of RPA solutions.4. Coordinate with stakeholders to ensure RPA solutions meet business needs.5. Act as a liaison between the IT team and the business to ensure that RPA solutions are designed and implemented in line with the business requirements.6. Monitor and report on RPA project progress, performance, and issues.7. Analyze existing processes and recommend ways to improve process efficiency using RPA solutions.8. Research emerging RPA technologies and trends and recommend potential solution opportunities.9. Develop and maintain comprehensive business process, data, and system models for RPA solutions.10. Train and mentor other team members in the use of RPA technologies and processes.Skills1. Problem solvingMaking fact based decisions to solve problemsIdentifying and anticipating problemsWorking with others to solve problemsImplementing solutions2. Business partneringBusiness partnerBusiness acumen3. RPAUIPathAutomation AnywhereBlue Prism4. DatabaseSQLMySQLMongoDB

SQL LeadThe SQL Developer will be responsible for developing applications and integrations using the Microsoft SQL Server platform. This will include reports, vendor imports, data warehousing tasks and other data related tasks. This position requires good communication and technical skills.Required Skills 1. Experience of 12+ years2. Microsoft SQL Server 2008 and above server side development3. Knowledge of tools like Tableau and/or any other data visual tools4. T-SQL (Transact SQL) Stored Procedures, Functions and Triggers5. Need to have good understanding of performance tuning6. Understanding .NET code/.net development experience is a plusResponsibilities: 1. Excellent design skills for coming up with the schema that can be usable across multiple customers2. Design and develop T-SQL procedures, query performance tunings and SSIS packages.3. Develop underlying data models and databases.4. Develop, manage and maintain data dictionary and or metadata.5. Ensure compliance of standards and conventions in developing programs.6. Design, develop and implement complete life cycle of data warehouses.7. Translate business requirements into software applications and models.8. Analyze and resolve complex issues without over sight from other people.9. Perform and execute data extraction, transformation and loading using ETL tools.10. Maintain and enhance the existing data warehouse, exports, and reports11. Perform quality checks on reports and exports to ensure exceptional quality12. Create and maintain documentation for all projects

Job Description :Senior MSBI Developer (SSIS) - BangaloreExperience required : 6 to 8 yearsLooking for immediate joiner (Work from home )SSIS with BFSI DomainLocation : Bangalore/ RemoteEducational : Any graduation- 6-8 years of work experience in designing and maintaining SSRS/SSIS environments Integrating, Migration, and conversions experience- Good experience in SSRS reports conversions of SSRS reports into crystal reports- Good experience in Architecture, team handling, and architecture flows.- Strong understanding and experience with Microsoft SQL Server database platform and SQL Server reporting and Analytics Services (SSRS, SSAS, and SSIS)- Hands-on experience with business intelligence, data architecting, data mining, large-scale data modeling, and business requirements gathering/analysis.- Good experience/ Knowledge of admin ,Data modeling in OLAP plus working technical knowledge of current systems software, protocols, and standards, including SQL, TSQL, ODBC, .NET, and Business Intelligence Standards- Expert experience in creating and using store procedures, views and user-defined functions- Well experience in Data Extraction, Transforming, and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS)- Develop Queries for generating drill down reports in SSRS latest version- Experience in working on SSRS Upgrade Projects (Upgrade from old version to new) Strong aptitude for modern BI solution development using Power BI and SQL Server- Deep Understanding of dimensional data modeling concepts as well as data warehouse design and lifecycle management principles- Collaborate with Performance Improvement, Quality Systems, and stakeholders to analyze and define data requirements needed to support the business processes; verify accurate data reporting; and integrate the data requirements throughout the data systemsNeed Immediate joiners or 15 days notice period.

Job Title: BI DeveloperSummary of Position:As part of the Business Analytics team, you will develop enterprise-level business intelligence solutions using the latest tools, methods, and frameworks. We seek a candidate who excels at innovation and creativity, converting data into information and information into insights to help our end users make informed business decisions. A successful candidate has strong analytical skills and technology experience working with business intelligence tools and is passionate about using data to drive decision-making.Essential Functions: Own the design, development, and maintenance of BI dashboards and reports Design, implement, maintain and improve data warehousing Design models for the data warehouse, data marts, and data integration Identify, analyze and interpret trends or patterns in complex data sets, and create quantitative models that tie to business results Create models for predictive analytics Write high-quality code to retrieve and analyze data Ensure data accuracy by validating data for new and existing tools Work with developers to aggregate large data sets for use within BI solutions Develop, design, and optimize complex SQL queries Participate in database analysis, design, and build effort Participate in product design and code reviews Competencies: Strong knowledge and experience using BI platforms and analytics tools (SiSense, Qlik, TIBCO Jaspersoft, Salesforce, Microsoft Power BI, Pandora, Tableau, Google Analytics, SSRS, etc.) Exceptional data problem solving and business communication skills Strong analytical skills with the ability to collect, organize, and disseminate significant amounts of information with attention to detail and accuracy Strong proficiency in relational database design and administration Education and Experience: Minimum a Bachelor Degree in Computer Science or Mathematics and Data Sciences with relevant work experience 2+ years of working experience

Required Qualifications Bachelors degree in Computer Science, Information Systems, or equivalent work experience 5+ years experience in building ETL jobs and Reports using SSIS Packages and SSRS 5+ years experience with Microsoft Development platform using .NET framework technology, Visual Studi.NET, C# Strong SQL skills including writing Stored Procedures in SQL Server Experience in data migration projects Strong trouble shooting skills - reviewing coding, debugging Experience in developing/integrating with Web Services - REST, SOAP, XML, JSON is helpful Excellent analytical and problem solving skills Strong verbal and written communication skillsDesired Skills Any experience (coding, understanding database schema) in NetSuite, Ivanti, GP, CRM is helpful Experience in ERP (preferably NetSuite) and including loading data Experience in Agile development