Sr IT Analyst - ETL

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 Honeywell's 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 our 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 M-F, * 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 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

Do you have experience in Technical solutions implementation?, Do you have a Bachelor's degree?, * 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.

Pulled from the full job description

• Tuition reimbursement
• Parental leave
• Health insurance
• 401(k) matching
• Paid time off
• Vision insurance
• Health savings account, 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: https://benefits.honeywell.com

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?, Honeywell International Inc. (Nasdaq: HON) invents and commercializes technologies that address some of the world's 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 (https://www.honeywell.com/us/en), 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 21,000 employees globally. To learn more, please visit here (https://aerospace.honeywell.com/) . #AERO26 Honeywell helps organizations solve the world's most complex challenges in automation, the future of aviation and energy transition. As a trusted partner, we provide actionable solutions and innovation through our Aerospace Technologies, Building Automation, Energy and Sustainability Solutions, and Industrial Automation business segments - powered by our Honeywell Forge software - that help make the world smarter, safer and more sustainable.   You must create an Indeed account before continuing to the company website to apply