ETL Datastage Developer

From 5 to 10 year(s) of experience
₹ 15,00,000 - 19,00,000 P.A.

Job Description

Hello ,

Greetings from NCG...

We are Hiring for ETL Datastage Developer

Experience:- 5 To 12 Years.

JD:-

Should have exp in ETL Datastage Developer


Location: Bangalore.


we are Looking for ETL data stage support and development resource who is having minimum of 7years

experience in data warehousing on large scale of support should have sound knowledge of oracle database like PL/SQL Sql joining queries etc.. should able to Designed Technical specifications and Mapping docs with Transformation rules Automation of workflow runs batch and nightly runs using scheduler Developed number of complex Data stage jobs sequences and shared containers. Troubleshooting of ETL jobs and addressing production issue and suggest job enhancements. Knowledge of Banking domain is a plus.

Technical requirements.
==========================
Data stage (ETL ) development & support experience : 5 years
Oracle Database Knowledge : 4 years
Unix scripting Knowledge : 4 years

Functional skill set.
====================================
Excellent Verbal and written communication skills with good presentation skills
Should have excellent problem solving abilities
Should be a team player

As a ETL Specialist include:
==============================
Sourcing the data from the operational systems
Applying the business transformation rules
Preparing a database-loadable file for the Data Warehouse
Management of the deployment of the data acquisition tool(s)
Contributing the technical metadata to the metadata repository
Work with the source system analysts to understand the windows available for data extraction
Supporting BI solutions by: monitoring and tuning queries and data loads addressing user questions concerning data integrity
Monitoring performance and communicating functional and technical issues & Should be able to translate business requirements into Design Specs
Must to have experience in employing all of the Datastage transformations/techniques
Experience in developing DataStage (11.5) solutions
Experience on Grid architecture and the working of DataStage tool.
Sound knowledge in SQL PL/SQL to manipulate the data.
Able to implement Scripting Language in order to optimize the DataStage Batch
Able to Designs code test debugs document and implement ETL interfaces and UNIX scripts
Should be able to provide guidance and support to less experienced team members for design development testing and implementation
knowledge in Shell Scripting to manipulate the source files as per prescribed requirements.
Program test implement and maintain any data extraction programs necessary to extract the data from the operational systems needed to be moved to the Data Warehouse
Programming the data acquisition tool with the rules to be applied to the data
Ensuring the correct application of the business rules through data query after the data is loaded into the Data Warehouse.
Knowledge of the data sources transformation rules and uses of the data for the area of stewardship



Kindly send your applications to mohanlal.b@netconnectglobal.com.

Role:Software Development - Other

Salary: 15,00,000 - 19,00,000 P.A.

Industry:IT Services & Consulting

Functional Area:Engineering - Software & QA

Role Category:Software Development

Employment Type:Full Time, Permanent

Key Skills

Education

UG:Any Graduate

Company Profile

Net Connect Pvt Ltd

ibm

Company Info
X
View Contact Details+

Contact Company:Net Connect Pvt Ltd

Address:SALARPURIA SYMBIOSIS, WEWORK, AREKERE VILLAGE,, BENGALURU-560076, Karnataka, India., BANGALORE, Karnataka, India