Role-IICS Developer

Exp-6+ years

Location-Bengaluru, Chennai, Hyderabad, Mumbai, Indore, Ahmedabad

Skills:
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

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 recent 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 quick-paced, energetic team setting

📌 Iics Developer Bengaluru
🏢 Tata Consultancy Services
📍 Bengaluru