ADP
Location
Hyderabad | India
Job description
ADP is hiring for an Informatica Developer in Hyderabad
We are seeking candidates with 5 to 10 years of hands-on experience in designing and developing Informatica applications. The ideal candidates should possess expertise in the following areas: Hands-on experience with ETL Tools like Informatica Cloud, IICS, and Informatica Power Center. Proficiency in implementing Informatica Intelligent Cloud Services (IICS) and Power Center. Strong knowledge of cloud computing architecture. Expertise in database systems such as Oracle and SQL Server. Designing, developing, and maintaining Informatica Cloud data integration processes using appropriate data load techniques. Analyzing the impact of changes on existing ETL processes and systems, assessing compatibility with goals, cost-effectiveness, and feasibility. Debugging and optimizing data integration processes, analyzing data warehouse architecture, and recommending improvements and alternate methodologies. Designing, developing, and maintaining database objects (tables, views, stored procedures) and SQL scripts. Hands-on experience in Informatica Intelligent Cloud Services (IICS) components - application integration, data integration, Informatica data quality, Informatica Power Center, and CRM applications like Salesforce. Development experience in application integration using SOAP/REST APIs and leveraging APIs to integrate multiple systems. Strong functional understanding of RDBMS DWH-BI conceptual knowledge and excellent SQL skills with performance tuning capabilities. Proficiency in writing shell scripts. Excellent knowledge of the Informatica platform and its integration among different components and services. Strong data analysis and data profiling skills using Informatica and Excel. Extensive experience in infrastructure architecture, including designing, hardware sizing, effort estimation, and security. Implementation of SCD1 and SCD2 logic, knowledge of Star and Snowflake schemas, data modeling experience, understanding of AWS concepts, and familiarity with Python (a plus).Job tags
Salary
