Informatica Software Engineer/Senior Software Engineer

Experience: 3-5 years

Software Proficiency: Informatica

Database: SQL Server/Oracle, Teradata/Netezza/Green Plum

Business Intelligence Skills:

  • Good knowledge of dimensional modeling and DWH concepts like change data capture (CDC)
  • SQL Programming: Knowledge in basic and advanced concepts like PL/SQL, analytical functions etc.
  • Knowledge in Shell scripting
  • Data Profiling and Data validation
  • Ensuring accuracy and integrity of data and applications through analysis, coding, documenting, testing and problem solving
  • Setting up the development environment and configuration of the development tools
  • Efficient in coding and understanding the deliverables
  • Developing of the deliverables with unit testing and code documentation
  • Knowledge in performance tuning and optimization
  • Understanding and Implementing QA and various testing process in the project
  • Co-ordinating with the UAT team

Informatica:

  • Build the data gathering, collating and modeling process using Scripts and create the final model on MS Excel
  • Understanding the change data capture (CDC), slowly changing dimensions (SCD), Data Profiling and Data validation concepts
  • Experience in estimating ETL requirements, designing and architecting integration solutions
  • Good knowledge in designing and developing ETL mappings using Informatica Designer/any ETL tool
  • Configuring sessions/workflows using Workflow Manager
  • Understanding configuration, migration and deployment of ETL mappings
  • Knowledge in performance tuning and optimization

Additional Skills:

  • Exposure to other tools (MS SQL SSIS, Talend, DataStage, DataServices)
  • Understanding of/ Exposure to Reporting
  • Database skills with Netezza, Green Plum or Teradata.

To apply for this job please visit the following URL: http://www.systechusa.com/company/careers-apply/submit-resume-page/ →

adminInformatica Software Engineer/Senior Software Engineer