ETL Informatica Developer
Apply NowCompany: Sarian, Inc.
Location: Charlotte, NC 28269
Description:
ETL Informatica Developer
Charlotte, NC / Dallas, TX / Pennington NJ/ Jersey City NJ
Job Description:
Charlotte, NC / Dallas, TX / Pennington NJ/ Jersey City NJ
Job Description:
- Extensive Knowledge on Informatica.
- Informatica PowerCenter, BDM related development activities
- Performs analysis, design and development of ETL processes to support project requirements.
- Develop Informatica mappings, SQL/stored procedures as well as data maps for Power Exchange
- Create data mapping and workflow using Informatica Power Center to extract, transform and load
- Conduct ETL optimization, troubleshooting and debugging
- Assist in documenting and maintaining operational procedures in the form of an operations manual for all ETL workflow
- Assist with troubleshooting efforts for ETL job issues related to pre-production and production
- Experience is SQL programming and query optimization
- Performance tuning and troubleshooting
- Job scheduling tools (e.g. Autosys) & Version control tool like Git .
- Unix shell scripting.
- Basic knowledge on Mainframe, should be able to navigate through the jobs and code.
- Quick learner and self-starter who requires minimal supervision to excel in a dynamic environment.
- Strong Verbal and written Communication skills.
- Prior experience of working with globally distributed teams
- Agile driven development