Pay range: $60 – $65
Job Description:
- Informatica Powercenter and SAP BODS hands-on experience, along with knowledge of pl/Sql.
- Design, develop, test and implement data pipelines based on 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/PL SQL 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.
Data Flows SQL ETL Scrum Informatica PowerCenter PL/SQL mapplets Microsoft SQL Server stored-procedures