Under Development Features: Talent Bank/Pool, VMS Intigration, Analytics, Social Integration, Reports, API Integration, Resource and Timesheets Management, Company Admin

Senior Datastage Developer (93 views)

US (initially remote)
September 10, 2021

***** Direct Client Requirement*****

Title                                    : Senior Datastage Developer

Location                             : Charlotte, North Carolina, US (initially remote)

Rate                                    : DOE /If your experience and skills match call us immediately for submission

Duration                             : Long Term on Contract

Interview Type                   : Web Cam Interview

Job Type                            : W2

Experience                        :  8 Years

A Senior Datastage Developer:

  1. 6+ years of experience in Datastage 9.x or above.
  2. Should be conversant in using various stages, sequence Activities, dynamic loading of data from different file formats and Oracle and SQL Server
  3. Should be familiar with modifying stage properties for a given requirement.
  4. Good to have proficiency in using Oracle PL/SQL features like Built In Functions, Analytical Functions, Cursors, Cursor variables,
  5. Should have hands-on unix shell scripting
  6. 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)
  7. Experience in defining Datastage ETL development standard and best practices
  8. Experience in cloud database e.g. snowflake
  9. Experience in developing Data Marts, Data warehousing and Operational Data Store (ODS) on any of the databases or Hadoop environments
  10. Should be having good experience with DWH concepts, and other DWH related terms
  11. Experience in Performance Tuning and Query Optimization by Indexing, Partitioning and De-normalization
  12. Should be well versed with migration strategies by manual and automated processes
  13. Should have experience in supporting the environment team for all the migrations, and other activities
  14. Extensive knowledge of business intelligence best practices, processes, and methodologies.
  15. 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
  16. Excellent interpersonal, communication skills (both verbal and written), and ability to interact with and effectively address concerns
  17. Excellent prioritization, time management, analytical, and organization skills – able to determine
  18. .Follow naming conventions and code practices
  19. Experience working in an Agile Environment, preferred

Technical Skills:

  1. Datastage 9.x and above
  2. Unix Shell Scripting
  3. Oracle SQL, PL/SQL Development on Oracle 11g,12c

Qualification:

Any Degree from a reputed college – B.Tech, BE, BCA, MCA, M. Tech or equivalent technical degree is preferred

*****Referral Bonus Available: Refer your friends or colleagues, get referral bonus*******

Thanks

Sai sree/Siva

Sree@SohanIt.com/siva@Sohanit.com

PH: 470-480-2408 EX 102/470-480-2407 EX 101

Apply here or please send to resumes@sohanit.com

Follow us on LinkedIn and Twitter for daily active requirements

LinkedIn: https://www.linkedin.com/company/sohanit-inc/?viewAsMember=true

Twitter: https://twitter.com/SohanITInc1

Position Keywords: Datastage 9.x,Oracle and SQL Server,Oracle PL/SQL,Datastage ETL,Agile,Unix Shell Scripting

Pay Rate: DOE /If your experience and skills match call us immediately for submission

Job Duration: 12 Months

% Travel Required: None

Job Posted by: Consulting Services

Don't have time now?
Get a reminder in your inbox