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 isn’t just about developing cool things. That’s 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 the Data Integration Platform organization at Honeywell, you will have the opportunity to lead and work with a 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 Honeywell’s Digital Platform and Applications. Additionally, you will also participate and provide 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 for maintaining various data models across all applications, designing new solutions at the cutting edge of data technology, and delivering large‑scale systems that will have an impact on revenue growth. You will report directly to Sr. Director, IT and you’ll work out of our Phoenix, AZ location on a Hybrid work schedule. Hybrid Work Schedule Note: For the first 90 days, New Hires must be prepared to work 100% onsite Monday‑Friday. Responsibilities Lead and contribute to Informatica PowerCenter modernization initiatives to Cloud ETL platforms. Own end‑to‑end responsibility for managing data integration application interfaces in production and non‑production environments. 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 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. Automate regular & day‑to‑day activities. Lead 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 convert 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, using Oracle and Informatica partitioning, building stage tables and applying 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 review those results. Lead unit testing and document the processes. Involve in production support on‑call on a rotation basis, troubleshooting multiple production issues. Work on various scheduling tools like TIDAL and Autosys. Work on Teradata FLOAD, MLOAD, Teradata EXPORT and use 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 firm’s 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. Qualifications 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‑to‑day 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 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 Bachelor’s 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), 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 promote 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. Travel required: Approximately 0-5% Benefits Medical, Dental, Vision, and Life Insurance (employer‑subsidized) Short‑Term and Long‑Term Disability 401(k) match Flexible Spending Accounts Health Savings Accounts Employee Assistance Program Educational Assistance Parental Leave Paid Time Off (vacation, personal business, sick time, and parental leave) 12 Paid Holidays #J-18808-Ljbffr Honeywell Aerospace US LLC