Honeywell is looking for an IT Analyst to lead our data integration technologies and establish a foundation for innovation, performance, reliability, and scalability across on-prem and public cloud solutions. You will set strategy and lead the Informatica platform and application development, architecture, and operations for a scalable data platform that supports Honeywell’s Digital Platform and Applications.
What You'll Do
- Lead and contribute to Informatica PowerCenter modernization initiatives to Cloud ETL platforms.
- Own end-to-end management of data integration application interfaces in production and non-production environments.
- Conduct unit and integration testing with full ownership and perform performance tuning and debugging activities.
- Participate in monitoring production jobs, analyzing and resolving failures, and implementing break fixes.
- Manage incident tickets and service requests, ensuring closure within defined SLAs, and handle requests for minor enhancements.
- Coordinate with cross-functional teams (application administrators, system administrators, DBAs) to resolve failures.
- Work weekend shifts and provide on-call support during weekends and off-hours when required.
- Automate regular & day-to-day activities and troubleshoot issues.
- Lead meetings/discussions with Business to finalize requirements and interactions with data architects and database analysts.
- Create functional ETL routines and verify their reliability to ensure compliance of business rules.
- Manage ETL defects, enhancements, and new functionality requests.
- Identify and investigate data quality/integrity problems, determine impact, and provide solutions.
- Understand SQL, PL/SQL scripts and convert rules to mappings.
- Work on data loads to and from Flatfile, Oracle, MS SQL, SAP HANA, and SalesForce sources and targets.
- Build Mappings using transformations like Union, Lookup, Joiner, Router, Aggregator, Normalizer and Update strategy transformation.
- Fine tune mappings for better performance using Oracle and Informatica partitioning, stage tables, and tuning techniques.
- Lead on IDQ data profiling, rules and scorecards and work on JSON files extraction using Data processor transformation in IDQ.
- Develop SQL scripts and Shell scripts to implement business rules and validate results of all data migrations.
- Lead unit testing, document processes, and involve in production support on-call on a rotation basis.
- Work on various scheduling tools like TIDAL and Autosys, and on Teradata FLOAD, MLOAD, EXPORT using pushdown optimization.
- Contribute to formulation of strategies for infrastructure technologies across business sectors.
- Ensure ongoing compliance with regulatory requirements (SOX/PCI/GDPR/Export compliance) and assess risk in business decisions.
- Lead and engage in cross-platform training & sessions on technology trends and train resources across technologies.
What We're Looking For
- Minimum 5 years of experience in Informatica PowerCenter and IDMC ETL tools.
- 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 and a strong understanding of the core architectural components of ETL processes.
- Must be a U.S. citizen, U.S. permanent resident, or have protected status under asylum or refugee.
Nice to Have
- Bachelor's in computer science or equivalent work experience.
- Good understanding of complete life cycle implementation of a data warehouse.
- Experience in building Fact Tables, Dimensional Tables, handling Slowly Changing Dimensions and Surrogate Keys.
- Expertise in designing and developing complex Mappings using Informatica Power Center Transformations and in Performance Tuning.
- Ability to understand available technology, tools and existing designs and work on complex problems.
- 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.
- 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 work under stringent deadlines.
- 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 and in transforming from on-premise environment to cloud technology.
- Excellent oral, written and collaborative communication skills.
- Ability to partner effectively across IT teams, suppliers and business customers with strong interpersonal skills.
- Self-motivated, demonstrated bias for action, and skilled in partnering with internal customers to define problems and identify solutions.
- Ability to be a change agent, effectively deal with critical outages, and deliver on complex situations without guidance.
- Creative and collaborative problem-solving capability with excellent leadership communication and executive presence.
- Strong influencing, program and change management skills, strong business acumen, and customer focus.
- Ability to convey specific, observable, measurable expectations for assignments and consistently make timely decisions.
- Analytical experience with spreadsheet analysis, public presentations, and data management.
- Ability to translate business issues / requirements into technical solutions and strong knowledge of IT business processes including ITIL methodology.
Technical Stack
- ETL & Integration: Informatica PowerCenter, IDMC ETL, Informatica Power Center 10.x/9.x, Power Analyzer, IICS/IDMC, Informatica Developer (IDQ)
- Databases & Tools: Oracle, MSSQL, TOAD 11.0, SQL Developer, Salesforce, SAP HANA, Teradata
- Orchestration & Scripting: Control-M, Redwood, TIDAL, Autosys, UNIX Shell Scripting
- Languages: SQL, PL/SQL, R programming
- Modeling & Cloud: Erwin, Azure, AWS
Team & Environment
You will join the Data Integration Platform organization and report to the Sr. Director, IT. You'll be part of a global team of thinkers, innovators, dreamers and doers transforming the way we offer faster solutions, improved outcomes, and the use of Gen AI.
Benefits & Compensation
- Employer-subsidized Medical, Dental, Vision, and Life Insurance
- Short-Term and Long-Term Disability
- 401(k) match
- Flexible Spending Accounts and Health Savings Accounts
- EAP and Educational Assistance
- Parental Leave
- Paid Time Off (for vacation, personal business, sick time, and parental leave)
- 12 Paid Holidays
Work Mode
This is a hybrid position based in Phoenix, AZ.
Honeywell is an equal opportunity employer.
