Job Description :

 Job Title: Datastage Developer

  Location: Dallas TX ( REMOTE )

 Duration: 12 + months 
 

 Technical Skills: 

  • Datastage 9.x and above
  • Unix Shell Scripting
  • Datastage Development on Oracle 11g,12c

Job Description

Experience in Datastage 9.x or above. 
Should be conversant in using various stages, sequence Activities, dynamic loading of data from different file formats, and Oracle and SQL Server
Should be familiar with modifying stage properties for a given requirement.
Good to have proficiency in using Oracle PL/SQL features like Built-In Functions, Analytical Functions, Cursors, Cursor variables, 
Should have hands-on UNIX shell scripting
Strong experience in a BI/Data Warehouse environment with involvement in design, development, implementation, Unit Testing troubleshooting, and support of ETL process using Talend (Necessary) and Datastage (Preferable)
Experience in defining Datastage ETL development standards and best practices
Experience in cloud databases e.g. snowflake 
Experience in developing Data Marts, Data warehousing, and Operational Data Store (ODS) on any of the databases or Hadoop environments
Should be having good experience with DWH concepts, and other DWH related terms
Experience in Performance Tuning and Query Optimization by Indexing, Partitioning, and De-normalization
Should be well versed with migration strategies by manual and automated processes
Should have experience in supporting the environment team for all the migrations, and other activities
Extensive knowledge of business intelligence best practices, processes, and methodologies.
Good to have programming experience in writing Complex Stored Procedures, Queries, Views, User Defined Functions, Cursors and Common Table Expressions using SQL or T-SQL
Excellent interpersonal, communication skills (both verbal and written), and ability to interact with and effectively address concerns
Excellent prioritization, time management, analytical, and organization skills - able to determine
Follow naming conventions and code practices
Experience working in an Agile Environment, preferred
 

             

Similar Jobs you may be interested in ..