Create and maintain optimal data pipeline architecture,

• Assemble large, complex data sets that meet functional / non-functional business requirements.
• Identify, design, and implement internal process improvements : automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS ‘big data’ technologies.
• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics.
• Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.
• Keep our data separated and secure across national boundaries through multiple data centers and AWS regions.
• Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.
• Work with data and analytics experts to strive for greater functionality in our data systems.
• Troubleshoots issues with minimal guidance, identifies bottlenecks in existing data workflows and provides solutions for a scalable, defect-free application
• Works with onshore / offshore team to analyze, develop and improve pipeline run times as well as produce accurate defect free code
• Complies with Company policy and practices relating to the System Development Life Cycle.
• Provides Tier 3 support and resolution of IT issues escalated by IT Customer Support.
• Support audit and compliance reporting requests.
• Support the operation of MarkLogic and Snowflake products on a 24 / 7 basis as needed.
• Supports production environment in the event of emergency
• Participate in on-call support 24x7 weekly rotation of the operation of Informatica.
• Performs other job-related duties as assigned or apparent.

Required Skills : Snowflake, AWS, S3, Lambda, Python