Required Skills

ETL PROD

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 2nd Aug 2022

JOB DETAIL

  1. Understanding the business functionality & Analysis of business requirements.
  2. Analyzing the root cause for the issues raised by the business users and advising the developers for permanent solutions.
  3. Proactively monitoring the batch jobs for any failure and find the root cause for the failure and resolve it.
  4. Handling the Production support on daily basis and sometimes on weekend support.
  5. Managing the ETL Servers and doing the patches for fixing the vulnerabilities.
  6. Check the disk usage and help in space clean up.
  7. Assigning the roles for the infosphere users to access respective client tools.
  8. Deploy the ETL Jobs and Migrate the Jobs from Lower to PROD Environment.
  9. Setting up ODBC Connections for any New source data on the Engine server.
  10. Used various stage like ODBC, Transformer, Lookup, Join and datasets for building the ETL jobs.
  11. Created Job sequencer for dependency jobs and monitor the jobs in Director.
  12. Handling and resolving the user tickets on priority basis.
  13. Good knowledge on Database concepts(Sql server will be preferred not mandatory)
  14. Good knowledge on writing SQL queries and sometimes may write or analyze the complex queries and find the root cause of data issues.

Company Information