Redshift Architect Senior Manager L2

Wipro Limited (NYSE: WIT BSE: 507685 NSE: WIPRO) is a leading technology services and consulting company focused on building innovative solutions that address clients most complex digital transformation needs. Leveraging our holistic portfolio of capabilities in consulting design engineering and operations we help clients realize their boldest ambitions and build future-ready sustainable businesses. With over 230000 employees and business partners across 65 countries we deliver on the promise of helping our customers colleagues and communities thrive in an ever-changing world. For additional information visit us at .

Job Description

Redshift Architect Senior ManagerL2

Design develop and maintain enterprise-scale data warehouse solutions using Amazon Redshift .Create and manage logical conceptual and physical data models for analytical and reporting complex SQL queries stored procedures views and ETL/ELT transformations for large-scale Redshift performance tuning and optimization including:Query performance tuningDistribution key and sort key optimizationWorkload Management (WLM) configurationVacuum Analyze Compression encoding strategies Spectrum optimizationMaterialized views and implement scalable data ingestion and transformation pipelines using AWS services. Work closely with business stakeholders architects analysts and development teams to understand data requirements and translate them into technical solutions.

Technical Skills:

• Need 10 years of experience in Data Warehousing and Data Engineering .
• 5 years of hands-on experience with Amazon Redshift .
• Strong expertise in Data Modeling :Dimensional Modeling (Star Schema and Snowflake Schema)
• Data Vault Modeling:Normalized and Denormalized Data Models
• Advanced proficiency in SQL and query optimization.
• Strong experience in Redshift performance tuning and optimization .

Mandatory Skills: App-Cloud-Amazon-AWS.

Experience: >10 YEARS.

The expected compensation for this role ranges from $100000 to $220000 .

Final compensation will depend on various factors including your geographical location minimum wage obligations skills and relevant experience. Based on the position the role is also eligible for Wipros standard benefits including a full range of medical and dental benefits options disability insurance paid time off (inclusive of sick leave) other paid and unpaid leave options.

Applicants are advised that employment in some roles may be conditioned on successful completion of a post-offer drug screening subject to applicable state law.

Wipro provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race color religion age sex national origin disability status genetics protected veteran status sexual orientation gender identity or expression or any other characteristic protected by federal state or local laws. Applications from veterans and people with disabilities are explicitly welcome.

Reinvent your world. We are building a modern Wipro. We are an end-to-end digital transformation partner with the boldest ambitions. To realize them we need people inspired by reinvention. Of yourself your career and your skills. We want to see the constant evolution of our business and our industry. It has always been in our DNA - as the world around us changes so do we. Join a business powered by purpose and a place that empowers you to design your own reinvention.

Required Experience:

Senior Manager