Position Description:

Develops PL/SQL and Extract Transfer and Load (ETL) code using Oracle and Informatica to ensure other teams have the correct data. Works in an agile manner within squad and across other teams to deliver and release valuable source code to the application and its users, uses JIRA. Performs codes in programs languages using Shell scripting, Python, Java, and PL/SQL. Deploys applications in a DevOps environment uses Continuous Integration and Continuous Delivery (CI/CD) pipelines and practices. Develops and migrates applications into cloud-based platforms like Amazon Web Services (AWS) and Azure.

Primary Responsibilities:

• Develops supplemental applications used to process holdings and trade data to various internal consumers.

• Support and continuously improves applications in production.

• Mentors junior team members.

• Delivers business value with agile practices.

• Confers with systems analysts and other software engineers/developers to design systems.

• Obtains information on project limitations and capabilities, performance requirements and interfaces.

• Develops and oversees software system tests and validation procedures, programs, and documentation.

Education and Experience:

No degree and six (6) years of experience as a Principal Data Engineer (or closely related occupation) performing Informatica ETL and Oracle database development.

Or, alternatively, Bachelor’s degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and five (5) years of experience as a Principal Data Engineer (or closely related occupation) performing Informatica ETL and Oracle database development.

Or, alternatively, Master’s degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and three (3) years of experience as a Principal Data Engineer (or closely related occupation) performing Informatica ETL and Oracle database development.

Skills and Knowledge:

Candidate must also possess:

• Demonstrated Expertise (“DE”) gathering and analyzing requirements, performing application design and development using PL SQL in Linux environment; and performing software application testing to meet functional and non-functional requirements, using Shell scripting.

• DE developing, designing, and implementing scalable and efficient data architectures, using data warehousing solutions including Amazon Redshift, Oracle, Snowflake, and ETL (Extract, Transform, Load) processes; and performing data cleansing, blending, parsing and transformations using Alteryx; conducting workflow automation and data integration using Informatica.

• DE applying DevOps principles throughout the Software Development Life Cycle (SDLC) — performing Continuous Integration / Continuous Deployment (CI/CD) using Jenkins, uDeploy, and GitLab; and identifying performance bottlenecks and providing solution improvements for current and future applications using Jenkins Performance Plugin, GitK, and GitStats.

• DE performing data analysis, including building analytical applications using Power BI and Tableau.

#PE1M2