Data Engineer

  • Competitive
  • Singapur, Singapore
  • Festanstellung, Vollzeit
  • Cognizant Technology Solutions APAC
  • 17 Feb 18 2018-02-17

Data Engineer

1. Designs and creates information store / data warehouse and all related 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 to accomplish with its data, understand data models and translate them into the best 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 and movement; ensures source system data availability and update accessibility, data integrity, restorability and appropriately handles errors in a timely manner
6. Develops logical and physical data flow models for ETL applications. Translates data access, transformation and movement requirements into functional requirements and mapping designs
7. Plans and conducts ETL unit and development tests; monitors results and takes corrective action, when necessary
8. Plans, coordinates and implements security measures to safeguard data in information store / datawarehouse against accidental or unauthorized damage, modification or 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
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, Oracle databases
4. Working knowledge of modeling tools (Erwin, Embarcadero, EA Sparx etc.) in addition 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 queries against 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 SQL Server
• 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
• TIBCO SpotFire

Technical Skills
SNo Primary Skill Proficiency Level * Rqrd./Dsrd. 1 Microsoft SSIS NA Required 2 SQL Scripting NA Required 3 Unix Shell Scripting NA Desired 4 MS SQL Server NA Required

* Proficiency Legends
Proficiency Level Generic Reference PL1 The associate has basic awareness and comprehension of the skill and is in the process of acquiring this skill through various channels. PL2 The associate possesses working knowledge of the skill, and can actively and independently apply this skill in engagements and projects. PL3 The associate has comprehensive, in-depth and specialized knowledge of the skill. She / he has extensively demonstrated successful application of the skill in engagements or projects. PL4 The associate can function as a subject matter expert for this skill. The associate is capable of analyzing, evaluating and synthesizing solutions using the skill.

About Cognizant
Cognizant (NASDAQ-100: CTSH) is one of the world's leading professional services companies, transforming clients' business, operating and technology models for the digital era. Our unique industry-based, consultative approach helps clients envision, build and run more innovative and efficient businesses. Headquartered in the U.S., Cognizant is ranked 205 on the Fortune 500 and is consistently listed among the most admired companies in the world. Learn how Cognizant helps clients lead with digital at or follow us on Twitter: Cognizant.