We are looking for an experienced Informatica Developer withexpertise in B2B transformations, creating parsing scripts using EDI files, anda strong understanding of data exchange, data transformations, and relatedconcepts. The ideal candidate will have hands-on experience with InformaticaPowerCenter 10.4, extensive knowledge of SQL, proficiency in UNIX, andfamiliarity with JIRA board activities.
Key Responsibilities:
Informatica PowerCenter 10.4 Development:Design, develop, and implement data integration solutions using InformaticaPowerCenter 10.4.
B2B Transformations: Work on end-to-end B2Btransformations involving complex business logic, using EDI formats (ElectronicData Interchange) and managing data exchange between partners.
Parsing Scripts: Create custom parsing scriptsusing EDI files to extract, transform, and load (ETL) data into the targetsystems.
EDI Files Handling: Understand and work withdifferent EDI file formats, including X12 and EDIFACT, and develop solutionsfor parsing, transforming, and serializing data.
Data Transformation & Mapping: Design andimplement complex data transformation rules, mapping data between source andtarget systems, while maintaining high-quality standards.
Serialized & Validator Concepts: Implementand optimize data serialization and validation processes, ensuring proper dataformatting and transformation between systems.
Data Exchange Processes: Manage and implementsecure and efficient data exchange between systems and partners, ensuringadherence to defined standards and protocols.
UNIX/Linux Proficiency: Develop, test, anddeploy scripts in UNIX/Linux environments, with a solid understanding of filehandling, shell scripting, and system automation.
SQL Expertise: Write complex SQL queries fordata validation, transformation, and manipulation. Conduct performance tuningfor SQL queries to ensure optimal execution.
ETL Monitoring & Debugging: Monitor ETL jobsand troubleshoot issues in data flows, ensuring timely resolution of any errorsor performance bottlenecks.
JIRA Board Management: Actively participate inAgile development processes, including task tracking, ticket management, andcollaboration within JIRA boards.
Documentation & Best Practices: Documenttechnical specifications, system processes, and best practices for datatransformations and integrations.
cross-functional Collaboration: Work closelywith business analysts, project managers, and other teams to gatherrequirements and deliver solutions aligned with business objectives.
Quality Assurance & Testing: Ensurehigh-quality code and solutions through rigorous testing, including unittesting, system integration testing, and performance testing.