Sr. Informatica Developer


Washington, DC

Industry: Technology


Less than 5 years

Posted 237 days ago

  by    Cynet Sytems

This job is no longer available.

We are looking for Sr. ?Informatica ?Developer? for our client in Washington, DC

Job Title: ?Sr. ?Informatica ?Developer?

Job Location: Washington, DC

Job Type: Contract ? 12 Months / Contract to Hire / Direct Hire

Job Description:

Role Description: 

  • The Informatica Programmer is responsible for devising data conversion strategy for a system focused on delivering an advanced analytical capability to the client. Positional duties include the creation of new Informatica scripts, the transition of PL/SQL ETLs to new Informatica scripts, or the modification of existing scripts. The candidate will be involved in developing Informatica Mappings and writing complex Oracle PL/SQL programs for the Data Warehouse. 
  • Other tasks include analyzing transaction errors, troubleshooting issues in the software, developing bug-fixes, and providing performance tuning efforts.

Essential Job Functions:

  • Setup the Informatica environment in the DEV, TST, and PRD landscapes
  • Setup a development environment to develop and version maps, etc.
  • Create a common framework for error and exception handling, status reporting, and restart
  • Develop scheduling streams to schedule the maps, verify dependencies, and report job status
  • Configure Informatica Data Director (IDD) per MDM project requirements
  • Develop Informatica IDQ services
  • Integrate Informatica MDM and IDQ
  • Develop ETL between systems, as required (e.g. Develop the maps for moving data from SAP R3 to the corresponding tables in Oracle)
  • Implement data conversions, including mappings between systems
  • Create a common framework for error and exception handling, status reporting, and restart

Educational Qualifications and Experience:


  • Bachelors degree in Computer Science, Management Information, or ElectricalEngineering

??Role Specific Experience: 

  • 2+ years of strong implementation experience with Informatica MDM, Informatica IDQ, and Informatica ETL
  • Experience with PL SQL, and SAP BAPI, and ABAP
  • Experience with Informatica on SAP R3 and Oracle systems
  • Experience with the establishment of operational framework for Informatica based tasks
  • Informatica Powercenter, IDQ, and MDM development experience
  • Extensive experience in development, maintenance, and enhancement of Informatica Mappings, Work-flows, and processes
  • Project experience with developing complex SQL query and dimensional data model
  • Experience with developing and deploying Informatica in Unix and Oracle 11g database environment
  • Experience with MS SQL Server
  • Experience with creating complex Informatica ETL mappings and workflowsExperience coding complex SQL queries

Certification Requirements: 

  • None specified

Required Skills/Abilities:

  • Good verbal and written communication and presentation skills
  • Good knowledge of Oracle 11G PL/SQL
  • Ability to accomplish detail-oriented work
  • Ability to work under pressure in a demanding environment
  • Ingenuous, resourceful, and flexible approach to deal with issues
  • Ability to prioritize workload and balance conflicting demands
  • Determined team-work orientation, as well as a balanced responsiveness to client needs and requirements
  • Ability to implement restart, recovery, and status reporting
  • Ability to train in-house resources
  • Ability to analyze and retrieve metadata from Informatica repository
  • Ability to architect an ETL solution and data conversion strategy
  • Strong communication skills to work with clients, business users, and team members
  • Ability to work independently once guidance and goals are provided
  • Ability to work well in a team

Desired Skills/Abilities (not required but a plus):

  • Experience with the Informatica ETL tool
  • Firm understanding of relational database theory