The Data Integration Developer is responsible for the design, build, and deployment of the project's data integration components. A typical data integration effort usually involves multiple Data Integration Developers developing the Informatica mappings, task flows and process orchestration tasks along with unit testing the output. These tasks can involve data ingestion into various Cloud storage technologies such as S3, ADLS, Snowflake, or Databricks, and making sure that tasks can be pushed down to these technologies.
Responsibilities
- Uses the Informatica Cloud Data Integration platform to extract, transform, and load data from sources to targets
- Develops data integration mapping designs
- Uses Informatica Data Integration to perform data quality operations
- Makes sure that the ingestion and integration processes can be executed on Cloud technologies such as Snowflake or Databricks where suitable and advantageous
- Develops data integration task flows and load processes
- Ensures adherence to locally defined standards for all developed components
- Performs data analysis for both Source and Target tables/columns
- Provides technical documentation of data integration logic
- Supports the development and design of the internal data integration framework
- Participates in design and development reviews
- Works with system owners to resolve source data issues and refine transformation rules
- Ensures performance metrics are met and tracked
- Writes and maintains unit tests
- Conduct QA Reviews
Qualifications/Certifications
- Understands data integration processes and how to tune for performance
- Has SQL experience
- Has a working knowledge of applicable Cloud storage and processing technologies
- Has API call and API result transformation experience
- Has ability to consolidate multiple results into a single format (.csv or .xml file, write data to temporary data base, etc.)
- Possesses excellent communications skills
- Has the ability to develop work plans and follow through on assignments with minimal guidance
- Has Informatica data integration experience
- Has data storage technology experience aligned to the solution architecture
- Has the ability to work with business and system owners to obtain requirements and manage expectations
- Ability to solve complex data problems
- Understanding of change data capture and data refresh strategies and processes