AVP, AWS Redshift AVP, AWS Redshift …

State Street Corporation
à Bangalore, Karnataka, Inde
CDI, Plein-temps
Soyez parmi les premiers à postuler
State Street Corporation
à Bangalore, Karnataka, Inde
CDI, Plein-temps
Soyez parmi les premiers à postuler
State Street Corporation
AVP, AWS Redshift
Job description Your Role and Responsibilities SSGA Technology & Architecture is focusing on adopting a computing framework for its analytic applications using Open Source and open/private cloud hosting. It encompasses Architecture & Development of Analytic computing framework in Cloud, Migration of Data & Compute to Cloud and Cloud Operations, etc. As a member of a high performing group you will be responsible for designing, developing and implementing cloud solution, optimizing the performance and quality of the solutions.
A day in the role will include...
  • Design & develop data pipeline for consolidation of several data marts/on-premise data warehouse to AWS Redshift.
  • Design & develop Datawarehouse in AWS Redshift which includes migration and transformational projects, and design large-scale data processing systems, develop data pipelines optimized for scaling, and troubleshoot potential platform issues
  • Implement automated ETL workflow tools and routines using tools like Airflow
  • Ability to lead and mentor team members (employees and contractors) and influence and communicate with business stakeholders
  • Drive collaborative reviews of design, code, test plans and dataset implementations and maintain high quality standards
  • Troubleshoot complex data issues and perform root cause analysis to resolve operational issues

Required Technical and Professional Expertise
  • 12-15 yrs overall IT experience with at least 8 years of expertise in any of the Datawarehouse including Teradata, Netezza, Redshift or Snowflake
  • Experience working in with AWS Ecosystem and expertise in AWS Pipeline knowledge to develop ETL for data movement to Redshift, experience to map the source to target rules and fields
  • Experience with performance tuning, parallel query optimization and execution, large scale data analytics
  • Database Modeling and Design for Enterprise Data Warehousing (star, snowflake modelling)
  • Expert working with any major data Expert in PL/SQL and develop Stored Procedure
  • Working knowledge in Unix, Linux env; Expert in writing bash/shell scripts
  • Experience in writing Python scripts for ETL/Data pipeline
  • Exposure to distributed computing including Spark, Airflow, Hadoop, EMR, Data Bricks
  • Exposure to running/configure/developing Spark jobs

Additional Qualifications
  • A minimum of a bachelor degree in Computer Science or other relevant subject area
  • Experience working in a fast-paced, result-oriented environment
  • Demonstrated the ability to learn new technologies and skillsets
Descriptif de l'entreprise

From technology and product innovation to corporate responsibility and community development, we're making our mark on the financial services industry. For more than two centuries, we've been helping our clients safeguard and steward the investments of millions of people - strengthening markets, building communities and creating opportunities for growth.

We owe that longevity to the commitment, expertise and creativity of our employees. Our continued success depends on our ability to attract and develop the best talent in the industry. That's why we're keenly focused on employee development, corporate citizenship and inclusion.

For us, success comes in the mark we make as an organization - for the industry, our clients, our communities and each other.

State Street Corporation logo
Offres similaires
Plus d'offres