
Software Engineer (Informatica/Navaera/ Oracle)
- USA
- $45,000-121,900 per year
- Permanent
- Full-time
- 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 12c/11g.10g.9i/8i,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
- 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.
- 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.