Technogen International Company
Informatica Cloud ETL Lead
Technogen International Company, Frisco, TX
Title: Informatica Cloud ETL Lead
Location: Frisco, TX
Duration:12 Months
Responsibilities:
Location: Frisco, TX
Duration:12 Months
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 is 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, size team and contribute to team skill development.
- Performs root cause analysis for complex issues and implements 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 task, 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