Talend RedShift Developer 9 C2C

• Design, develop and implement databases, data collection systems, data analytics and other strategies to support the tactical and strategic reporting and analytics needs.
  
• Develop and maintain scripts and queries to import, manipulate, clean, transform data from different sources
  
• Perform quality assurance on generated results to ensure accuracy and consistency using
  
• Data visualization software and techniques
  
• Design, evaluate and monitor key metrics, understanding root causes of changes in metrics
  
• Developing and publishing Talend Jobs.
  
• Participate in analysis sessions to understand functional and non-functional requirements
  
• Document application designs, data structures.
  
• Provide technical insight and develop work estimates to project planners
  
• Deploy and maintain application services in a production environment
  
• Continuously optimize, enhance and monitor support and maintain all Talend data integration processes
  
• Should be responsible for building extraction and mapping rules for loading data from multiple sources for data warehouse implementation based on MS Azure
  
• Must have strong knowledge on Data Warehousing (DWH) concepts, ETL concepts, data analysis capabilities and experience in the Talend
  
• Design and oversee develop data warehouse in Amazon Redshift. Develop new test environment for replicating the production environment for troubleshooting complex scenarios as in production.
  
• Verify RDS, Amazon Redshift, EC2 instances, S3 bucket policy for the new AWS account creation and setting up a new preprod environment.
  
• Delegate Talend Remote Engine installation, migration, and running all the current jobs into the new AWS environment on redshift database.
  
• Experience in Talend Data Stewardship Console and Data Prep
  
• Strong experience in Data Quality, Source Systems Analysis, Business Rules Validation, Source Target Mapping Design, Performance Tuning and High volume Data Loads
  
• Work with business users to translate requirements into system flows, data flows, data mappings etc., and develop solutions to complex business problems
  
• Maintain workload and time tracking within Jira
  
  

Requirements

• Must be fully proficient with development and administration of Talend Open Studio and Talend Server.
  
• Experience on AWS Environment with RedShift Database
  
• Programming ability in Java
  
• Experience working with Oracle Database.
  
• Thorough knowledge and understanding of all aspects of Data warehouse design and development.
  
• Strong communication skills in English, written and verbal.