View All Jobs 144543

Software Engineer (informatica/navaera/ Oracle)

Build automated ETL pipelines for Canadian financial regulatory reports
Dallas
Mid-Level
yesterday
PNC

PNC

A leading financial services institution offering a wide range of services including personal banking, asset management, and corporate finance.

Software Engineer (Informatica/Navaera/Oracle)

At PNC, our people are our greatest differentiator and competitive advantage in the markets we serve. We are all united in delivering the best experience for our customers. We work together each day to foster an inclusive workplace culture where all of our employees feel respected, valued and have an opportunity to contribute to the company's success. As a Software Engineer (Informatica/Navaera/Oracle) within PNC's Retail Technology organization, you will be based in Pittsburgh, PA, Strongsville, OH, Birmingham, AL, or Dallas, TX. The position is primarily based in a PNC location. Responsibilities require time in the office or in the field on a regular basis. Some responsibilities may be performed remotely, at the manager's discretion.

As a Software Engineer (Informatica/Navaera/Oracle), you will be utilizing FRE daily - a vendor software based solution used to automate the creation and submission of regulatory reports as they pertain to the Canadian Government's Financial Transactions and Reports Analysis Centre of Canada (FINTRAC), Canada's financial intelligence unit.

Preferred Qualifications:

  • Development experience in ETL – Informatica Power Center / Power Exchange / Oracle (SQL/PL SQL), Scripting Language (Shell/UNIX).
  • Knowledge of Banking domain in Capital Market/Retail with Compliance and Risk Management.
  • NAVAERA Tools understanding for LCTR/EFTR reporting, event generation, referral creation and filing workflow.
  • Ability to create the data mapping understanding NAVAERA Data model and STM.
  • Actimize – CTR processing for Regulatory reporting, understanding Data model, creating Data mapping and Build ETL pipelines for Data Integration.
  • Requirement gathering and Analysis. Interacting with Business users/analyst for analyzing the business requirement to understand business specifications.
  • Develop the ETL mapping as per technical specifications documents with all the transformations and the business logic between the source and target.
  • Champion of implementing an Agile based methodology for ETL development across major projects.
  • Experience in integration of various Operational Data Source (ODS) with Multiple Relational Databases like Oracle, Teradata and Worked on integrating data from flat files like fixed width and delimited.
  • Good experience in Data Extraction, Transformation, Loading from data sources like Oracle, Teradata, XML, Flat files, COBOL and VSAM files.
  • Hands-on experience on Mainframes. Worked on CA7 scheduling tool for scheduling the Jobs.
  • Extensively worked with Slowly Changing Dimensions (Type I and Type II) and Change Data Capture (CDC).
  • Strong knowledge of Performance tuning issues while loading high volume of data and while generating reports

PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position.

Job Description:

  • Develops, tests and implements software solutions.
  • Designs software solutions to address business needs.
  • Writes code, tests and deploys software.
  • Prepares technical and procedural documentation required for software.
  • Maintains and debugs software.

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.

Qualifications:

Successful candidates must demonstrate appropriate knowledge, skills, and abilities for a role. Listed below are skills, competencies, work experience, education, and required certifications/licensures needed to be successful in this position.

Preferred Skills:

  • Application Development
  • Business Management
  • Customer Solutions
  • Design
  • Group Problem Solving
  • Process Improvements
  • Release Management
  • Software Solutions
  • User Experience (UX) Design

Competencies:

  • Application Design
  • Architecture
  • Application Development Tools
  • Application Maintenance
  • Application Testing
  • Packaged Application Integration
  • System Development Life Cycle
  • Technical Troubleshooting
  • Technical Writing/Documentation

Work Experience:

Roles at this level typically require a university / college degree, with 2+ years of relevant professional experience. In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered.

Education:

Bachelors

Certifications:

No Required Certification(s)

Licenses:

No Required License(s)

+ Show Original Job Post
























Software Engineer (informatica/navaera/ Oracle)
Dallas
Engineering
About PNC
A leading financial services institution offering a wide range of services including personal banking, asset management, and corporate finance.