Informatica IICS / IDMC ETL Developer

Role: Informatica IICS / IDMC ETL Developer Location: Toronto Hybrid Job Description: Role and ResponsibilitiesAs a Informatica Intelligent Cloud Services (IICS) Informatica Intelligent Data Management Cloud (IDMC) Sr. Developer, need to perform overall system design development for applying Informatica capabilities and meet business requirements following best practices.Analyze data, using measurement techniques, drafting KPIs and building Data Sources, reports and dashboards to address business questions.Work with Subject Matter Experts and stakeholders to understand business problems and ETL system design, development based on the business requirements.Prepare design, review sign-off related documentation, training, and support for users at different levels.Key responsibilities of this role includeoTranslate detailed specifications into Informatica IICS ETL process design.oAnalyze, design, develop, test and document ETL processes.oMeet business requirement and deliver required code following industry best practices. Complete Hands-on involvement is needed.oAccomplishing ETL processes with scripts programming like VB, Shell or Perl scripts.oUtilize SQL, scripts andor other tools to assist with solution development.oConduct unit tests and assist in test preparations to ensure data integrity, data quality and program quality.oAssist with troubleshooting of ETL processes in Quality AssuranceSIT or Production environments.Using Agile approach, work closely with software developers, architects, business analysts, designers, and the clients representatives to define the direction and approach to design and development.Effectively communicate and build rapport with team members, stakeholders and business users. Prepare and deliver presentations to business users.