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.