Tuesday , July 25 2017
Home / Jobs / Senior Data Warehouse Engineer

Senior Data Warehouse Engineer

FactSet combines hundreds of databases into a single, powerful information system. It is a one-stop source for financial information and analytics for business analysts, portfolio managers, investment bankers / management firms and other financial professionals to analyze companies, portfolios, markets & economies. FactSet was formed in 1978 and operates out of 35 locations worldwide. FactSet, with over $1 billion in annual revenues, is headquartered in Norwalk, Connecticut and employs nearly 6500 people worldwide. Our operations extend within North America as well as Europe and the Pacific Rim. Since 1996, the Company has been publicly traded on the New York Stock Exchange under the symbol FDS.


Senior Data Warehouse Engineer

Job Description:

The key areas of responsibility include:
Work with business users and other stakeholders to understand business processes.
Ability to design and implement Dimensional and Fact tables
Identify and implement data transformation/cleansing requirements
Develop SSIS packages using Business Intelligence Development Studio (BIDS)
Test and debug SSIS packages
Determine testing needed to assure the functionality and integrity of the ETL solutions, create
test plans, and evaluate testing results taking corrective action as necessary
Visualize data using SSRS
Implementing OLAP (SSAS) cubes

Required Skills:

5+ years hands-on experience in data warehouse projects with MS SQL Server 2008/2012
Bachelors degree, preferably in Computer Science or equivalent professional experience
Strong SQL writing skills
Hands-on and deep experience with Warehouse schema design
Familiarity with Kimball data warehouse methodology
Experience using Business Intelligence Development Studio (BIDS) to build SSIS packages
Experience in gathering and analyzing business requirements
Understand project-specific requirements, standards, guidelines, and processes
Demonstrated success working in a team-based environment
Good written / oral communication skills
Strong analytical and problem solving skills

Additional Skills:

Experience building, tuning, deploying and maintain SSAS cubes
Experience creating SSRS reports
Experience writing C# and/or VB.NET code

Desired Profile:

Experience 4 – 8 Years
Industry Type IT-Software / Software Services
Role Software Developer
Functional Area IT Software – Application Programming, Maintenance

UG – B.Tech/B.E. – Any Specialization

PG – M.Tech – Any Specialization

Doctorate – Any Doctorate – Any Specialization, Doctorate Not Required


Not disclosed


Hyderabad / Secunderabad

SSAS SSIS SSRS OLAP ETL Data Warehousing Business Intelligence Corrective Action

FactSet Systems India Private Limited