Looking for candidates from anywhere in South India who can relocate to Bangalore after Covid end.
MANDATORY TECHNICAL SKILLS
SSRS, PowerBI, SQL Server 2008/2012, TSQL, Stored Procedures, Views, UDF’s, Triggers, Charts
EXPERIENCE
-
7+ years professional experience in database development using SQL Server 2008/2012(T-SQL, SSRS)
-
Strong analytical and critical thinking skills, with the ability to analyze business requirements to determine
-
processing flow, user requirements and inter-dependencies of multiple information systems.
-
Experience with SDLC required
-
Excellent verbal and written communication skills.
-
Strong in performance tuning especially tuning complex queries, procedures and indexing strategies
Similar jobs
Strong in MS SQL.
Strong in Performance tuning, Troubleshooting, Dubugging, Query Optimization
.net exposure will be good to have.
3+ Years in SSRS & SSIS
Excellent Skills in Writing Stored Procedures, Functions,Triggers,queries, Scripts etc
- Structured Query Language (SQL), e.g. SQL/PSM, Transact-SQL queries, writes SQL scripts in SQL Server 2000/2005/ 2012/ 2016, etc.
- 1+ years in Cloud Database services like AWS Dynamo DB / RDS
- Excellent Troubleshooting skills of existing functional implementation to derive leaner solutions and effective performance between applications software, systems software, and installed hardware.
- Database instance maintenance tasks such as DB Integrity Checks, Index Maintenance.
- High availability like clustering, log shipping, mirroring, replication.
- Backup and disaster recovery, Capacity planning and performance monitoring, Physical database structure, RDMS administration roles, instances, profiles, and security connectivity.
- Developing, implementing, maintaining, and following change control and testing processes for modifications to databases.
- Establishing backup and recovery or replication plans to minimize data loss and system downtime.
- Improving data quality through data analysis, monitoring, gap analyses, and working with the teams to provide solutions and resolve errors.
- Maintaining data integrity and security (manage roles and permissions of database users).
- Reviewing the security logs from the SQL Server Error Logs to determine if you had a breach or a violation in one of your policies.
- Ensures optimal database performance and availability.
· Creation & maintenance of Databases in AWS.
Certification is mandatory – PD1 /PD2.
Lightning web component Development and debugging
Worked on XML, JavaScript, CSS2 & CSS3, HTML5& jQuery
Integration and Dataloader experience
Apex Scripting and debugging
Salesforce Trigger
Flow design
Experience on Mulesoft Integration
Integration REST API/Lightning Messaging Services
Sales Cloud knowledge – preferred
Client is looking for a SFDC Developer to join our team of bright thinkers and doers. You will be part of a highly skilled capability group, working for clients across various industry verticals, to develop high-end software products/ services, involving configuration and customization. You should have an exceptional verbal and communication qualities and be able to present and communicate technical designs and solutions to peers. We are on a mission to transform the world, and you will be instrumental in shaping how we do it with your ideas, thoughts, and solutions.
Your Impact:
- Interact clearly with clients and the on-shore and off-shore project teams
- Regular involvement in thought leadership Best Practices development
- Facilitate end to end project design & development while working closely with global client
Your Skills & Experience:
- 4 to 10 years of development experience in SFDC
- Excellent hands-on experience in Salesforce application development including VF, Apex Triggers, Asynchronous Apex
- Deep knowledge of Lightning framework
- Expertise in Business Requirement gathering, Analysis & conceptualizing high-level architectural framework & design
- Experience working with Sales or Service cloud, Community Cloud, Marketing Cloud
- Conceptualize end to end integration projects & knowledge of authentication mechanism
- Experience in REST & SOAP APIs, knowledge of Governor limits involved during Integration
- Working knowledge on continuous integration, working with repositories (e.g. Git)
- Should have experience to design the data flow and work with any ETL or dataloader
- Excellent experience in designing and architecting large scale applications
- Thorough understanding of Solution architecting & Estimation process
- Excellent consulting skills, oral and written communication, presentation, and analytical skills
Set Yourself Apart With:
- Salesforce Certifications
- Knowledge of Heroku, Angular.js and Salesforce Einstein, Salesforce CPQ, CloudCraze B2B
- sIncident and problem management skills
- Ability to provide necessary coaching to bring juniors up to speed on the technology
- Exceptional written skill for solution documentation creation for both technical and non-technical material
- Background in force.com platform and deployment experience in an outsourced service environment
- Articulation skills & Good team player
- Self-starter and self-learner with keen interest to grow
- Process orientation and the ability to define and setup processes
- Mentoring team members
Benefits of Working Here:
- Gender Neutral Policy
- 18 paid holidays throughout the year for NCR/BLR (22 For Mumbai)
- Generous parental leave and new parent transition program
- Flexible work arrangements
- Employee Assistance Programs to help you in wellness and well being
Career level –Senior Associate
Salary Upto 35 LPA.
Location: Bengaluru / Noida / Gurugram , Also allows remote working from any where.
Our esteem client MITS are looking for MSBI developer as per below JD
BI Developer
Roles and Responsibilities:
- Comprehensive knowledge of SQL
- Expertise as a Microsoft BI Developer (SQL Server, SSIS)
- Experience and understanding of build and deploy processes
- A structured approach to software development (agile or waterfall), and a thorough understanding of the full software development lifecycle
- Knowledge and experience in experience banking
- Contribute to planning and estimation of sprints, features and releases
- Integrate new data sources using SQL, SSIS and C#
- Contribute to the testing and UAT phases
- In addition SQL Server 2014, Integration Services, Analysis Services, and Reporting Services (SSIS, ), Microsoft .NET, Tableau, Power BI, Data warehouse design
• As an SSRS Report Engineer, the primary job role is to develop a transactional data report using Microsoft SQL Service Reporting Service 2016 or above.
• This includes developing high performing Stored Procedures, Functions, and corresponding reporting formats.
• Required to design the required logics for the queries and collaboratively coordinate with the rest of the team.
Main Duties / Responsibilities
• Design & implement high performing T-SQL queries as per the functional specification.
• Create Technical Specification.
• Effective troubleshooting of technical issues and bugs.
• Package deployment and release management.
• Provides technical support to customers.
• Participate in Requirements discussions.
• Must be able to manage timelines and task priorities.
• Attention to detail and maintaining high-quality standards is a must.
TECHNICAL KNOWLEDGE
• Experience in Microsoft SQL Server 2016 (or above) and Microsoft SQL Service Reporting Service 2016 (or above).
• Knowledge of T-SQL including complex SQL queries, stored procedures, views and functions.
• Experience with usage of indexes and T-SQL performance tuning techniques.
QUALIFICATIONS
• Bachelor’s Degree or an equivalent qualification
Questions for Candidates
• Require experience in query optimizing.
• Have to be hands-on in SSRS.
• Good in T-Sql query, like use of temp tables when developing store procedures concerning report development
• Should be a guide and mentor to make sure to provide a quality outcome.
• Very good in basic development principles
o Adding Cascading parameters
o Grouping subtotal/ Grand total
o Sub Reports/ HyperLink creation
o Matrix Grid
- Provide thought leadership on how best to meet business requirements using the CDM platform
- Help determine the architectural direction of the CDM platform and related infrastructure
- Collaborate with business analysts and product owners to interpret and synthesize requirements
- Work with other team members to determine the best technical solution to meet requirements.
- Keep current on industry best practices and help to incorporate relevant updates into solutions.
- Analyze and Identify existing architecture and come up with suggestions and implement changes to bring solutions to a more stable state.
- Act as a single point of contact to the team (including dev/QA/support) in guiding to adopt best practices across technology development.
Basic Qualifications:
- Bachelor’s degree in computer science, information technology, or related field
- Strong problem-solving, analytical, and critical thinking skills
- 10+ years working in an IT environment (Preferably on Digital or DWH/ETL applications)
- 5+ years Java/.net (or similar) application design and development experience
- 4+ years Tibco EBX5 architect/design/development experience
- 5+ years database design/development experience in MS SQL Server or similar DBs with query tuning and optimization
- Proficiency in SQL, XML, JSON
- Min 5 years working experience an agile development team
- Min 3 to 5 years of exp with Azure Cloud including services like VMs, Security, Storage, App Services, Service Bus, Active Directory, Azure SQL
Preferred Qualifications:
- Experience in ETL, DW/BI, modeling, and manipulating data using Microsoft Access, SQL, Tableau, or similar tools
- Knowledge of MDM (Master data management) foundational concepts
- Excellent verbal and written communication skills that allow effective communication with all levels of the organization
- Experience working in a heterogeneous technology environment
- Ability to participate in high-level architecture design as well as hands-on development
- Experience developing applications in the Salesforce platform
- Exposure to web applications and web portals is added advantage
What essential skills you need
- 4 -6 years’ experience in MySQL database development. You know your way around problems,logic & code but you occasionally need help with how to do things. That’s cool with us. We usestack overflow too.
- Expertise in database design & development (preferably on MySQL).
- Expertise in writing complex SQL queries, stored procedures, and functions, triggers.
- Expertise in performance tuning, query optimization, using performance monitor, SQL Profiler andother related monitoring and troubleshooting tools.
- BE/B.Tech ( or equivalent education), good written & communication Skills.