Informatica Developer

PURPOSE OF THE POSITION

This position will provide support for existing workflows through performance tuning organic growth planning and creating new logic for data source changes. This position will be involved in new workflow development through database design logic design performance tuning and overall ETL architecture. Both sustainment and new project work will require deep collaboration with other teams in IS and BI and the rest of the Data Services team.

POSITION ACCOUNTABILITIES

• 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 followup 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.

Requirements

POSITION REQUIREMENTS :

Working knowledge of ControlM process scheduling

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