Job Information Date Opened 01/10/2025 Job Type Full time Work Experience 5+ years Industry IT Services City Hyderabad State/Province Telangana Country India Zip/Postal Code 500032 Job Description We are looking for an experienced Informatica Developer with expertise in B2B transformations, creating parsing scripts using EDI files, and a strong understanding of data exchange, data transformations, and related concepts. The ideal candidate will have hands-on experience with Informatica PowerCenter 10.4, extensive knowledge of SQL, proficiency in UNIX, and familiarity with JIRA board activities. Key Responsibilities: Informatica PowerCenter 10.4 Development: Design, develop, and implement data integration solutions using Informatica PowerCenter 10.4. B2B Transformations: Work on end-to-end B2B transformations involving complex business logic, using EDI formats (Electronic Data Interchange) and managing data exchange between partners. Parsing Scripts: Create custom parsing scripts using EDI files to extract, transform, and load (ETL) data into the target systems. EDI Files Handling: Understand and work with different EDI file formats, including X12 and EDIFACT, and develop solutions for parsing, transforming, and serializing data. Data Transformation & Mapping: Design and implement complex data transformation rules, mapping data between source and target systems, while maintaining high-quality standards. Serialized & Validator Concepts: Implement and optimize data serialization and validation processes, ensuring proper data formatting and transformation between systems. Data Exchange Processes: Manage and implement secure and efficient data exchange between systems and partners, ensuring adherence to defined standards and protocols. UNIX/Linux Proficiency: Develop, test, and deploy scripts in UNIX/Linux environments, with a solid understanding of file handling, shell scripting, and system automation. SQL Expertise: Write complex SQL queries for data validation, transformation, and manipulation. Conduct performance tuning for SQL queries to ensure optimal execution. ETL Monitoring & Debugging: Monitor ETL jobs and troubleshoot issues in data flows, ensuring timely resolution of any errors or performance bottlenecks. Informatica Session & Workflow Management: Design, implement, and monitor Informatica PowerCenter sessions, workflows, and mappings. JIRA Board Management: Actively participate in Agile development processes, including task tracking, ticket management, and collaboration within JIRA boards. Documentation & Best Practices: Document technical specifications, system processes, and best practices for data transformations and integrations. cross-functional Collaboration: Work closely with business analysts, project managers, and other teams to gather requirements and deliver solutions aligned with business objectives. Quality Assurance & Testing: Ensure high-quality code and solutions through rigorous testing, including unit testing, system integration testing, and performance testing. Requirements What you’ll do Informatica PowerCenter 10.4 Development: Design, develop, and implement data integration solutions using Informatica PowerCenter 10.4. B2B Transformations: Work on end-to-end B2B transformations involving complex business logic, using EDI formats (Electronic Data Interchange) and managing data exchange between partners. Parsing Scripts: Create custom parsing scripts using EDI files to extract, transform, and load (ETL) data into the target systems. EDI Files Handling: Understand and work with different EDI file formats, including X12 and EDIFACT, and develop solutions for parsing, transforming, and serializing data. Data Transformation & Mapping: Design and implement complex data transformation rules, mapping data between source and target systems, while maintaining high-quality standards. Serializer & Validator Concepts: Implement and optimize data serialization and validation processes, ensuring proper data formatting and transformation between systems. Data Exchange Processes: Manage and implement secure and efficient data exchange between systems and partners, ensuring adherence to defined standards and protocols. UNIX/Linux Proficiency: Develop, test, and deploy scripts in UNIX/Linux environments, with a solid understanding of file handling, shell scripting, and system automation. SQL Expertise: Write complex SQL queries for data validation, transformation, and manipulation. Conduct performance tuning for SQL queries to ensure optimal execution. ETL Monitoring & Debugging: Monitor ETL jobs and troubleshoot issues in data flows, ensuring timely resolution of any errors or performance bottlenecks. Informatica Session & Workflow Management: Design, implement, and monitor Informatica PowerCenter sessions, workflows, and mappings. JIRA Board Management: Actively participate in Agile development processes, including task tracking, ticket management, and collaboration within JIRA boards. Documentation & Best Practices: Document technical specifications, system processes, and best practices for data transformations and integrations. cross-functional Collaboration: Work closely with business analysts, project managers, and other teams to gather requirements and deliver solutions aligned with business objectives. Quality Assurance & Testing: Ensure high-quality code and solutions through rigorous testing, including unit testing, system integration testing, and performance testing. What you’ll bring Informatica PowerCenter 10.4: Strong experience in Informatica PowerCenter 10.4, including ETL design, mapping, session management, and workflow configuration. B2B Transformation: Proven experience with B2B transformations, specifically using EDI (X12, EDIFACT) formats. EDI Parsing and Serialization: Proficient in creating parsing scripts, serializers, and validators in Informatica for data exchange and transformation. SQL Skills: Strong experience in writing complex SQL queries for data manipulation, validation, and optimization. UNIX/Linux: In-depth knowledge of UNIX/Linux systems and scripting for automation and task management. JIRA: Experience with Agile methodologies and active participation in JIRA-based project management activities. Data Integration: Deep understanding of data integration concepts, including ETL, data mapping, transformations, and data quality Troubleshooting & Debugging: Ability to identify and resolve technical issues with data transformations, EDI parsing, and workflow execution. Excellent Communication: Strong communication skills to collaborate with business stakeholders, technical teams, and management. Benefits 1. Culture: Open Door Policy: Encourages open communication and accessibility to management. Open Office Floor Plan: Fosters a collaborative and interactive work environment. Flexible Working Hours: Allows employees to have flexibility in their work schedules. Employee Referral Bonus: Rewards employees for referring qualified candidates. Appraisal Process Twice a Year: Provides regular performance evaluations and feedback. 2. Inclusivity and Diversity: Hiring practices that promote diversity: Ensures a diverse and inclusive workforce. Mandatory POSH training: Promotes a safe and respectful work environment. 3. Health Insurance and Wellness Benefits: GMC and Term Insurance: Offers medical coverage and financial protection. Health Insurance: Provides coverage for medical expenses. Disability Insurance: Offers financial support in case of disability. 4. Child Care & Parental Leave Benefits: Company-sponsored family events: Creates opportunities for employees and their families to bond. Generous Parental Leave: Allows parents to take time off after the birth or adoption of a child. Family Medical Leave: Offers leave for employees to take care of family members' medical needs. 5. Perks and Time-Off Benefits: Company-sponsored outings: Organizes recreational activities for employees. Gratuity: Provides a monetary benefit as a token of appreciation. Provident Fund: Helps employees save for retirement. Generous PTO: Offers more than the industry standard for paid time off. Paid sick days: Allows employees to take paid time off when they are unwell. Paid holidays: Gives employees paid time off for designated holidays. Bereavement Leave: Provides time off for employees to grieve the loss of a loved one. 6. Professional Development Benefits: L&D with FLEX- Enterprise Learning Repository: Provides access to a learning repository for professional development. Mentorship Program: Offers guidance and support from experienced professionals. Job Training: Provides training to enhance job-related skills. Professional Certification Reimbursements: Assists employees in obtaining professional certifications. Promote from Within: Encourages internal growth and advancement opportunities