Sr. ETL Informatica - IICS Developer Architect - Themesoft Inc.

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@themesoft.com