What are the responsibilities and job description for the ETL Informatica Developer position at ICONMA?
Our Client, a Banking company, is looking for an ETL Informatica Developer for their Jersey City, NJ location.
Find out more about the daily tasks, overall responsibilities, and required experience for this opportunity by scrolling down now.
Responsibilities :
- Design, develop, maintain and test software, collaborating with the development team and business partners to ensure successful delivery and implementation of application solutions in an agile environment.
- Hands-on development of ETL packages using Informatica PowerCenter.
- Participate in ETL design of new or changing mappings and workflows with the team and prepare technical specifications.
- Create ETL Mappings, Mapplets, Workflows, and Worklets using Informatica PowerCenter 10.x and prepare corresponding documentation.
- Design and build integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.).
- Perform source system analysis as required.
- Work with DBAs and Data Architects to plan and implement appropriate data partitioning strategy in Enterprise Data Warehouse.
- Implement versioning of the ETL repository and supporting code as necessary.
- Load and transform data from various external sources to relational databases using Informatica.
- Work with complex transformations such as XMLs, XML parser, Java and HTTP transformation, and design SCD type 2 workflows.
Requirements :
Why Should You Apply?
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, gender, sexual orientation, gender identity or expression, ethnicity, national origin, age, disability status, political affiliation, genetics, marital status, protected veteran status, or any other characteristic protected by federal, state, or local laws.
J-18808-Ljbffr
