Job Description :

DA : Trianz/ New York life



Location Jersey city NJ(local)

Experience : 9+


Oracle/ETL Developer with Python.

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


Client : Trianz/ New York life


Similar Jobs you may be interested in ..