BTS Associate Consultant_IICS

Key Responsibilities:

• Design and Development:
• Develop, configure, and optimize data integration processes using IICS.
• Design and implement complex ETL workflows to extract, transform, and load data from various sources into target systems.
• Collaborate with business analysts and data architects to understand data requirements and translate them into technical solutions.
• Data Integration:
• Implement data mappings, workflows, and sessions using Informatica IICS.
• Integrate data from on-premises databases, cloud applications, and third-party data sources.
• Ensure data quality and consistency through validation, cleansing, and transformation processes.
• Performance Tuning:
• Optimize ETL processes for maximum efficiency and scalability.
• Monitor and troubleshoot ETL jobs to ensure smooth operation and minimal downtime.
• Collaboration and Documentation:
• Work closely with cross-functional teams including data architects, business analysts, and project managers to deliver data integration solutions.
• Document technical designs, mappings, workflows, and processes.
• Provide technical support and guidance to team members and stakeholders.
• Testing and Validation:
• Conduct unit and integration testing of ETL processes.
• Validate data accuracy and integrity post-migration and integration.
• Maintenance and Support:
• Maintain and enhance existing ETL workflows and data integration processes.
• Monitor production environments, resolve issues, and ensure data availability and integrity.

Required Qualifications:

• Technical Skills:
• Proficiency in Informatica Intelligent Cloud Services (IICS), including experience with Cloud Data Integration (CDI) and Cloud Application Integration (CAI).
• Strong SQL skills and experience with relational databases such as Oracle, SQL Server, or MySQL.
• Experience with ETL tools and data integration best practices.
• Experience:
• 3-6 years of experience in data integration and ETL development.
• Previous experience with Informatica PowerCenter or other data integration tools is a plus.
• Experience with scripting languages (e.g., Python, Shell scripting) is desirable.
• Soft Skills:
• Strong analytical and problem-solving skills.
• Excellent communication and interpersonal skills.
• Ability to work independently as well as in a collaborative team environment.
• Detail-oriented with a strong focus on quality.