Data Engineer - Manager

  • Competitive
  • Singapur, Singapore
  • Festanstellung, Vollzeit
  • Cognizant Technology Solutions APAC
  • 13 Dez 18

Data Engineer - Manager

Job Description

1. Designs and creates information store / data warehouse and allrelated extraction, transformation and load of data functions
2. Experts at taking a big-picture view of a company's data situation
3. Proficient in able to read, analyze and digest what a business wants toaccomplish with its data, understand data models and translate them into thebest possible design of Databases and ETL processes
4. Executes basic and advanced transformation activities such as normalization,cleansing, aggregation, summarizing, and integration
5. Designs automation processes to control data access, transformation andmovement; ensures source system data availability and update accessibility,data integrity, restorability and appropriately handles errors in a timelymanner
6. Develops logical and physical data flow models for ETL applications.Translates data access, transformation and movement requirements intofunctional requirements and mapping designs
7. Plans and conducts ETL unit and development tests; monitors results andtakes corrective action, when necessary
8. Plans, coordinates and implements security measures to safeguard data ininformation store / datawarehouse against accidental or unauthorized damage, modificationor disclosure
9. Analysis of business requirements document created by Data Architect team
10. Create SSIS packages based on mapping document
11. Unit test & optimize SSIS package according to business needs
12. Document technical details of ETL project in Excel & word documents
13. Code maintenance in TFS (Branching/Merging)
14. Contact Data Architects for any queries/confusions/design changes for IS

JobRequirements (Please specify mandatory skills, additional skills)

1. Bachelor's degree or equivalent inrelevant discipline.
2. Minimum 5 yrs. exp. working on MSBI Stack (SSAS, SSIS, SSRS)
3. Minimum 5 yrs. exp. working on SQL Server, DB2, Oracle databases
4. Working knowledge of modeling tools (Erwin, Embarcadero, EA Sparx etc.) inaddition to hands-on experience with business intelligence tools
5. Mandatory Technical expertise in:
• MS SQL Server 2008 R2 - FastTrack Data Warehouse
• Databases - DB2, SQL Server, Oracle (Must be able to write complex queriesagainst these DBs)
• SQL Server Integration Services (Writing efficient SSIS packages)
• Any data replication tool (preferred: MS SQL Server, DT Share)
• Writing complex & efficient Stored Procedures, Views, Functions in MS SQLServer
• Optimizing complex SQL queries for optimum performance
• Setting up schedule jobs using Windows Scheduler or SQL Agent
• Any Data Quality Tools - Preferred: TIBCO Trillium, MS DQS
• Any Master Data Management Tools - Preferred: TIBCO MDM, MS MDS
6. Technical expertise in the following areas are a plus:
• ETL experience with SAS Enterprise Guide
• Knowledge of Casino Management Systems - ACSC
• SQL Server Reporting Services