Seeking an experienced Informatica developer to join our Treasury applications team. The candidate should have a strong background in ETL (Extract, Transform and Load) process, data transformation, data integration and warehousing. This positions main job requirement is to provide production support. The position will monitor all the tickets and queues assigned to the application group.
Key Responsibilities:
Production Support activities include handling job failures, debugging data issues, root cause analysis of failures and working with business and interface IT partners to fix, restart or reprocess.
Support also includes performing test runs for interface partners, generate relevant test results & reports and responding to outages.
Continuous process improvements are carried out to enhance error handling, change rules & mappings, increase automation, and reduce incident count.
Attending major incident management calls
Participate/Support (application or infrastructure) as necessary
Participate/Perform DR activities
Perform minor enhancement work (design and develop)
Good expertise on the service-now produce usage
Ability to alert and respond to the issues.
Track and follow through the issues until complete
Work/coordinate with interfacing application teams for issue resolution
Build knowledge base
Able to work in shifts (US EST and LATAM)
Technical Skills:
Good knowledge of Informatica PowerCenter components (Designer, Workflow Manager, Workflow Monitor, Repository Manager)
Experience with Unix/Linux shell scripting and scheduling tools (e.g., IBM ROBOT Scheduler, Autosys)
Experience with relational databases (e.g., IBM DB2, MS SQL Server) and proficiency in SQL
Good experience in transformations – XML, CSV, JAVA, HTTP, SQL, Source Qualifier, Expression, Router, Joiner, Lookup, Aggregator, sorter, Union, Rank, Normalizer, XML Source/Target, Stored Procedure, Data Masking
Knowledge of cloud-based data integration tools, IICS, Azure integration is plus
Soft Skills:
Strong analytical and problem-solving skills.
Excellent communication and interpersonal skills.
Ability to work independently and collaboratively in a team environment.
Experience:
4 to 6 years hands on experience with Informatica PowerCenter in providing application production support,
Experience on small enhancement work (minor development work - designing and develop ETL workflows)
Experience in organization standards, participation full project development life cycle right from development to implementation and support, change management process, warranty support procedures (incidents/problems/changes)
Working experience in Agile environment and Scrum framework process (ceremonies, daily standups, agility, responsibilities and accountability)
Experience in use of source code management (Git, GitHub), DevOps, CICD
- Experience in use of JIRA for requirements, development, daily updates, deployments and communication with project stakeholders.
Top Skills
What We Do
Chubb is the world’s largest publicly traded property and casualty insurance company. With operations in 54 countries and territories, Chubb provides commercial and personal property and casualty insurance, personal accident and supplemental health insurance, reinsurance and life insurance to a diverse group of clients. As an underwriting company, we assess, assume and manage risk with insight and discipline. We service and pay our claims fairly and promptly. The company is also defined by its extensive product and service offerings, broad distribution capabilities, exceptional financial strength and local operations globally. Parent company Chubb Limited is listed on the New York Stock Exchange (NYSE: CB) and is a component of the S&P 500 index. Chubb maintains executive offices in Zurich, New York, London, Paris and other locations, and employs 31,000 people worldwide. Additional information can be found at: chubb.com.
