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.