Informatica CDI (Cloud Data Integration)

Job description

Role : Informatica CDI (Cloud Data Integration) Experience: 4-10 yrs Location: Chennai,pune Requirments: - Understand pain points from a customer/vertical perspective for developing specific solutions. Identify the customer segment to position the new offering and develop business case for the new service offering - Analyzing data integration requirements, analyzing data sources and targets, business rules, and transformation logic - Analyzes the impact of changes on existing ETL/ELT processes and systems. Assesses the compatibility with goals in all areas. Analyzes cost effectiveness and feasibility - Create functional design for overall business intelligence solutions - Design, develop and maintain Informatica cloud data integration processes using the appropriate data load technique, including Push-Down Optimization for performance optimization - Design data integration and conversion strategy, exception handing mechanism, data retention and archival strategy - Designing and developing data extraction, cleansing, transformation, and loading processes and workflows to load data - Debug and tune data integration processes; analyze data warehouse architecture, normalized/de-normalized, star schemas and snowflakes, slowly changing dimensions, dimensional surrogate key handling, exception data processing, troubleshoot and recommend improvements and alternate methodologies - Create artifacts from perspective of technology, product, domain and infrastructure as applicable - Data Quality management - Guiding other team members and external vendors to perform the same - Ability to effectively work in a fast-paced, energetic team environment