Informatica/ETL PowerCenter Developer - ICONMA, LLC
Plano, TX 75024
About the Job
Description:
- Informatica/ETL PowerCenter Developer required for the compliance team would need to have at least 5-7 years of experience.
- Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications.
- Creates ETL Mappings, Mapplets, Workflows, 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.
- Develops stored procedures, database triggers and SQL queries where needed.
- Implements best practices and tunes SQL /queries for optimization.
- Loads and transforms data from various external sources to Relational database using Informatica.
- Worked with complex transformations such as XML's, XML parser, Java and HTTP transformation and have designed SCD typ2 workflows.
- Works with Informatica Data Quality (Analyst and Developer)
- Informatica PowerCenter 10.x, Oracle 11g/12c /19c SQL/PLSQL, Autosys (5-7 years)
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.
Source : ICONMA, LLC