"Business Intelligence ETL Developer IICS"

The candidate should have the following key responsibilities:

• 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

Desired skills for informatica architect include:

• Experience using cloud along with Informatica power center and data warehouse expertise
• Background in developing workflows, triggers along with integration and conversion experience using Informatica PowerCenter and Informatica Cloud
• Hands on experience in working with different databases e.g., SQL server, Oracle etc.
• Hands on experience in Unix shell scripting to track /automate the jobs using scripts and should be able to write/debug Shell Scripts
• Demonstrated experience with data integration architectures, data analysis and implementation
• Demonstrated experience with Enterprise level Data Warehousing
• Demonstrated experience with SQL and PL/SQL
• Demonstrated experience and ability to deliver results quickly in a fast-paced environment on multiple projects
• Ability to work with other IT groups and business users
• Experience with BFSI projects a strong plus

Preferred:

• Informatica Cloud Certification