Citizen
Full Time
Direct Hire
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 25th May 2022
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.