Informatica PC Developer
Job #: 22-06328
Pay Rate: Not Specified
Job type: contractor
Location: Hamilton, NJ
Pay Rate: Not Specified
Job type: contractor
Location: Hamilton, NJ
- Informatica Powercenter and SAP BODS hands-on experience, along with knowledge of pl/Sql
- Design, develop, test and implement data pipelines based existing Informatica PowerCenter and SAP BODS and SQL Server technologies.
- Review existing pipelines for opportunities to tune, optimize and harden
- Creates ETL Dataflows, Jobs, Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 10.x and SAP BODS 4.2 prepare corresponding documentation
- Designs and builds integrations supporting standard data warehousing objects (type2 dimensions, aggregations, star schema, etc.)
- Experience in developing scripts in a relational database i.e. SQL Server (TSQL and Stored Procedures) or Oracle using SQL/PLSQL Experience in performance tuning (Informatica/Stored Procs)
- Working knowledge of software development methodologies like Agile Scrum experience
- Should be able to independently handle root cause analysis and provide solutions for complex requirements
- Work with users to gather requirements to understand the functionality to resolve user system issues.
- Excellent oral and written communication skills; ability to express information and ideas vividly.
- Demonstrates aptitude in logical and analytical thinking, as well as displaying strong problem-solving skills to resolve production issues.