Job Description :
Data Engineer
St Louis, MO
1 Year to 2 years

Only on W2 Taxterms

Client : iQGateway / American Red Cross
2 rounds of interview for American red cross -> 1st round with IQgateway internal architect and 2nd round with American red cross hiring manager.

Job Description:
Senior Data Engineer shall perform the following tasks:

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.
- 5+ 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.