Data Warehouse Developer
KMC Solutions
- Taguig, Philippines20/F Picadilly Star 4th Avenue corner 27th Street Bonifacio Global City, Taguig City, Philippines, Taguig, Metro Manila, PhilippinesTaguigMetro ManilaPhilippinesPhilippines
- Full timeFULL_TIME
Job closed.
Job Description
- Lead and Develop multiple development projects utilizing SQL Server 2012 through 2016
- Work closely with Data warehouse team to develop the vision for database, SSIS, SSRS and SSAS architecture
- Develop complex SSIS packages using SQL Server 2012 to integrate with other SQL Servers, .FTP services, flat files, and non-SQL data sources such as legacy systems
- Help lead the upgrade of key systems such as SSAS, SSRS, and database engine.
- Develop tables, indexes, stored procedures, views, triggers and other objects utilizing latest DML and DDL syntax
- Generate detailed design documents from business requirements and document solutions upon design
- Confer with end-users, peers or senior management to define business requirements
- Establish Metadata, Data dictionary for the key data warehouse environments.
- Help develop and lead best practice dissemination to the rest of the database team
- Financial and/or Mortgage industry expertise preferred
Minimum Qualifications
- Excellent troubleshooting and performance optimization skills
- Proven record of architecting robust relational database solutions
- Excellent T-SQL coding skills using advanced techniques
- In-depth experience with SSIS development using all areas of the environment, including scripting
- Experience working with a .NET development team delivering database code as part of an integrated SDLC system
- Bachelor’s degree in Computer Science / related field or related work experience
- Familiarity with Ralph – Kimball Data Warehouse Architecture
- Experience with C# scripting within SSIS
- Related Microsoft Certification
Jobs Summary
- Job Level
- Entry Level / Junior, Apprentice
- Job Category
- IT and Software
- Educational Requirement
- Bachelor's degree graduate
- Office Address
- 20/F Picadilly Star 4th Avenue corner 27th Street Bonifacio Global City, Taguig City, Philippines, Taguig, Metro Manila, Philippines
About KMC Solutions
KMC Solutions is the leading outsourcing and offshoring corporate services provider in the Philippines. Our company delivers effective business solutions through a seamless integration of services, together with our sister companies: KMC MAG Group, Inc., the country's top real estate services firm and Kittelson & Carpo Consulting, a business consultancy firm. From finding the right office space or serviced office, complying with legal and business requirements down to human resources and payroll management, KMCS offers a full suite of business process outsourcing (BPO) and offshoring services that are designed to help foreign companies and investors smoothly enter the Philippine market and expand operations in the country.
KMC Solutions has a cross-cultural team composed of expatriates and Filipinos who collaborate using quality-centric processes to deliver effective results for our clients. Since 2009, KMCS has assisted businesses in successfully transitioning and establishing operations in the Philippines. Our client portfolio includes SMEs and multinational firms such as Bright, WEIR, and Readify.