Responsibilities:
• Be a key team member assisting in design and development of the data pipeline for Global Data and Analytics team
• Collaborate with Data Architects, Business SME's, and Data Scientists to design and develop end-to-end data pipeline to meet fast paced business need across geographic regions
• Adhere to best practices for coding, testing and designing reusable code/component
• Able to explore new tools, technologies that will help to improve ETL platform performance
• Participate in sprint planning meetings and provide estimations on technical implementation; Collaborate and communicate effectively with the product teams
Preferred Qualifications:
• Experience with software development (Java, Python preferred), end-to-end system design
• Experience with data modeling for both OLAP and OLTP databases, hands-on experience with SQL, preferred Oracle, PostgreSQL, and Hive SQL
• Experience with ETL tool, for example Informatica PowerCenter
• Ability to learn quickly, be organized and detail oriented
• Hands on development experience with Informatica Power Center, MDM, Data Integration Hub
• Experience with software DevOps CI/CD tools, such Git, Jenkins
• Experience on AWS, familiar with EC2, S3, Redshift/Spectrum, Glue, Athena, RDS, Lambda, and API gateway
• Experience with Apache Airflow and Apache Spark
• Experience with Tableau Dashboard and Tableau Server
• Experience with Pharmaceutical industry, commercial operations
Data Integration
Data Modeling
Data Structures
Data Visualization
Etl
• Be a key team member assisting in design and development of the data pipeline for Global Data and Analytics team
• Collaborate with Data Architects, Business SME's, and Data Scientists to design and develop end-to-end data pipeline to meet fast paced business need across geographic regions
• Adhere to best practices for coding, testing and designing reusable code/component
• Able to explore new tools, technologies that will help to improve ETL platform performance
• Participate in sprint planning meetings and provide estimations on technical implementation; Collaborate and communicate effectively with the product teams
Preferred Qualifications:
• Experience with software development (Java, Python preferred), end-to-end system design
• Experience with data modeling for both OLAP and OLTP databases, hands-on experience with SQL, preferred Oracle, PostgreSQL, and Hive SQL
• Experience with ETL tool, for example Informatica PowerCenter
• Ability to learn quickly, be organized and detail oriented
• Hands on development experience with Informatica Power Center, MDM, Data Integration Hub
• Experience with software DevOps CI/CD tools, such Git, Jenkins
• Experience on AWS, familiar with EC2, S3, Redshift/Spectrum, Glue, Athena, RDS, Lambda, and API gateway
• Experience with Apache Airflow and Apache Spark
• Experience with Tableau Dashboard and Tableau Server
• Experience with Pharmaceutical industry, commercial operations
Recommended Skills
Data Engineering Scripting LanguageData Integration
Data Modeling
Data Structures
Data Visualization
Etl