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.
Duration of contract: 12 Months Total Yrs. of Experience: 7years Relevant Yrs. of experience: 7years Detailed JD *(Roles and Responsibilities): · 7 yrs experience with technology. · Proven experience with heavy usage of SSIS and SQL database tool and related infrastructure like development, deployment, administration and investigation of issues with quick turnaround (functional as well as performance). · Demonstrated development/deployment/administration/support with SSAS Tabular project using advanced concepts like percentile, partitioning, row level security implementation is a must · Good understanding of reporting UIX and demonstrated development of reports using "Online Microsoft Power BI" features and visuals for 5K+ users. · Demonstrated effective and proactive communication with clients · In general, the candidate would be working in fast paced agile environment having around 8-10 team members to work with and direct daily client interaction (in second shift 2pm to 11pm) in GDM model. The daily activities would be as below but not limited to o identify data needs and analyze available data o comprehend business and technical requirements o analysis of code and understanding existing system o and preparing high level design document, low level design o contributions to schedule and effort estimation o Build, Unit testing, Understanding of configuration management · SQS Server 2016 experience is plus · Azure experience related to Microsoft business intelligence stack is a plus · SSRS experience is good to have
Technovert is a fast growing premiere technology company founded by ex-Microsoft techies and has the best in class technology 'Spartans' of the industry. We work with enterprises in the International market that includes best of the world's technology companies such as Microsoft. We Are Obsessed with our love for technology and the infinite possibilities it can create for making this world a better place. Our clients find us at our best when we are challenged with their toughest of the problems and we love chasing the problems. It Thrills Us and motivates us to deliver more. The Business Intelligence (BI) developer is responsible for building, implementing and supporting Microsoft BI solutions. The right individual will possess experience in all stages of BI project work (requirements and logical design, physical design, implementation, testing and deployment). The BI Developer should have a firm grasp of BI implementation methodologies and will have had in-depth experience with the Microsoft BI Stack (SSIS, SSAS and SSRS). This position offers you the opportunity to expand your skills in BI, as you join a growing and dynamic team with a trusted data center solution provider for many of the worlds leading enterprises. You'll be exposed to new methodologies, tools and technical skills. We are looking for candidates who are hands-on with T-SQL and MDX Query Languages along with the below mentioned skill set. • Relational Database and SQL Language • Data Warehouse / Solution Design • Dimensional Modeling • Analytics / OLAP Cube Development (Microsoft SSAS and MDX) • Analytics / Tabular Cube Development (Microsoft SSAS and DAX) • Report Development (Microsoft SSRS) • Good ETL knowledge (Microsoft SSIS) • Power Pivot and Power View • Power BI Analysis and Communication Skills: • Data gathering, research and analytical abilities so as to develop insightful conclusions and generate solutions to address user needs • Create written communication materials that effectively summarize findings and support recommendations • Direct quality assurance and user acceptance testing by writing test plans and managing the execution of testing (Unit and UAT) Any knowledge on Power BI, Tableau, Data Zen, Power View, Power Pivot is a great plus!
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.