Informatica IDMC

Informatica IDMC

Posted 1 week ago by ERPA

Apply
Negotiable
Undetermined
Hybrid
Remote
Apply
Capability Maturity Model Integration Cloud Computing Cloud Technology Data Analysis Data Integration Data Management Data Warehouse Architectures Data Warehousing Extract Transform Load (ETL) File Servers IBM DB2 Informatica Management Metadata Microsoft SQL Servers Process Design Relational Databases SQL (Programming Language)

Summary: The role of Informatica IDMC involves designing, developing, testing, and implementing ETL solutions using Informatica Data Management Cloud. Candidates should possess strong hands-on experience with data integration and management, particularly in data warehousing processes. The position allows for remote work but may require occasional onsite presence. The ideal candidate will have a solid background in relational databases and data analysis.

Key Responsibilities:

  • Design, develop, test, and implement ETL solutions using Informatica IDMC.
  • Manage metadata and ensure data accuracy and integrity.
  • Drive continuous optimization within the IDMC and data warehouse environment.
  • Build scalable, secure, and high-performing data pipelines using Data Integration (DI), Taskflows, and Mappings.

Key Skills:

  • 4+ years of experience in data warehousing process design, development, performance & tuning using Informatica.
  • 3+ years of knowledge in relational database technologies (e.g., Oracle, DB2, SQL Server).
  • 4+ years of strong data management and data analysis using SQL.
  • 3+ years of hands-on experience with Informatica IDMC.
  • Experience in developing data warehouse architecture and integration strategies.
  • State/federal experience is required.

Salary (Rate): £44.50 hourly

City: Madison

Country: USA

Working Arrangements: hybrid

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:
Urgent Requirement: Informatica IDMC
Duration: 12 months
Location: Madison, WI
hybrid or remote: No WI residency required. Open to nationwide candidates. 90-100% remote but can require staff to come onsite as necessary with sufficient notice. Onsite work is not likely, but candidate should be prepared to come onsite if required.
Visa Type: All
Tax Term: W2/C2C
Interview process: via Zoom/Teams Onsite
Required Skills: any state/federal experience must
Moderate experience in data warehousing process design, development, performance & tuning using the Informatica data warehousing tool suite (4+ years)
Developing skills in the architecture of data warehouse and data integration strategies and solutions
Knowledge in relational database technologies, e.g. Oracle, DB2, SQL Server (3+ years)
Strong data management and data analysis using SQL (4+ years)
Must have strong hands-on experience with Informatica IDMC (3+ years)
Project details: This role is responsible for designing, developing, testing, and implementing ETL solutions using Informatica Data Management Cloud (IDMC). This role requires strong hands-on experience with Data Integration (DI), Taskflows, Mappings, parameter files, and reusable transformations to build scalable, secure, and high-performing data pipelines. The candidate will manage metadata, ensure data accuracy and integrity, and drive continuous optimization within the IDMC and data warehouse environment.
Regards,
Srinivas SP
ERP Analysts, Inc.
Email: Srinivas dot sriperambuduri at erpanalysts.com
(Six one Four - Five One Five - Six Four Five Sevan)
Workday Certified Partner | Oracle Gold Partner | CMMI Level3
LinkedIn profile: Srinivas Sriperumbudur

Apply
Similar Jobs
Loading data...