Job Description :

DA : Trianz/ New York life

 

C2C

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