Let’s Connect Today!

NextGen Person

Sr. Data Engineer in St. Louis, MO at NextGen

Date Posted: 8/1/2018

Job Snapshot

Job Description

The individual resource will perform the following activities:



  1. Design, develop and implement ETL transformations using Informatica power center and related products. Develop ETL related scripts, database procedures and other services as needed for implementing the best practices of ETL implementation. Provide SME (subject matter expert) in ETL technology implementation.

  2. Design coded database objects, including stored procedures, Oracle packages, functions, views, and PL/SQL scripts used for data migration, fixes, transformations, and test data generation.

  3. Create, review, and deliver release documentation, reports, procedures, configuration documents and other required artifacts for updates to extraction, transformation, and load packages in order to: populate databases from different sources; integrate, consolidate and cleanse data; and, structure data for use in analytics applications.

  4. Promptly provide written status reports as requested by Bank on activities to achieve successful updates to Bank's databases, data engineering platforms, and data integration platforms according to the applicable schedule.

  5. As requested, perform problem diagnosis, identification and resolution for complex databases, data engineering platforms, and data integration platforms developed in Oracle, Informatica, and scripting language. Provide reports to Bank on activities to address problems.

  6. Develop, test, deploy and document code based on the Bank's design specifications. Implement schema changes and maintain data architecture standards across databases.

  7. Prepare, test and maintain database release code to ensure optimized performance of databases, data engineering platforms, and data integration platforms throughout the software development life cycle.

  8. Participate in peer code reviews.

  9. Provide training in a timely manner to Bank staff on data engineering activities and technical and business requirements associated with updates to Bank's applications.



Qualifications:



  • Bachelor's degree with major or specialized courses in Information Technology or commensurate experience.

  • 3+ years' related experience in performing listed activities.

  • Experience with Informatica PowerCenter.

  • Experience designing and delivering cross functional custom reporting solutions.

  • Experience with relational SQL and NoSQL databases, and Oracle.

  • Demonstrated ability to perform self-directed work while supporting multiple teams, systems and products.

  • Demonstrated ability to communicate effectively.

  • Availability to travel in connection with providing services.

  • Position requires US Citizen or lawful permanent resident with three or more years of US residency