Principal Specialist - SQL Developer
Job Details
Date Posted:
2024-09-06Country:
IndiaLocation:
North Gate Business Park Sy.No 2/1, and Sy.No 2/2, KIAL Road, Venkatala Village, Chowdeshwari Layout, Yelahanka, Bangalore, Karnataka 560064Position Role Type:
UnspecifiedPratt & Whitney is working to once again transform the future of flight—designing, building and servicing engines unlike any the world has ever seen. And because transformation begins from within, we’re seeking the people to drive it. So, calling all curious.
Come ready to explore and you’ll find a place where your talent takes flight—beyond the borders of title, a country or your comfort zone. Bring your passion and commitment and we’ll welcome you into a tight-knit team that takes our mission personally. Channel your drive to make a difference into shaping an organization and an industry that’s evolving fast to the future.
Innovation through diversity of thought. At Pratt & Whitney, we believe diversity of thought enables creativity, innovation, and a foundation for inclusion. By fostering an inclusive culture, we accept a shared accountability and responsibility to recognize, sponsor, coach, hire and promote talent equally. We welcome our employees to be their whole - best - selves at work because trust, respect and integrity, are a part of our DNA.
At Pratt & Whitney, the difference you make is on display every day. Just look up. Are you ready to go beyond?
Summary:
We are seeking a highly motivated SQL developer to join the analytics and information management (AIM) team of Pratt and Whitney. You will be working collaboratively to deliver strategics data driven initiatives in respect of best-in-class data management principles. You will play an active role in designing and building big data pipelines and enabling the technologies to create the efficient data flows required by various application databases and analytics datamarts in a wide variety of areas across the business.
This role requires a deep understanding of SQL, databased design, data modeling and ETL development with SQL server integration service.
Key Responsibilities:
Design application databases with efficient and normalized databases schemas
Design, write and deploy data pipeline developed in SQL server integration services (SSIS)
Creating, maintaining and optimizing database objects like indexes, triggers, views, stored procedures etc
Strong SQL expertise must be able to write complex and dynamic query
Design, write and deploy data pipeline developed in SQL server integration services (SSIS)
Development of data transformation to support business intelligence (BI) reporting
Collaboration with database administrator (DBA) to optimize queries and database performance
Participate in technical planning session with solution architect, Product owner and application developers
Leading practice disciplined software engineering (e.g. automated testing, code reviews, and writing beautiful and pragmatic code)
Documenting database design and dataflow to ensure proper knowledge transfer, collaboration and improved supportability of the system.
Basic Qualifications:
Bachelor’s degree or M.S. in Computer Science, Computer Engineering.
10+ years of experience working in SQL development
Excellent knowledge of MS SQL Server and SSIS.
Significant experience working in a collaborative project using version control system like GIT
Strong understanding of agile methodologies and the usage of a project management platform like Jira or TFS
RTX is An Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status, age or any other federally protected class.
Privacy Policy and Terms:
Click on this link to read the Policy and Terms