Sr IT Analyst ETL

The future is what you make it. When you join Honeywell you become a member of our global team of thinkers innovators dreamers and doers who make the things that make the future. That means transforming the way we offer faster solutions improved outcomes and the use of Gen AI to get smarter. Also changing the way we fly fueling jets in an eco-friendly way keeping buildings smart and safe and even making it possible to breathe on Mars. Working at Honeywell isnt just about developing cool things. Thats why all of our employees enjoy access to dynamic career opportunities across different fields and industries. Are you ready to help us make the future

As Senior Data (IT) Analyst in Data Integration Platform organization at Honeywell you will have opportunity to lead and work with large footprint of various data integration technologies and make a difference by establishing a solid foundation for innovation performance reliability and scalability working on on-prem and public cloud solutions leveraging multiple data integration technologies.

You will lead the Informatica platform and application development architecture and operations that are responsible for setting the strategy and delivering a scalable and reliable data platform that supports Honeywells Digital Platform and Applications. Additionally you will also participate and provide your guidance for the design and implementation of ETL mappings governance of production jobs in global high availability and fast paced high-performance environments. You will be responsible to maintain various data models across all applications design new solutions at the cutting edge of data technology and will deliver large scale systems that will have an impact on revenue growth.

You will report directly to ourSr. Director ITand youll work out of ourPhoenix AZ location on aHybridwork schedule.

Hybrid Work Schedule Note: For the first 90 days New Hires must be prepared to work 100% onsite M-F

Key Responsibilities:

• Lead and contributes to Informatica PowerCenter modernization initiatives to Cloud ETL platforms
• Own the responsibility end to end managing data integration application interfaces in production and non-production environments
• Properly Conduct unit and integration testing with full ownership
• Perform performance tuning and debugging activities.
• Participate in monitoring production jobs and resolving issues.
• Analyze and resolve production job failures and Address and implement break fixes.
• Manage incident tickets and service requests ensuring closure within defined SLAs.
• Handle requests for minor enhancements as needed.
• Coordinate with cross-functional teams such as application administrators system administrators and DBAs to address and resolve failures.
• Demonstrate flexibility by working weekend shifts when required.
• Troubleshoot issues and execute performance tuning tasks.
• Ensure successful deployment of fixes to the production environment.
• Provide on-call support during weekends and off-hours as necessary.
• Automation of regular & day-to-day activities
• Lead the meetings/discussions with the Business to get the requirements finalized.
• Lead interactions with the data architects database analysts and the users to resolve various source data issues; assist in creating fact and dimension tables based on requirement documentation.
• Create functional ETL routines and verify their reliability to ensure compliance of business rules and propagation of data definitions throughout the ETL processes.
• Manage ETL defects enhancements and new functionality requests to meet changes in the business needs.
• Identify and investigate data quality/integrity problems determine impact and provide solutions to problems.
• Understand SQL PL/SQL scripts and converted the rules to mappings.
• Work on data loads to and from Flatfile Oracle MS SQL SAP HANA SalesForce sources and targets.
• Build Mappings using transformations like Union Lookup Joiner Router Aggregator Normalizer and Update strategy transformation.
• Involve in fine tuning the mappings for better performance as part of this used Oracle and Informatica partitioning built stage tables and applied informatica tuning techniques.
• Lead on IDQ data profiling rules and scorecards in multiple projects.
• Keep work on JSON files extraction using Data processor transformation in IDQ.
• Develop SQL scripts Shell scripts to implement business rules
• Validate results of all data migrations and reviewed those results
• Lead unit testing and documenting the processes.
• Involve in production support on-call on a rotation basis helped troubleshoot multiple production issues.
• Work on various scheduling tools like TIDAL and Autosys.
• Work on Teradata FLOAD MLOAD Teradata EXPORT and used pushdown optimization techniques.
• Contribute to formulation of strategies for infrastructure technologies functional areas across various business sectors
• Ensure ongoing compliance with regulatory requirements evaluate controls to help mitigate negative outcomes through prevention detection and correction SOX/PCI/GDPR/Export compliance etc.
• Appropriately assess risk when business decisions are made demonstrating particular consideration for the firms reputation and safeguarding Honeywell its clients and assets by driving compliance with applicable laws rules and regulations adhering to Policy applying sound ethical judgment regarding personal behavior conduct and business practices and escalating managing.
• Lead and engage in cross-platform training & in bits and bytes sessions on technology trends create opportunities for career growth and train the resources across various technologies

YOU MUST HAVE

• Minimum 5 years of experience in Informatica PowerCenter and IDMC ETL tools is must and should be ready for hands-on work on a day-today basis.
• Minimum 5 years of hands-on-experience on Informatica Power Center 10.x/9.x Power Analyzer IICS/IDMC Informatica Developer (IDQ) databases like Oracle MSSQL TOAD 11.0 SQL Developer Salesforce.
• Minimum 3 years of experience with orchestration tools like Control-M Redwood
• Minimum 5 years of experience in IT with a strong background in Analyzing Designing Developing Testing and Implementing of Data Warehouse development
• Strong analytical debugging and problem-solving skills.
• Strong understanding of the core architectural components and design aspects of ETL processes for designing efficient and scalable data integration solutions

WE VALUE

• Bachelors in computer science or equivalent work experience preferred
• Good understanding of complete life cycle implementation of data warehouse.
• Experience in the concepts of building Fact Tables Dimensional Tables handling Slowly Changing Dimensions and Surrogate Keys.
• Expertise in designing and developing complex Mappings using Informatica Power Center Transformations Lookup Filter Expression Router Joiner Update Strategy Aggregator Stored Procedure Sorter Sequence Generator XML(Sources Targets Generator Parser)HTTP Transformation.
• Expertise in Performance Tuning of sources mappings targets and sessions.
• Ability to understand available technology tools and existing designs and work on complex problems where analysis of situation and Data gathering is required.
• Strong experience in UNIX Shell Scripting Oracle 11g/10g/9i/8i SQL PL/SQL stored procedures Functions Packages Triggers Cursors Programming and TOAD.
• Excellent Data Analysis skills and ability to translate business logic into mappings using complex transformation logics for ETL processes.
• Hands on experience in Data Modeling using Erwin.
• Worked extensively on R programming and JSON file loads using IDQ.
• Good communication skills and ability to learn new things and be highly motivated.
• Ability to work under stringent deadlines with team as well as independently.
• Minimum of 3 years of solid hands-on experience and in-depth knowledge of data integration technology in Azure IDMC AWS
• Experience in all aspects of the software development lifecycle including requirements gathering design coding testing and production support
• Experience in transforming to and from on premise environment to cloud technology
• Excellent oral written and collaborative communication skills.
• The ability to partner effectively across IT teams suppliers and business customers on cross-functional projects and process improvements
• Strong interpersonal skills - effective listening and be a motivated team player.
• Self-motivated demonstrated bias for action
• Skilled in partnering with internal customers at all levels to define problems identify solutions and facilitate change
• The ability to be a change agent and promotes positive change in the organization demonstrating drive for continual improvement and efficiency
• Ability to effectively deal with critical outages and remediation efforts given risk activities
• Effectively demonstrates ability to deliver on complex situations or problems without guidance or supervision
• Creative and collaborative problem-solving capability
• Excellent leadership communication and executive presence
• Strong influencing program and change management skills
• Strong business acumen and customer focus
• Conveys specific observable and/or measurable expectations for each assignment and verifies understanding and agreement on deliverables and timeframes
• Consistently makes timely decisions even in the face of complexity balancing systematic analysis with decisiveness
• Analytical experience with spreadsheet analysis public presentations and data management the ability to be a change agent and promote positive change in the organization
• The ability to translate business issues / requirements and objectives into technical solutions
• Strong knowledge of IT business processes and practices including ITIL methodology

U.S. Person Requirement:

Due to U.S. export control laws candidates must be U.S. citizen U.S. permanent resident or have protected status under asylum or refugee.

Travel required: Approximately 0-5%

The application period for the job is estimated to be 40 days from the job posting date; however this may be shortened or extended depending on business needs and the availability of qualified candidates. Job Posting date: March 9 2026.

BENEFITS OF WORKING FOR HONEYWELL

In addition to a competitive salary leading-edge work and developing solutions side-by-side with dedicated experts in their fields Honeywell employees are eligible for a comprehensive benefits package. This package includes employer-subsidized Medical Dental Vision and Life Insurance; Short-Term and Long-Term Disability; 401(k) match Flexible Spending Accounts Health Savings Accounts EAP and Educational Assistance; Parental Leave Paid Time Off (for vacation personal business sick time and parental leave) and 12 Paid Holidays. For more information visit:

ABOUT HONEYWELL

Honeywell International Inc. (Nasdaq: HON) invents and commercializes technologies that address some of the worlds most critical challenges around energy safety security air travel productivity and global urbanization. We are a leading software-industrial company committed to introducing state-of-the-art technology solutions to improve efficiency productivity sustainability and safety in high-growth businesses in broad-based attractive industrial end markets. Our products and solutions enable a safer more comfortable and more productive world enhancing the quality of life of people around the globe. Learn more about Honeywell: click here ( BUSINESS UNIT

Honeywell Aerospace Technologies (AT) products and services are found on virtually every commercial defense and space aircraft in the world. We build aircraft engines cockpit and cabin electronics wireless connectivity systems mechanical components and more and connect many of them via our high-speed Wi-Fi offerings. Our solutions create healthier air travel more fuel-efficient and better-maintained aircraft more direct and on-time flight arrivals safer skies and airports and more comfortable flights along with several innovations and services that reflect exciting and emerging new transportation methods such as autonomous and supersonic flight. Revenues in 2023 for Honeywell Aerospace Technology were $14B and there are approximately 21000 employees globally. To learn more please visit here ( Experience:

Senior IC