ETL Analyst

ETL Analyst

Tata Consultancy Services
Hong Kong
3-7 years
Not Specified

Job Description

· Understand High Level Design, Application Interface Design & build Low Level Design
. Perform application analysis & propose technical solution for application enhancement or resolve production issues.
· Requirement analysis and detailed documentation of ETL jobs
· Design Unix Wrapper shell scripts which in turn Informatica Workflows, SQL and other Unix code.
· Test Planning and Design of developed codes including preparation ofUnit Test case documents
· Perform Development & Support activities for Data warehousing domain using ETL Tools and Technologies.
· Liaise with Functional and Operations teams to translate Functional Specifications into warehousing technical specifications.
· Should be able to work in on Data Modeling, Data Load Strategies, Data Validation, Data Export to consuming systems, Error Handling, Creation of Landing, Staging and Base object, Defining Match and Merge Process, Building Hierarchy for Customer and Supplier entities
· Interact with Enterprise/Solution Architects (EA),Business Analysts (BA) to gather high level business requirements.
· Manage cross-team relationships and gather feedback to influence program design, approach, and workflows.
· Being Agile team player with the ability to manage own workload and demonstrates a sense of accountable, responsible, commitment

Technical Skills Must Have ·
ETL tool –Informatica Power center, Datastage , SAP BODS ,
· Scripting - SQL and Unix
· DB- Oracle DB,MS SQL Server

Technical Skills Good to Have
· Informatica Power Center ,Data stage, Data warehousing concepts
Soft Skills
· Experience in work as Lead, Developer and Analyst ·
Good Analytical skills and understanding of application requirements
· Good communication skills
· Able to handle multiple requirements.

Job Details

Employment Types:




Tata Consultancy Services is an IT services, consulting and business solutions organisation that delivers real results to global business, ensuring a level of certainty no other firm can match. TCS offers a consulting-led, integrated portfolio of IT, BPS, infrastructure, engineering and assurance services. This is delivered through its unique Global Network Delivery Model™, recognised as the benchmark of excellence in software development. A part of the Tata group, India’s largest industrial conglomerate, TCS has over 378,000 of the world’s best-trained consultants in 45 countries. The company generated consolidated revenues of US $16.5 billion for year ended March 31, 2016 and is listed on the BSE (formerly Bombay Stock Exchange) and the NSE (National Stock Exchange) in India. For more information, visit us at

About Recruiter




Active jobs

Functions : IT

Industries : IT/Computers - Hardware, IT/Computers - Software

Skills/Roles I hire for: Lateral hiring

level Hiring For: Junior Level, Mid Level, High Level, Top Management

Similar Jobs

Career Advice to Find Better