Previous Job
Senior Technical Consultant/ETL
Ref No.: 17-00646
Location: San Francisco, California
Position Type:Direct Placement
Start Date: 04/17/2017
  • Understand, define and implement requirement for a new system. Be technically sound to understand all interfacing applications, and come up with a robust solution that follows industry wide standards.
  • Understand and define the business problem by conferring with clients; evaluating procedures and processes
  • Design overall solution by preparing and evaluating various scenarios such as and not limiting to:
    • Design or review ETL jobs to source data
    • Design or review major components of web-application, including integration with ETL jobs and Viz libraries
    • Design or review dashboards created in the Viz tool
  • Plan and monitor development of various builds
  • Be responsible for development and deployment process from initiation to finish.
  • Manage and create project documentation, including project management documentation
  • Co-ordinate with offshore team for schedule and quality of deliverables

  • Excellent client communication
  • Excellent understanding of ETL concepts –
    • At least 4 years' experience on one major ETL tool (Informatica, SSIS, Data Stage)
      • Data sourcing, data cleaning, data aggregation.
      • ETL Job scheduling, job performance monitoring
      • Writing DML queries, stored procedures, UDF
  • Good understanding of developing web or windows based applications
    • At least 4 years' experience creating web based applications using
      • ASP.Net framework 3.5 or above
      • C# as programming language
      • Jquery / Javascript
      • CSS
      • Consuming Rest API / web services
  • Good understanding of visualization tools
    • At least 2 years' experience creating or integrating visualization dashboards in
      • Tableau or,
      • Micro-strategy or,
      • QlikVie
  • With web or windows based applications. Understanding of Javascript libraries of the above Viz software.
  • Basic understanding of Hadoop/Data lake tools
    • At least 1 year experience of interfacing w/ or building assets in Hadoop ecosystem using
      • Hive or,
      • Pig or,
      • Oozie workflows or,
      • Python scripts or,
      • Making rest API calls to data lake management platform
  • Understanding of the US healthcare domain is a plus
  • Project management skills is a plus