What are the responsibilities and job description for the ETL Informatica - IICS Developer position at The Evolvers Group?
Title: ETL Informatica - IICS Developer
Work Location: DFW Airport Headquarters, 2400 Aviation Dr, Euless, TX 75261
Hybrid: 4 days onsite, 1 day remote per week
Contract: 12 months. Must be Authorized to Work in the US for Any Employer.
Pay: $62/hr W2 (plus 8 paid holidays and 15 days PTO)
Job Description:
We are seeking a Sr. ETL Informatica IICS Developer 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 (7 years):
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.
Airport Special Requirements:
Must obtain an Airport Identification/Access Badge (badge) in accordance with Department of Homeland Security Transportation Security Administration (TSA) requirements in Chapter 49 of the Code of Federal Regulations Part 1500 et al., and DFW Airport’s Airport Security Program within thirty (30) days from date of employment and maintain qualification for a badge upon each badge renewal.
Work Location: DFW Airport Headquarters, 2400 Aviation Dr, Euless, TX 75261
Hybrid: 4 days onsite, 1 day remote per week
Contract: 12 months. Must be Authorized to Work in the US for Any Employer.
Pay: $62/hr W2 (plus 8 paid holidays and 15 days PTO)
Job Description:
We are seeking a Sr. ETL Informatica IICS Developer 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 (7 years):
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.
Airport Special Requirements:
Must obtain an Airport Identification/Access Badge (badge) in accordance with Department of Homeland Security Transportation Security Administration (TSA) requirements in Chapter 49 of the Code of Federal Regulations Part 1500 et al., and DFW Airport’s Airport Security Program within thirty (30) days from date of employment and maintain qualification for a badge upon each badge renewal.
Salary : $62
