Integrating on-premise and cloud-based systems which are the core of operations.
Requirements
- Informatica IDMC (CDI and CAI), Power Center, & IDEM
- Experience developing with Informatica PowerCenter, designing and developing Informatica workflows for enterprise system(s), deployment of Informatica to production environment, and writing scripts to manage/move/schedule files in accordance to Informatica integration.
- Minimum 4 years of SQL experience (ability to develop, modify, troubleshoot and optimize complex queries and stored procedures).
- Deep understanding of relational/dimensional data modeling and data mapping design, integration, migration and warehousing.
- Design and Implementation of ETL solutions with effective design and optimized performance, ETL Development with industry standard recommendations for jobs recovery, fail over, logging, alerting mechanisms.
- Preferred development background with Java, J2EE, Database building, SQL scripting and Management: DB2, SQL, PL/SQL, JDBC, Mapping and Workflow Tools.
- Preferred experiencing developing with Azure Data Factory.
Responsibilities
- designing solutions
- translating business requirements
- developing, documenting, testing, troubleshooting data environment using our ETL tool sets
- analyze system components to find causes of errors and revise programs as needed
- Follows company software development lifecycle to design, code, configure, test, debug, and document system and application programs
- Assists in preparing technical design specifications based on functional requirements and analysis documents
- Reviews functional requirements, analysis and design documents and provides feedback
Other
- senior developer role
- Follows company software development lifecycle
- Participates in architecture, design and code reviews.
- Develops and maintains operational and system level documentation.
- This is a remote position.
