Job Information
ICONMA, LLC ETL Informatica Developer in United States
Responsibilities
Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications.
Creates ETL Mappings, Mapplets, Workflows, and Worklets using Informatica PowerCenter 10.x and prepare corresponding documentation.
Designs and builds integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.).
Performs source system analysis as required.
Works with DBAs and Data Architects to plan and implement appropriate data partitioning strategy in Enterprise Data Warehouse.
Implements versioning of the ETL repository and supporting code as necessary.
Loads and transforms data from various external sources to Relational database using Informatica.
Work with complex transformations such as XML's, XML parser, Java and HTTP transformation and have designed SCD typ2 workflows.
Informatica PowerCenter 10.x, Oracle 11g/12c SQL/PLSQL, AutoSys
Familiar with any version control tool
Oracle PL/SQL
Unix Concepts
Experience on SDM Adoption / Horizon onboarding tools (Bit Bucket, Datical, Jenkins)
Agile best practices
As an equal opportunity employer, ICONMA provides an employment environment that supports and encourages the abilities of all persons without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.