What are the responsibilities and job description for the Sr. ETL Informatica - IICS Developer Architect position at Mando Technologies?
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.
GC's and US Citizens are highly preferred
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.
Keep a pulse on the job market with advanced job matching technology.
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.
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.
We don't have any other Sr. ETL Informatica - IICS Developer Architect jobs in the Dallas, TX area right now.
