This position is primarily based in a location within PNC's footprint. Responsibilities require time in the office or in a field on a regular basis. Some responsibilities can be performed remotely. Additional locations may be considered.
You will be able to work in a fast-paced environment, ability to multitask important project deliverables and communicate effectively.As an ETL Engineer you will be required to install and configure Informatica software components across multiple environments and to partner with MIS project teams to understand project requirements and provide input to various solutions to ensure they align to Enterprise Architecture and ETL standards. In addition, this position will require general platform support - including troubleshooting, issue resolution and on-call duties.Responsibilities may include:
- Install and configure Informatica software
- Maintain or perform system upgrades, including patches
- Configure LDAP for authentication
- Configure security (User/Groups, Roles, File system level) per security design- Work with vendor on issue resolution
- Troubleshooting, incident root-cause analysis and resolution
- Coordinate problem resolution across responsible groups, including server support, network, databases and security.
- Develop and publish platform documentation
- Enforce security policies
- Troubleshooting ETL job performance on a Linux platform
- Work to meet Disaster Recovery RTO and RPO objectives
Informatica Data Management Cloud Administration (IICS/IDMC - Cloud Data Integration focus) - 5+ Years of experience preferred
Informatica PowerCenter - 5+ Years of experience preferred
Informatica PowerExchange (z/OS VSAM and CDC AS/400 focus) - 3+ Years of experience preferred
RedHat Linux - 5+ Years of experience preferredPreferred additional experience:Informatica automation - pmrep, pmcmd, infacmd, IDMC API
NAS - Network Attached StorageEnterprise Schedulers (CA7)
uDeploy and artifactory/Automated Deployment Methods
Informatica Test Data Management
Informatica Data Processor Transformation
Network Data Mover(NDM)/Connect:Direct(C:D)
*** PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position ***
Job Description- Applies solution design and support while consistently meeting customer needs. Leverages technical knowledge and industry experience to design, build and maintain infrastructure technology solutions.
- Develops software components and hardware for projects; aligns these with business strategies and objectives.
- Independently solves common problems and updates applications with new technology.
- Collaborates with engineers, architects, developers and other staff to meet project objectives.
- Analyzes the technological needs of customers and provides ongoing support for clients.
PNC Employees take pride in our reputation and to continue building upon that we expect our employees to be:
- Customer Focused - Knowledgeable of the values and practices that align customer needs and satisfaction as primary considerations in all business decisions and able to leverage that information in creating customized customer solutions.
- Managing Risk - Assessing and effectively managing all of the risks associated with their business objectives and activities to ensure they adhere to and support PNC's Enterprise Risk Management Framework.
QualificationsSuccessful candidates must demonstrate appropriate knowledge, skills, and abilities for a role. Listed below are skills, competencies, work experience, education, and requiredneeded to be successful in this position.
Competitive Advantages, Customer Solutions, Design, Enterprise Architecture Framework, Machine Learning, Risk Assessments, Technical KnowledgeApplication Delivery Process, Consulting, Effectiveness Measurement, Industry Knowledge, IT Industry: Trends & Directions, IT Standards, Procedures & Policies, Planning: Tactical, Strategic, Problem SolvingRoles at this level typically require a university / college degree, with 3+ years of relevant / direct industry experience. Certifications are often desired. In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered.No Required Certification(s)No Required License(s)
This position is subject to the requirements of Section 19 of the Federal Deposit Insurance Act (FDIA) and, for any registered role, the Secure and Fair Enforcement for Mortgage Licensing Act of 2008 (SAFE Act) and/or the Financial Industry Regulatory Authority (FINRA), which prohibit the hiring of individuals with certain criminal history.
California ResidentsRefer to the