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.
Looking for a Software developer with good experience in SQL Programming with expertise on SSIS (mandatory). Work location Bangalore
Deep knowledge of .Net 3.5/4.0 Framework (including Visual Studio 2008, 2012), OOPS, ASP.NET, MVC 4, Web API's and WCF Web Services, SQL Server (2008,2012), Jquery and HTML 5 Solid experience on Creating and Consuming WCF Web services Strong knowledge of Software implementation best practices Solid understanding of Object-Oriented Programming (OOP) Candidate should be able to develop new functionality/enhancements on existing products/applications. Company details: Costrategix is a group of talented people that value learning and growth. We are passionate about technologies and how it applies to problems related to business models. We help grow your top-line revenues while reducing your operating expenditures through strategic conversations, technology consulting and deep software expertise. Costrategix has been in business for 10 years and our team of 100+ technologists serves enterprises, mid-market companies and startups in United States and Europe. Visit us at http://www.costrategix.com/ & https://vimeo.com/117520660 & YouTube.com