Senior Informatica Developer

Position: Senior  Informatica Developer
Location: Bengaluru

Key Responsibilities

ETL Development:
Design, develop, and maintain ETL processes using Informatica Power Center and IICS.
Implement data integration solutions to support EDW requirements.
Optimize ETL workflows for performance and scalability.
Cloud Data Integration (CDI):

Experience with Mappings, Mapping Task, Taskflow, Replication & Synchronization jobs.
Handling dynamic parameter values.
Designing Taskflow with loops, IF-ELSE, and exception handling.
Design and implement scalable data integration solutions using cloud platforms
Cloud Application Integration (CAI):
Develop and maintain integrations using Informatica CAI.
Collaborate with cloud architects to ensure seamless integration of cloud- based applications.
Monitor and troubleshoot CAI integrations to ensure reliability and performance.
Build and manage RESTful APIs for data exchange and automation.
Defining Custom APIs and Policy Rates,
Familiarity with API authentication techniques.
Good knowledge of XQuery.
Creating Service Connectors, App Connectors, and Process Objects
On-Prem Development:
Design and develop on-premise ETL processes to integrate data from legacy systems.
Maintain and enhance existing on-prem ETL workflows.
Ensure data quality, consistency, and integrity in the on-premise environment.
Good to have cloud modernization experience.
Data Warehouse Support:
Collaborate with data architects to design and implement scalable data warehouse schemas.
Support the Enterprise Data Warehouse (EDW) environment by monitoring performance and resolving issues proactively.
Conduct data profiling and quality assessments to ensure accuracy and consistency in reporting.
Demonstrate strong SQL skills and a solid understanding of data warehouse concepts, with hands-on experience in writing and validating queries through unit testing and user acceptance testing (UAT).
in implementing complex logic using JOINs, IF-ELSE conditions, CASE statements, and looping constructs.
Experienced in developing and maintaining Stored Procedures, Packages, and Functions for data transformation and business logic implementation.
Collaboration and Communication:
Work closely with business analysts and stakeholders to understand data requirements.
Collaborate with cross-functional teams to design and implement data solutions.
Provide technical guidance and support to team members.
Documentation and Training:
Document ETL processes, data flows, and integration solutions.
Conduct training sessions and provide support to end-users and team members.

Qualifications

Bachelor's degree in Computer Science, Information Technology, or a related field.

Experience

5+ years of experience in Informatica ETL development.
3+ years of experience with Informatica IICS and CAI.
Proven experience in developing and maintaining on-premise ETL processes.

Skills

Strong proficiency in Informatica Power Center, IICS, and CAI.
Knowledge of SQL, PL/SQL, and database design principles.

Experience with data warehousing concepts and best practices.
Excellent problem-solving and analytical skills.
Strong communication and collaboration abilities.

Preferred Qualifications

Experience with other ETL tools and data integration technologies.
Knowledge of cloud-based data warehousing solutions.
Certification in Informatica or other relevant technologies.

Skills:

data integration,data warehouse,etl,integration,data,sql