IICS Lead

TechDigital Group; Frisco (TX); On-site; USD 80,000 - 120,000; Full time

Job summary

An established industry player is seeking a skilled ETL Developer with extensive experience in Informatica Cloud IICS. This role involves designing and developing data integration solutions, optimizing database systems, and collaborating with cross-functional teams to meet business requirements. The ideal candidate will have strong SQL and analysis skills, along with a proven ability to lead and mentor a team. Join a dynamic environment where your expertise will contribute to innovative data solutions and drive business success. If you are passionate about data integration and have a knack for problem-solving, this opportunity is perfect for you.

Qualifications

• 8-10 years of strong ETL experience in Informatica Cloud.
• Expertise in SQL and data modeling using 3NF or Star Schema.

Responsibilities

• Design and develop IICS data integration solutions and workflows.
• Collaborate with stakeholders to translate business needs into technical designs.

Skills

ETL experience

SQL

Analysis skills

Data modeling

CI/CD

Informatica Cloud IICS

Data Quality tools

Team leadership

Education

Bachelor's degree in Computer Science or related field

Tools

Informatica Cloud IICS

Teradata

Snowflake

Tableau

Power BI

Job description

Job Responsibilities

• Strong ETL experience in Informatica Cloud IICS/Informatica. Experience: 8 to 10 years.
• Should know CI/CD, development cycle process, end-to-end cycle, and drive planning to completion, prioritizing workload to team.
• Expertise in SQL and analysis skills. Database: Teradata, Snowflake.
• IICS - Design and develop IICS data integration solutions, including mappings, tasks, and workflows.
• IICS - Utilize various IICS components like Data Integration, API Integration, and Data Quality.
• IICS - Configure and manage IICS cloud resources and security.
• IICS - Cleanse, transform, and manipulate data using IICS Data Quality tools.
• IICS - Schedule and monitor IICS workflows.
• IICS - Troubleshoot and resolve IICS integration issues.
• Collaborate with stakeholders to understand business requirements and design data integration workflows.
• Translate business needs into technical design documents.
• Lead small or medium-sized team and contribute to team skill development.
• Perform root cause analysis for complex issues and implement resolution in a timely manner.
• Work closely with cross-functional teams, including data engineers, architects, and business analysts.
• Provide technical guidance and mentorship to team.
• Extensive experience in developing Informatica Cloud Mappings, DS tasks, Data replication, and task creation.
• Responsible for converting Functional Requirements into Technical Specifications.
• Strong data modeling experience using 3NF or Star Schema.
• Familiarity with data visualization tools (e.g., Tableau, Power BI).
• Migrate data from legacy systems to new solutions.
• Optimize new and current database systems.
• Define security and user access procedures.