We are urgently looking Azure Data Factory Engineers with 3 to 7 years of overall experience, having good experience on Azure Data Factory and SSIS. Requirements: Qualification: Engineering Graduate. Years of Experience: 2+ yrs of relevant experience on Azure Data Factory & SSIS. Strong understanding of ETL/ELT concepts. Hands on experience on Azure Data Factory. Exposure of Cloud technologies, standards, and platforms. Sound knowledge of ADF pipeline, configuration, parameters, variables, Integration services runtime (part of Data Factory). Strong Experience on SSIS. Sound knowledge of implementing slowly changing dimensions and transactional, fact less, snapshot fact tables. Azure Data Warehouse. Knowledge on Azure components especially file storage and Azure Sql, Blob storage and Data Lake Gen2 storage (just used as a file system on the blob). Azure Data Migration tool. Well versed with RDBMS systems like Sql server, DDL, DML scripts. Sound knowledge of T-SQL and stored procedures. Strong Query writing skills, Scheduling tools. Ensure quality deliverable and ability to extend work hours if required. Azure Certification: Preferred. Ability to understand Customer requirements and convert the requirements into technical specifications. Ability to understand the overall solution and design components to fit the overall solution. Ability to take technical decisions and support the decisions with justifications. Ability to work in Agile manner. Ability to work independently without much guidance. Self-Motivated, team player, results oriented, strong Time Management skills. Excellent written and verbal communication skills. Willing to travel to outside India (Short term as well as long term)
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. •
*** This role will require you to work at US hours i.e. 6 PM IST to 3 AM IST *** Required Experience, Skills and Qualifications Maintain and monitor all databases across the enterprise to ensure issues are taken care of before they pose a problem. This includes monitoring several dozen physical servers across multiple geographic locations, containing over 200 databases, several thousand tables, spanning billions of records. Monitoring is accomplished via a variety of tools such as scripts, email alerts, dashboards and user inquiries describing end user symptoms that need to be corrected. Setting up, Maintaining and monitoring database server security via a combination of Active Directory and server level permission settings. Ensure we are compliant with all industry best practices wherever possible, ie PCI compliance, Sarbanes-Oxley Act, etc.,. Create, implement, test and manage automated database backups for the entire SQL server farm across all geographical locations using industry standard software and best practices Create and maintain all server documentation on the local Wiki regarding security policies, replication polices, server architecure and backup policies. Included in this documentation would be a change log to track changes made by any individual to any live production database at any time. Create, manage and troubleshoot server replication policies all geographical nodes. Troubleshooting will include research and analysis of slow moving replications, missing records and other anomolies that can occur during replication. Participate in design of new databases and servers, working with stakeholders and acting as a subject matter expert to determine proper industry best practices. Assisting Database developers to retrieve data whenever needed, using SQL scripts and procedures Responsible for tuning queries as needed for optimal response time using various methods such as script optimization, file grouping, index creation and optimization as well as location and geographic optimization Responsible for reviewing and publishing changes to the production environment all changes created by the development team using provided scripts and packages on a scheduled basis. Required Skills SQL Skill tSQL / Replication / SSIS / OLAP / Log Idera Backup Software Microsoft SQL Server Administration (SQL 2012+) AtTask or other Project Management software Troubleshooting and data analysis skills Technical documentation skills Required Experience Excellent problem-solving skills and ability to navigate challenging situations, in a professional manner. Work collaboratively with willingness to listen and work in fast paced challenging environment Prior Database Administration experience required Ability to independently apply production upgrades and support the products and technologies Experience in providing services to agreed SLAs. Database architect/developer experience is a plus.
Power BI Experience: 2-3 years Skills: Power BI Start date : Looking out for Immediate Joiners Contract position for 3 months Location Bangalore Job Designation Power BI Developer : 1. To Develop Power BI reports & effective dashboards after gathering and translating end user requirements. 2. To have Ability to turn large amounts of raw data into actionable information. 3. Be responsible for the performance and usability of the system 4. To Perform optimization of MS SQL Queries and SSIS packages 5. To Provide solutions using SSAS cubes (Tabular/Multidimensional Models) 6. Must have excellent experience in MS SQL Server - writing queries, joints, stored procedures, functions etc Candidate should have the knowledge of: Power BI with DAX query, Multiple Data Sources and Relationships of data Power BI Architecture Data modelling, Calculations, Conversions, Scheduling Data refreshes in Power BI Desktop Hands-on professional with thorough knowledge of scripting, data source integration and advanced GUI development in Power BI. Familiar with Power BI custom add-on development & deployment. Connecting Power BI with on-premise and cloud computing platforms. To provide optimized SQL Scripts for complex scenarios Business Intelligence Systems & Tools (Microsoft Power BI, SQL Server Reporting Services) Good understanding of the processes of data quality, data cleansing and data transformation
You will be responsible for working as a Business Intelligence developer with a team of other BI developers providing technical Solutions and implement the BI and Analytics strategy and direction to a large-scale e-commerce business. You will be required to be hands-on, bring innovative approaches that continuously improve our ability to deliver faster, better and cheaper solutions while reducing the time and cost to build BI and analytics solutions and on-board with highest quality. You’ll be responsible for designing, developing high quality code solutions with an emphasis on quality, simplicity and maintainability in SQL Server suite of business intelligence and adopt the same in the e-commerce BI solutions. Required Experience, Skills and Qualifications BE/B.Tech/MCA in Computer Science or related field 6+ years of experience and proven track record in end-to-end DW Design, Development and implementation of at least one or more DW project/projects. Excellent ability to translate business requirements into logical, conceptual and physical data models Experience in data warehouse life cycle management Professional, practical programming using SSIS Should be able to quickly adapt to business processes and understand the domain. Strong Logical and Analytical Reasoning Skills, Excellent Communication with good Listening, Presentation and Interpersonal Skills. Possesses a professional demeanor Willing to work hands on as per project / initiative requirements Drive to take up new incentives and deliver them Strong SQL skills Required Skills ETL tools: SSIS Database: SQL Server (2005/2008/2012/2016), Oracle, MySQL Knowledge of SAP BO, Cognos Report Builder is added plus. Required Experience Exposure to dimensional data modelling Hands-on experience experience on DB and ETL Performance Tuning and troubleshooting Strong exposure to database performance tuning Experience in Data Quality Profiling Tools is a plus
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
Who we are? A smart tech company that places more focus on lateral thinking and uses common sense to create innovative models and create an impression at the world stage. From being an absolute no paper usage to being the most desired organisation to work with and create the perfect partners for business and perfect workplace for any professional. We intend to change the way business will be conducted and managed henceforth What is Eazo? An integrated app for logistics - Supply chain needs to evolve. There are many pieces that needs to be brought together to drive an effective model which now Eazo has designed using it’s ecosystem while tapping in to the largest workforce imagined.
MS SQL 2012 Server Administrator, with experience of data migration projects using SSRS, SSIS packages. Needs to have a very strong and credible record as a DBA, experience of handling enterprise Data Base migration projects preferably in a financial or banking arena. Provide hands on support to our internal DBA and development teams. Strong knowledge of database design, query cost and performance measurement, use of stored procedures and performance tuning. Experience in using Integration Services (SSIS) platform for building high performance data integration and workflow solutions, including extraction, transformation, and loading (ETL) operations. Will provide database functions by designing and coding utilities and scripts Maintains database performance by calculating optimum values for database parameters; implementing new releases and completing maintenance requirements. Provides information by answering questions and making recommendations. Maintains quality service by establishing and enforcing organization standards.