Overview
On Site
BASED ON EXPERIENCE
Contract - W2
Contract - Independent
Contract - 12+ mo(s)
Skills
SANS
Organizational Skills
Spectrum
Oracle Cloud
OLAP
Business Intelligence
Reporting
SQL
Data Science
R
SAS
Python
Modeling
Microsoft Office
Microsoft Outlook
Microsoft Excel
Microsoft PowerPoint
Macros
Visual Basic
Editing
Statistics
Testing
Regression Analysis
Informatica PowerCenter
Computer Science
Cloud Computing
ODBC
API
Data Integration
Management
Documentation
Mapping
Data Extraction
Data Migration
Data Warehouse
Database Architecture
Meta-data Management
Translation
Informatica
Extract
Transform
Load
Scripting
PL/SQL
Snow Flake Schema
Data Lake
Unstructured Data
Database
Writing
Job Details
Mando Technologies is specializes in helping organizations make the most of their information assets. From acquiring, organizing, analyzing, and delivering data to closing the loop by integrating intelligence into the operations of the enterprise, Mando Technologies covers the full spectrum of Business Intelligence.
We are seeking a Sr. 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.