Practice Head – BI/Data Science Engineering BI & Data Science is an emerging practice at Technovert and we are seeking for Leader roles who can rapidly grow this practice. As a practice Head, you will deliver consulting and strategy services to clients that are looking to establish better BI and Data Science engineering practices. You will be leading teams of BI/Data Science personnel performing both functional and development, working directly with senior clients, while providing thought leadership to define and implement BI and Data Science strategies. Additionally, you will be developing assets for the practice, participating in business development activities and leading people as part of your core responsibilities. Responsibilities You are responsible and accountable for building the practice, driving quality, sales, recruitment, account management as follows Building the Practice - Drive overall growth of the practice right from business development, talent development to delivering the solution. Talent Development: Hire passionate and right mix of talent. Coach, guide and mentor consultants and leaders and build a high-performance team and awesome culture. Build center of excellence - Build an innovation center, design frameworks and develop new methodologies and intellectual property. Train people on latest BI practices, strategies and tools. Sales Enablement - Identifying market needs, design campaigns, produce quality collateral and enable sales teams to drive new business opportunities. Engagement Management - Manage engagement risk, project economics including planning and budgeting, defining deliverable frameworks Thought Leadership - Research and identify latest and future trends in the industry and share thought provoking ideas and solution with internal teams and to the world at large. Active in the technology community through various channels including conferences, meetups, blogging, etc. Who can apply: • Proficient in customization and configuration of MSBI product suite • Proficient in all three components of MSBI (SSIS/SSRS/SSAS) • Proficient in Power Bi implementations • Knowledge of tools like Qlikview, Tableau or Business Objects is an added advantage. • Should be able to do complex design and high-performance architecture • Should be able to design cubes for complex business requirements • Should have excellent understanding of MSBI Architecture • Should have excellent understanding of MS SQL Server Architecture • Prior experience in end to end BI Implementation projects • Participating and leading client engagement in developing plans and strategies of data management processes and IT programs for the clients, providing hands on assistance in data modeling, technical implementation of vendor products and practices • Facilitating, guiding, and influencing the clients and teams towards right information technology architecture and becoming interface between Business leadership, Tech leadership and the delivery teams • Leading and mentoring other consultants within the practice and across business units • Supporting business development and ensuring high levels of client satisfaction during delivery • Contributing to the thought capital through the creation of executive presentations, architecture documents, and IT position papers • Scope Client requirements • Provide best practice advice to customers and team members • Very good experience in having designed and developed reports, scorecards and dashboards • Participate with End-users and participate in requirement gathering and convert into technical documentation • Prepare high –level Architecture designs for the SSAS/SSRS reporting solutions. • Identify/foresee performance bottle-necks in the report and resolve the same • Provide good solutions/approaches for any complex requirements • Good communication skills are a must. •
Position – SQL Developer /Sr.SQL Developer with 4-8yrs experience 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. Why Think n Solutions Software? Exposure to latest Technology. Opportunity working in different platforms Direct client interaction Rapid Career Growth Friendly Knowledge sharing Environment Criteria: BE/MTech/MCA with Min 70% GPA 4-8yrs Hands on Experience in TSQL Immediate joiners preferred/ Maximum notice period of 1 month 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: o Writing SQL Server / PostgreSQL stored procedures in an application development environment. o Design database tables, views, indexes, functions and develop the various reports using SQL and Stored Procedures. o Work with other front-end developers in completing the database modules end to end (experience in parsing of JSON in Stored Procedures would be an added advantage). o Query optimization for performance improvement. o Design & develop SSIS Packages, SQL Procedures, and Transform data from different data sources. 2. Functional Skills Desired: o Banking / Insurance / Retail domain is a plus. o Interaction with a client a plus. 3. Add on Skills Good to Have: o Knowledge on Mongo DB o Experience in some version control system is a plus o Exposure to Quality and process Management o Knowledge in Agile Methodology Company: Think n Solutions Software Pvt Ltd Work Location: HSR Layout, Bangalore Send Resumes to: hr-indiaatthinknsolutionsdotcom
Sr. SQL Developer (www.techwave.net)Hitech City, HyderabadPermanent PositionJob Description :- 8+ years of hands on experience in SQL Server development, SSIS and SSRS.- Good Experience in SQL queries. Stored procedures, functions, Triggers, cursors and strong experience with dynamic SQL- Knowledge of SAP will be an added advantage.- Candidate should have very good experience in data migration / data analysis / Data Conversion.- Excellent communication skills. - Good team player.- Coordinate and communicate with people at different levels to understand the business requirements and execute.- Manage assigned risks and monitor potential impacts as part of the data migration plan.- Work across multiple functional modules to understand data usage and implications for data migration.- Eagerness to learn, committed towards work.
Responsibilities 1. Design & develop detail ETL specification based on the business requirement using SSIS & Oracle Procedures. 2. Good understanding of Data Warehousing & Dimensional Modelling concepts. 3. Develops, tests and implements enterprise data movement (ETL and CDC) solutions. 4. Design, develop & test SSRS reports & dashboards based on large amount of data sourcing from multidimensional analysis cube. 5. Ability to translate business needs into the technical solutions by working with business and IT stakeholders 6. Assist in the effort estimation and planning for SSIS & SSRS implementations 7. Troubleshoot & provide solutions based on the priorities for any issues being reported by client in ETL loads and reports. 8. Optimization of ETL processing time using industry best practices & standards to provide the report in timely manner. 9. Support in documenting solution design, user guide, troubleshooting guide wherever required. 10. Design & development ETL using SSIS. Required Skills 1. Minimum 3+ years of working experience in ETL, Data Warehousing using MSBI (SSRS, SSIS, Power BI) 2. Extensive experience working with SSIS, Power BI for developing management dashboard. 3. Experience in working with large scale data warehouse implementation project using MSBI & SQL Server. 4. Extensive experience in design and development of SSIS & automation of its processing. 5. Extensive experience in design and development of SSRS visualization & reports considering multiple sources. 6. Experience in working with SQL / PLSQL scripting using SQL Server. 7. Extensive experience to optimize the performance of ETL to match the assigned execution windows. 8. Experience in handling large amount of data coming from disparate systems. 9. Good to have the working experience in the Insurance Brokerage Domain.
As a database developer, you will deliver SQL Server database solutions to support a growing suite of applications. You must be able to work in a fast-paced environment and learn fast with little guidance. You will be responsible for design, development, implementation and support of database code. You will develop ETL (SSIS), SSRS ,T-SQL and PowerShell processes upon new and legacy systems. You will develop new solutions and provide automation to reduce manual tasks. Qualified candidates should possess the ability to perform at a high level under aggressive timelines and complex solutions. 3+ years of SQL Development in a large enterprise environment Should have developed complex database code with T-SQL, SSIS, SSRS and SQL Server best practices to support UI, Middleware and Batch applications. Familiar with Agile development methodology Experience with SVN a plus Experience with Business Intelligence is a plus. Experience with Tableau is a huge plus. Experience with PowerShell is a plus. Exposed to data modelling is a plus.
• Proactively assist customers with technical issues that may arise with their solution implementation. Troubleshoot and perform root cause analysis. Identify and provide timely workarounds and solutions when possible, to meet customer’s business needs. • Reproduce in house when possible and file engineering tickets. Work with engineering and product management to prioritize as customer advocate to get resolutions in next release. When possible, analyze code and participate in engineering processes to develop and deploy defect fixes as service packs/hot fixes. • Constantly stay ahead in communicating with customers. Manage expectations properly to avoid escalations. Be a strong voice of customers during engineering planning. • Assist through release cycles in testing new features, enhancements and defect fixes. • Work with client business areas to design, build, enhance, and deliver enterprise wide data analytic dashboards and reports supporting multiple business units. • Collaborate with key business users to identify needs and opportunities for improved data management and delivery. • Design and build ETL processes and scripts. • Provide technical knowledge and business support to the BI team. Candidate fitment: • 6-8 years experience in Cognos Business Analytics Reporting and Analytical roles; proficiency in SQL, Excel, Relational Databases, Oracle, SQL Server • Ability to manage multiple timelines and priorities. • Experience in manufacturing industry is a PLUS. • Highly developed analytical, problem-solving, and consulting skills, with a proven track record of using data to provide actionable business results. • Experience in validating an overall solution from the perspective of performance, scalability, security and capacity. • The ideal candidate is dedicated to making it easy for customers to use our product by leveraging business expertise and using rigorous logic and creative methods to solve difficult problems with effective solutions.