Data Engineer

  • Competitive
  • Singapore
  • Permanent, Full time
  • Cognizant Technology Solutions APAC
  • 18 Mar 19

Data Engineer

Job Description

1. Designs and creates information store / data warehouseand all related extraction, transformation and load of data functions
2. Experts at taking a big-picture view of a company's datasituation
3. Proficient in able to read, analyze and digest what abusiness wants to accomplish with its data, understand data models andtranslate them into the best possible design of Databases and ETL processes
4. Executes basic and advanced transformation activitiessuch as normalization, cleansing, aggregation, summarizing, and integration
5. Designs automation processes to control data access,transformation and movement; ensures source system data availability and updateaccessibility, data integrity, restorability and appropriately handles errorsin a timely manner
6. Develops logical and physical data flow models for ETLapplications. Translates data access, transformation and movement requirementsinto functional requirements and mapping designs
individual, in this role, is expected to be comfortableworking as a data expert and a quantitative researcher.
The ideal candidate will have a keen interest in the studyof business problems relevant to Technology Service Providers (CSP), and apassion for identifying and answering questions that help us solve the complexbusiness problems.

7. Plans and conducts ETL unit and development tests;monitors results and takes corrective action, when necessary
8. Plans, coordinates and implements security measures tosafeguard data in information store / datawarehouse against accidental orunauthorized damage, modification or disclosure
9. Analysis of business requirements document created byData Architect team
10. Create SSIS packages based on mapping document
11. Unit test & optimize SSIS package according tobusiness needs
12. Document technical details of ETL project in Excel &word documents
13. Code maintenance in TFS (Branching/Merging)
14. Contact Data Architects for anyqueries/confusions/design changes for IS

• Key qualifications/requirements
1. Bachelor's degree or equivalent in relevant discipline.
2. Minimum 5 yrs. exp. working on MSBI Stack (SSAS, SSIS,SSRS)
3. Minimum 5 yrs. exp. working on SQL Server, DB2, Oracledatabases
4. Working knowledge of modeling tools (Erwin, Embarcadero,EA Sparx etc.) in addition to hands-on experience with business intelligencetools
5. Mandatory Technical expertise in:
• MS SQL Server 2008 R2 - FastTrack Data Warehouse
• Databases - SQL Server, Oracle (Must be able to writecomplex queries against these DBs)