Responsibilities

  • Technical design, development, testing, documentation of Data Warehouse / ETL projects
  • Design, develop, and implement end to end data pipelines and integration process. This include: data analysis, data discovery, data profiling, data cleansing, data lineage, data mapping, data masking, ETL, and deployment of the data solution.
  • Recommend, develop, and implement ways to improve data reliability, data efficiency, and data quality
  • Have the ability to work with users, project team, as well as business partners to get ETL solutions developed and implemented
  • Performance tuning and enhancement of SQL and ETL processes and prepare related technical documentation
  • Help build solutions pertaining to analytics and Big data
  • Communicate very clearly and professionally with users, peers, and all levels of management. The communication forms include written and verbal methods
  • Lead the team members to work with end users to resolve data pipeline issue.
  • Provide ETL components for standard bid proposals and justify functional components in the proposed solution.

Requirements

  • More than 5 years in ETL
  • Preferred experience with other ETL tools, like Informatica, SAS, SSIS
  • Preferred experience in Tableau, SAS, Qlik or other BI applications
  • Preferred with experience in Big Data projects
  • Expert knowledge of data warehouse architecture
  • Expertise in dimensional modeling, star schema designs including best practices for use of indexes, partitioning, and data loading.
  • Advanced experience in SQL, writing Stored procedures and tuning SQL
  • Strong experience & working knowledge with Talend software
  • Independent problems solving skills.
  • Strong interpersonal and communication skills and ability to interact positively with peer groups within IT / BI teams, management, customer and business partners.
  • Open to learn and acquire new skills.