Job Title: ETL Developer Lead

Location: PCS HYD, Hyderabad

Years of Experience: 5-7 Years

Job Summary: We are seeking an experienced ETL Developer Lead to lead and participate in the development and management of ETL processes using Informatica Cloud, IICS, and Informatica Power Center. The ideal candidate will have extensive hands-on experience with Informatica Intelligent Cloud Services (IICS) components, including Application Integration, Data Integration, Informatica Data Quality, and CRM integrations such as Salesforce.

Responsibilities:

• Design, develop, and manage ETL processes using Informatica tools.
• Collaborate with cross-functional teams to gather requirements and implement solutions.
• Utilize IICS components for application and data integration.
• Develop application integrations using SOAP/REST APIs.
• Perform data analysis and profiling using Informatica and Excel.
• Ensure data quality and integrity throughout the ETL process.
• Provide technical guidance and mentorship to junior team members.
• Document ETL processes and maintain best practices.

Mandatory Skills:

• 5+ years of IT experience with hands-on development in ETL tools like Informatica Cloud, IICS, and Informatica Power Center.
• Strong experience with Informatica Intelligent Cloud Services components.
• Proficient in developing application integration using SOAP/REST APIs.
• Strong functional understanding of RDBMS and DWH-BI concepts.
• Excellent data analysis and profiling skills.
• Pipeline orchestration experience is a deal breaker.

Preferred Skills:

• Data modeling experience.
• Understanding of AWS concepts.
• Familiarity with SQL and React.

Qualifications: Bachelor’s degree in Computer Science, Information Technology, or a related field.