Demo
Salary Resume Critique Job Openings

Sr. ETL Informatica - IICS Developer Architect

ThemeSoft
Dallas, TX Full Time
POSTED ON 2/2/2025
AVAILABLE BEFORE 4/27/2025

Title : Sr. ETL Informatica - IICS Developer Architect

Work Location : DFW Airport Headquarters, 2400 Aviation Dr, Euless, TX 75261

Hybrid : 4 days onsite, 1 day remote per week

Contract : 12 months.

Job Description :

We are seeking aSr. ETL Informatica IICS Developer Architect to create, maintain and support Informatica projects and repository to support Data Warehouses and manage SQL Scripts, ETL routines to support Enterprise Business Intelligence projects.

Required Experience :

  • Experience and in-depth knowledge of planning the ETL process through completion.
  • Experience with Informatica PowerCenter and Informatica Cloud IDMC / IICS, specifically pertaining to API data integration and cloud-based ODBC data integration.
  • Experience with Oracle Cloud Database
  • Experience with API data
  • Experience with Informatica CDI
  • Experience with Rest V2
  • Experience building and maintaining OLAP style Data Warehouses to support Enterprise Business Intelligence reporting tools.
  • Experience writing and tuning SQL and PL / SQL language.
  • Experience with common data science toolkits, such as R. SAS or Python.
  • Experience demonstrating strong understanding of databases and detailed knowledge of technical modeling.
  • Experience demonstrating knowledge of current computer technologies.
  • Experience demonstrating advanced skill in use of Microsoft Office, including Outlook, Excel, Word, PowerPoint, and other computer applications, including but not limited to, skill in using shortcuts, macros, visual basic editing and advanced formulas.
  • Experience demonstrating ability to work with mathematical formulas and statistical data sets, including charting and graphing.
  • Experience demonstrating applied statistics skills, such as distributions, statistical testing, regression, etc.

Preferred Education and Certification :

  • Informatica Cloud
  • Informatica PowerCenter
  • Bachelor's degree in business, computer science or engineering, or a related field

    • Responsibilities :

  • Develop Informatica Cloud IDMC / IICS mappings and mapping tasks using ODBC and API based data integration and design task flows.
  • Plan projects, monitor progress, and ETL development and implementation status to management using PMCMD.
  • Assist with the creation of documentation and source to target mapping for data extraction and data migration strategy.
  • Analyze, develop, and evaluate data in a Data Lake and Data Warehouse environment including data design, database architecture, metadata.
  • Perform the translation of functional specifications into detailed technical systems designs.
  • Communicate with Informatica Global support and perform troubleshooting using PowerCenter or IDMC / IICS framework.
  • Develop ETL scripts using IICS to migrate data from Oracle / SQL Server into a Snowflake Data Lake and support a variety of structured, semi-structured, and unstructured data sources.
  • Ensure current and future systems that are planned, developed or procured meet Board standards and are compatible.
  • Work with System Administrators, Database Administrators, and other cross-functional teams.
  • Communicate clearly and effectively, both orally and in writing, at all levels within and outside the organization.
  • Establish and maintain effective working relationships inside and outside the organization.

    • Regards

    Vinay S

    vinay.s@

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Sr. ETL Informatica - IICS Developer Architect?

    Sign up to receive alerts about other jobs on the Sr. ETL Informatica - IICS Developer Architect career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $128,536 - $205,780
    Income Estimation: 
    $201,260 - $351,109
    Income Estimation: 
    $115,838 - $142,817
    Income Estimation: 
    $129,640 - $165,363
    Income Estimation: 
    $129,640 - $165,363
    Income Estimation: 
    $151,182 - $194,086
    Income Estimation: 
    $87,428 - $116,878
    Income Estimation: 
    $115,838 - $142,817
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $129,640 - $165,363
    Employees: Get a Salary Increase
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at ThemeSoft

    MuleSoft Admin with EKS
    ThemeSoft
    Hired Organization Address Hartford, CT Contractor
    Role: Mulesoft Admin with EKS Location – Hartford, CT (Onsite) Position - MuleSoft Admin with EKS knowledge MuleSoft Pla...
    Cyber Secuirty Specilities
    ThemeSoft
    Hired Organization Address Dallas, TX Contractor
    JOB TITLE: Cyber Security Specialist POSITION: Contract (12 months) LOCATION: Dallas TX Duties and Requirements On a day...
    Design verification Engineer
    ThemeSoft
    Hired Organization Address Sunnyvale, CA Full Time
    Role: Design verification Engineer Location: Sunnyvale Responsibilities: Design Verification Engineering Services Testbe...
    Power Analysis Engineer
    ThemeSoft
    Hired Organization Address Sunnyvale, CA Full Time
    Job Title: Power Analysis Engineer Location: Sunnyvale, CA or Austin, TX (Hybrid Onsite) Duration: Full time Job Descrip...
    View More Jobs at ThemeSoft

    Not the job you're looking for? Here are some other Sr. ETL Informatica - IICS Developer Architect jobs in the Dallas, TX area that may be a better fit.

    Sr. ETL Informatica - IICS Developer Architect

    Mando Technologies, Dallas, TX

    Sr. ETL Informatica - IICS Developer Architect

    ISHIR, Dallas, TX

    View More Jobs

    AI Assistant is available now!

    Feel free to start your new journey!