Informatica Developer

Job Description

• Responsible for data integration using in PWC, IICS Data Integration and IICS Application Integration.
• Responsible for data mappings in PWX and CDCs.
• Responsible for maintaining and supporting the application and related data processes in a production environment.
• Develops Informatica workflows following standards set by and for the team, including promotion standards, naming standards, data flow standards, documentation standards, and code repository standards.
• Recommends and influences the team on improvements in processes.
• Collaborates closely with project teams, including Business Analysts, Solution Architects, Project Managers, Application Developers, and BI Developers.
• Collaborates closely with operational teams, including DBAs, Service Operations Center, BI developers, and SAP developers.
• Collaborates with other members of the Informatica team to provide and receive peer reviews of all Informatica workflows and production deployments.
• Project responsibilities can include data modelling, logic development in SQL and/or Informatica, performance tuning, scheduling, and validation of data flows.
• Sustainment responsibilities can include:
  • Immediate incident resolution of data problems, performance problems, and integration problems.
  • Incident follow-up with root cause analysis
  • Incident change release and dev/acceptance reconciliation
• Provides maintenance for Informatica and Linux middleware which can include patching, installs, shell scripting, updates, and Informatica configuration.
• Recommends and influences the team on middleware improvements and understands the ETL landscape.
• Provides 24/7 on call support in rotation with the Informatica team.
• Understands the importance of quality data management methods to reduce duplication, maintain data integrity and apply records management processes (as appropriate).
• Maintains an awareness of upcoming trends in data management and ETL.

 POSITION REQUIREMENTS:

• Effective interpersonal skills and collaborative working style
• Demonstrated analytical and problem-solving skills
• Pays high attention to detail
• Comfortable working with ambiguity and defining logic for written business requirements
• Able to quickly grasp problems to provide incident resolution and brainstorming for technical requirements
• Adaptable and flexible to a fast-paced work environment and shifting priorities and responsibilities
• Ability to provide 24/7 support while oncall
• Bachelor’s degree in Computer Science, Information Systems, or equivalent education or work experience.
  • Minimum of 7-10 years of experience in ETL development with preference in Informatica
• Recent experience with many database systems and patterns, including:
  • Oracle, SQL Server, SAP eHana – advanced querying methods, performance tuning, and data virtualization;
  • Big data patterns – including event-driven, IoT, and data lake;
  • Data modelling – Star, Snowflake, and Relational;
  • NoSQL familiarity.
• Knowledge of implementation and system integration using APIs, MQ, FTP, and other integration software.
• Working knowledge of Linux and shell scripting
• Working knowledge of Control-M process scheduling