Business Intelligence Developer
at Symansys Technologies India Pvt Ltd
Experience: 6-9 yrs
Location: NoidaJob Description:
- Must Have 3-4 Experience in SSIS, Mysql
- Good Experience in Tableau
- Experience in SQL Server.
- 1+ year of Experience in Tableau
- Knowledge of ETL Tool
- Knowledge of Dataware Housing
Similar jobs
Minimum of 4+ years of experience as a backend developer.
In-Depth knowledge and experience with C#, .NET Core is must.
Experience in working with API Gateways, REST, OAuth, Rabbit MQ and Microsoft ecosystem technologies.
Experience with databases like Oracle, SQL lite, PostgreSQL etc.
Experience with microservices architecture is a must, and experience over any public cloud(Azure preferred) is an added advantage.
Experience and understanding of OOPS and SOLID design principles and various design and architectural patterns.
Experience in Test Driven Development and automated testing tools like NUnit and SonarQube.
Strong communication and collaboration skills to work effectively with cross-functional teams.
Executive - SAP BASIS
- Required Skill - Operating systems & Tools (SUSE Linux 1 IBM AIX 1 IBM Spectrum i.e. IBM Tivoli)
- Should be experienced in administration of SUSE Linux, IBM AIX operating systems Have hands-on experience in managing & troubleshooting IBM Tivoli (Spectrum Protect) backup utility with SAP HANA & Sybase DB environment.
- Monitor status of BACKUPs, perform need based restore when require.
- Report & coordinate with team lead for incident management process. Take corrective actions for incidents related to OS & backup related issues.
- Desirable Skills - SAP NetWeaver BASIS Administration
- SAP user management for ABAP & Java stacks, Business Objects, Central User Management, etc.
- Maintain Roles and Authorization using PFCG
- SAP Transport Management using ST MS and ChaRMs
- Knowhow of using SAP Solution Manager for MoPZ, ITSM, CHARMS, CUA, EWA, System Monitoring and Technical Administration
- BASIS administration (monitoring & maintenance) of SAP systems at Primary & DR-sitesMonitor & Troubleshoot the performance of SAP systems, Troubleshoot issues and follow-up with End Users and Development team to resolve the issues.
- Data Volume Management activities like index quality analysis and rebuilding.
- Monitoring & control database growth and perform DBA operations as required. Monitor status of database archive logs for smooth operation of SAP systems.
Desirable Skills - Database Administration (HANA I Sybase I Oracle) Manage and maintain database for SAP and Non-SAP applications/systems Monitor, administer the database and troubleshoot database related issues.
Title: SAP BW Developer
Start Date: ASAP
Description:
Experienced in BW Requirements gathering, customer interaction, detailed documentation of requirements, solutions and functional specifications
- Experience in designing and building core modeling artifacts in SAP BW 7.5 on HANA, ADSOs, Composite Providers, Open ODS Views, LSA++ architecture
- Experience in implementing SAP ABAP and SAP AMDP scripting in BW transformations
- Experience in using CDS views for data extraction into BW and for real time reporting
- Experience in using user exits, field exit and BADI’s implementations
- Experience in HANA architecture/design and data modeling - creating Schemas, Packages, Stored Procedures, Analytical Views, Attribute Views, Calculation Views.
- Experience building hybrid data modeling solutions
- Knowledge on HANA 2.0 features
- Knowledge on SAP modules SD, MM, FI, Supply Chain
- Experience in extracting data from non-SAP data sources
- Experience in performance tuning of high volume and complex transformation scenarios
- Planning and organizational skills, including ability to engage with multiple development projects concurrently and working to tight deadlines.
Responsibilities
- Design and implement solutions for the SAP Business Warehouse on HANA including Design Documents, Data flows, Data models
- Develop customer solutions using core modeling artifacts in SAP BW 7.5 on HANA, ADSOs, Composite Providers, Open ODS Views, including enhancing the existing DataSources, creating generic DataSources when required
- Create data models to support real time reporting
- Extract data from non-SAP data sources
- Design and implement SAP HANA info models using Attribute Views, Analytic Views, Calculation Views Restricted and Calculated Measures, Input Parameters, Variables, Stored Procedures, CE Functions and SQL script.
- Tuning jobs for high volume and complex transformation scenarios
- Developing and executing advanced data profiling, data validation scenarios.
- Adhere to BI/BW best practices and standards to maintain a stable Business Information environment
- Monitor BW loads, communicate and troubleshoot issues with data integrity, data design, and functional and technical software issues
- Perform routine program modifications, performance tuning, problem solving, debugging, and unit testing
- Maintain BW structures and support for ETL processes for data feeding in and out of BW
- Design data structures to optimize data load times and end-user data access response times
- Design processes to minimize data quality risks and proactively identify potential data issues
- Prepare project related documentation (functional design, technical design, test scripts) during the different stages of a project
- Will be working on multiple development projects concurrently under tight deadlines.
- Solving complex performance problems and architectural challenges
- Building reusable code and libraries for future use
- Building efficient, testable, and reusable Node JS modules
- Building high performance frontend applications with react
- Responsible for End-to-end ownership of modules, including designing, development, validation, deployment
- Understanding fully synchronous behavior of Nodejs
- Familiarity with Workers/child processes & performance tuning
- Experience with SQL/NoSQL databases and their declarative query languages (MySQL, and MongoDB)
- Strong knowledge of the common Node Js & React or web server exploits and their solutions
What you need to have:
- A Bachelor's degree in Computer Science, or related technical discipline
- 1 to 3 years of Software Development experience
- Deep hands-on technical experience in object-oriented design, data structures, algorithm design, and complexity analysis
- Experience with full software lifecycle methodology, including; coding standards, code reviews, source control management, build processes, testing, and operations
- Ability to identify, empathize with and delight the customer
- Comfortable working with different Technologies across all of them as and when needed
- Strong knowledge on technologies/frameworks that we work on - Microservices Architecture, Python, Rest/gRPC, Node.js, MySQL, Postgres, AWS, ReactJS, React Native, Kubernetes.
Hands-on experience in working with Android Studio, Visual Studio & Xamarin.Forms.
Hands-on experience in creating user interface using Xamarin.Forms, Android SDK & iOS SDK for designing UI using XAML with various layouts and controls.
Hands-on experience required on MVVM.
Hands-on experience in developing Xamarin.Forms Custom Renderers, Data Binding, Effects,Gustures, Sliders, List views, Buttons, Styles, Check boxes, Date Pickers, Webview and Dependency Service.
Need Good Knowledge on data storage options using SQLite Database, Shared Preferences and Content Provider In Xamarin.Forms & Android.
Hands-on experience in Server integration technologies including web services RESTful APIs.
Need Good Knowledge in integrating Google Play Services, Google Maps API and Google
Cloud Messaging.
Need Good Knowledge with Push Notification Implementation in Xamarin.Android by Firebase.
Working experience required on developing the applications and testing them on Emulators, mobiles and tablets.
Proficient in generating Android .APK & iOS .IPA files deploying to the Playstore and App Store.
Jobs Duties and Responsibilities:
- LIASNING WITH SALE TEAM FOR ORDER AND VEHICLES.
- PROVIDING DISPATCH ORDER TO DISPATCH TEAM.
- SALES INVOICING
- DISPATCH DETAILS POSTING IN WHATSUP GROUP.
- LIASNING WITH GODOWN TEAM FOR ORDER AND DISPATCH
- VAT RECONICILIATION
- Inter branch transfer (Inventory transfers)
- Cash Payment Vouchers. Entry in SAP and Excel
- Cash Requirement
- Daily reports (Stock, Pending Order, and Seal register)
- MONTHLY FILES SENT TO HO
- EXPAT SALARIES PROCESSING
- MATERIAL RECEIPT RECORDS MAINTENANCE
- MONTHLY PHYSICAL STOCK COUNTS (FINISHED GOODS, RAW MATERIAL, BYPRODUCTS, CONSUMABLES AND SPARE PARTS) AND REPORTING
Education - Mcom in BA or CA Completed
Facilities - Bachelor Accommodation in company premises, Meal, Visa/Tickets, Medical & Insurance Policy as per company norms, 30 Days Unpaid Leaves after 2 Years completition etc.
Note - Candidate should be comfortable with 2 Years work permit & deduction of retention money (which is rembursed after successful completetion of employement duration).
solutions and with customer success team for deploying the same to customers.
2. Build & Design conversational chatbots that can be directly deployed for usage bya
large volume of customers.
3. Prepare Chabot user flows and process flows to effectively communicate interaction and
design ideas.
4. Analyze data coming from bot conversation to provide insights w.r.t processes and user
experience enhancement
5. Ensure that the customer understands the solution and receive responses to all open
questions and action items.
6. Prepare solution-related documents and specifications with the ability to write clear,
concise requirements and functional design documentation. Configure the solution,
followed by the creation, execution and maintenance of accurate and detailed test plans
for applicable testing.
7. Drives problem management and associated resolutions delivery with product
management teams.
REQUIRED SKILS
1.Pre-Sales or technical consulting with enterprise software
2. Able to understand technology practitioner - you have got your hands dirty with APIs,
technical definitions, and stitching solutions between partner ecosystems with basic REST
APIs consumption & JSON manipulation knowledge.
3. Excellent understanding of SDLC, Agile & Scrum.
4. Good knowledge of preparation of BRD, FRD, SRS, Use Case, UML, ER Diagrams & Flow
Charts.
5. Creation of user-stories and bridging the gap between the development team, client, and
project manager.
6.Requirement Gathering, Preparation of Documents, Writing Test cases, and UAT.
As a Database developer, you will be responsible for designing, creating database, stored procedure, functions, ETL etc.
and upgrade of database that are leading the way in assuring high quality of data visualization and products. You will be
challenged with systematic database development methodologies in concurrent computing software architecture
environment. The engineer will have the opportunity to work with software developers and the site support engineer ona regular basis.
Job responsibilities:
• Development of high-quality database solutions.
• Develop, implement and optimize stored procedures and functions using T-SQL.
• Review and interpret ongoing business report requirements.
• Research required data.
• Build appropriate and useful reporting deliverables.
• Analyze existing SQL queries for performance improvements.
• Suggest new queries.
• Develop procedures and scripts for data migration.
• Provide timely scheduled management reporting.
• Investigate exceptions about asset movements.
Job requirements:
• Should understand operating system, relational database, concurrent computing, and client/server architecture
and mobile environment.
• Should have excellent problem solving and trouble shooting skills
• Should have ability to excel in cross functional team environment
• Should have experience in Cross-Platforms (Unix/Windows) application testing environment
• Should have excellent written and verbal communication skills in English
• Should have attention to detail, positive attitude under stress
• Design, plan, and develop programs to optimally extract, transform, and load data from data sources to the
target systems. Expert level knowledge of T-SQL, Stored Procedures, Data Modeling, Views, and Functions.
• Maintain source code for database
• Efficient in writing optimized SQL queries.
• Develop SQL scripts, table, views, indexes, and complex queries.
• Design & maintain the existing databases and ensure their stability, reliability, security and performance.
• Coordinate with software developers, review (and modify the queries if required) and approve the SQL queries
written by them for the production deployment.
• Strong knowledge in Database design, develop, test, implement, fine-tune, enhance and maintain new and existing databases.
Professional qualifications:
• 4 – 6 years of relevant experience
• Bachelor's degree in Computer Science, Engineering or a related subject.
• Excellent understanding of Microsoft SQL Server.
• 3-4 years of experience with SQL Server Reporting Services and SQL Server Analysis Services.
• Familiarity with the practical application of NoSQL\NewSQL databases.
• Sense of ownership and pride in your performance and its impact on company’s success.
• Critical thinker and problem-solving skills.
• Team player.
• Good time-management skills.
• Great interpersonal and communication skills
- Business & Financial Management :
- Ensure forms / returns / registers are prepared accurately and filed timely.
- Ensure creation and maintenance of secretarial records / registers and ensure that they remain updated all the time.
- Assist / ensure listing, tracking and compliance with the statutory provisions under the Company law, SEBI / NHB / RBI / IRDA laws / related laws and
- improve compliance levels.
- Prepare all relevant meetings’ documents/papers efficiently.
- Assist in smooth conduct of the meetings and in timely closure of post meeting compliances/ follow up matters.
- Ensure all the audits are completed in time and always aim for clean audit reports.
- Assist in carrying out all other compliances and assignments as may be delegated from time to time in accurately and efficiently.
- Implementing processes or systems to help ensure good management of the organisation or compliance with the legislation.
- Keeping up to date with any regulatory or statutory changes and policies that might affect the organisation.
- People / Team
- Ensure prompt and effective coordination in a cordial manner.
- Build and maintain cordial relations with all internal and external stakeholders statutory authorities, stock exchanges, Debenture Trustees, R&T agents,
- Consultants, Regulators, Other departments, etc.
- Prepare training plans for the juniors and track their progress. To help them handle assignments independently.
- Provide qualitative and timely assistance to seniors whenever called for
- Process / Quality Improvement.
- Finalising and submitting process manuals, checklists, trackers etc.
- Improving compliance and administrative processes.
- Accurately prepare, finalise and submit process manuals, checklists, trackers, etc in time.
- Assist in improving the compliance and administrative processes continually.
- Decision making authority
- Recommend improvements
- Process Changes
- Communicate within the organization and depending on progress, communicate with external stakeholders (except regulators) Self deliverables.
- Tasks to be performed single handedly
- Plan and track progress in the work related to Board / Board Committees / General meetings.
- List out the various documents to be filed with state authorities, track progress and ensure timely completion.
What you need to have:
- 5 - 6 years of experience post CS qualification.
- Must have excellent communication skills - both verbal and written
- Organized, dedicated and self-driven
- Strong administrative and leadership skills
- Attention to detail
- Ability to delegate and supervise junior staff
- Ability to meet strict deadlines
- Should be able to prioritize and make decisions
- Professional and trustworthy
- Considerate and cooperative to clients as well as team members
- TOOLS - Tally, ERP Package, GSuite