Sr. ETL Informatica - IICS Developer Architect

Job Title - Sr ETL Informatica- IICS Developer Architect

Duration - Long Term

Work Mode- Hybrid/ WFO (4 days onsite-1 Day remote per week)

Work Location- Irving, Tx

Position Summary:
We are seeking Seeking a Senior ETL Informatica-IICS Developer Architect for a hybrid role in Irving, TX. Responsibilities include designing and managing ETL processes using Informatica PowerCenter/Cloud IDMC, integrating diverse data sources, and developing data warehouses for BI reporting. Expertise in API/ODBC integrations, SQL/PLSQL, and data migration is required. Preferred qualifications include a Bachelor's degree in computer science and Informatica certifications.

PRINCIPAL DUTIES AND RESPONSIBILITIES (May perform any or all of the following):

• 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.
  

Qualifications & Experience Required:

• 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
  ABOUT ISHIR

ISHIR is a digital innovation and enterprise AI services provider. We work with startups and enterprises to shape the future through accelerated innovation, deep technical expertise, access to global digital talent and a passion for complex problem-solving. With our help, our clients overcome their most difficult digital challenges leveraging AI.

We are not just consultants, we are partners in our clients’ success, assisting them with re(gaining) competitive edge by identifying opportunities for differentiation, industry disruption, scalable innovation, and go-to-market strategies that deliver successful outcomes.

At ISHIR, we help bold businesses accelerate innovation through Talent, Speed-to-Market, and AI. We help make an impact by solving real problems using innovation, improved customer experiences and the right technologies.

As an ISHIR employee, you will get the advanced training you need to be successful, and the opportunity to apply it. You must be passionate about technology, crave responsibility, and be eager to apply your knowledge to real business solutions for our startup and enterprise customers. These are the qualities of a person destined for success at ISHIR.

ISHIR attracts a special type of individual—someone who is proactive, thrives on challenges, feeds off success, and looks at moving targets not as obstacles but as opportunities. ISHIR is an exciting place to work. It is imbued with an entrepreneurial spirit and promotes self-reliance, open communication, and collaboration.