Job Description :
Description:
Experience with ETL processing using SSIS
Experience with Modelling using SSAS
Experience with Reporting using SSRS
Be adept to documenting as part of communication, such as ER diagramming, architecture visualizations, data process flows, etc . . .
Must possess SQL programming and SQL tuning skills
Experience writing and tuning stored procedures
Expert knowledge of Relational databases such as SQL Server, Oracle,
Experience in an Agile based delivery environment
Detail oriented with strong analytical and organizational skills to effectively work in a dynamic environment
Results driven with an ability to multitask and meet aggressive deadlines
Experience Required:
Hands-on Experience on Developing and Supporting Data Warehouses (ETL) in an Enterprise Environment, Supporting Windows SQL Server with large Data Volumes and Complex Data Processes
Hands-on Experience in Data Modelling (conceptual, logical, and physical) across various Business Subject Areas. Data Models presented in an Enterprise Business Intelligence Suite
Experience in writing SQL Queries and Database and SSRS Report
Responsibilities:
Develop robust ETL packages and support finance budget / reforecasting processes. Ensure data integrity, validity, accuracy, completeness and quality through data acquisition process design and process monitoring capabilities
Identify opportunities for usability improvements, simplification and standardization across ETL package and process
Responsible for the company''s enterprise data warehouse design, development, operations and maintenance
Design, develop, and operationalize complex logical and physical data models that meet complex business analytical needs
Manage quality aspects of offshore and outsourced development initiatives
Support ad hoc business data requests by understanding requirements and developing queries/SSRS reporting to present necessary data
Must have excellent analytical capability and comprehension of business challenges and address them during technical design
Responsible for effective communication and interaction with business users and documenting
Responsible for meeting project objectives on time