Job Description :

Datastage Developer - Dallas TX ( REMOTE )

 

 Technical Skills: 

 

• Datastage 9.x and above

• Unix Shell Scripting

• Oracle SQL, PL/SQL Development on Oracle 11g,12c

 

 

  • 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 ..