Job Description :

 

Location Jersey city NJ(initially remote  ) or Pleasant Prairie ,WI – 3 days a week.

 Oracle/ETL Developer with Python and sql

About the role

 

  • Build efficient ETL mechanism (IBM datastage and SQL) for processing fact and dimension tables with complex Transforms and type 1 and type 2 slowly changing dimensions..
  • Create IBM Infosphere datastage jobs to populate the data into dimensions and fact tables using different stage in IBM suite
  • Develop Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart
  • Experience in creating Adhoc reporting ready universes using Business Objects Universe Designer
  • Extensive experience with PL_SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User and Data Integrity.
  • Build shell scripts to create ETL pipelines to load data into data lakes consuming data from different databases and files such (as .txt,.xlsx,.csv,.xml etc.)
  • Familiarity with Python scripting for troubleshooting purpose
  • Strong experience and understanding of Architectural, Designing and Operationalization of large-scale Data and Analytics solutions for Datawarehouse, Data marts and Data Lakes
             

Similar Jobs you may be interested in ..