Senior Specialist - Data Engineering

LTIMindtree

  • Markham, ON
  • Permanent
  • Full-time
  • 15 days ago
Job Description:Role Informatica ETL Developer IDMCLocation Markham,Ontario,CanadaWorking model Hybrid 3 days Work From Office 2 days mandatory Tue Wed 1 day flexible any day from Mon Thu FriTechnical Primary Skills
  • Design develop and maintain ETL processes to extract transform and load data from various sources Handson experience in upgrading of Informatica PowerCenter from a lower version to a higher version
  • Proven experience as an ETL Developer Informatica PowerCenter and Informatica BDM
  • Proven experience as Database Developer hands on experience in writing DDLS and DMLS for relational databases
  • Experience in writing complex SQL queries for Adhoc reporting
  • Experience on automation tools like ControlM ASG ZENA Experience in writing Unix scripts
  • Develop and optimize complex SQL queries and stored procedures in PostgreSQL
  • Monitor dailymonthly jobs and resolve failures if any
  • Document technical specifications and maintain comprehensive documentation of ETL processes and database schemas
  • Collaborate with business teams to understand data requirements and ensure data integrity and accuracy
  • Knowledge of data warehousing concepts and best practices
  • Excellent problemsolving skills and attention to detail
  • Experience in Agile methodology JIRA
  • Above average communication and collaboration skills
  • Ability to work both independently and as part of a team
  • Preferable experience in the insurance industry able to understand underwriting data terminology
Technical Secondary Skills
  • Informatica Certified Professional ICP andor Informatica Foundation Level Certifications IDMC CDCG MDM etc
  • Experience with database systems eg Oracle Postgres MySQL SQL Associate Certification an asset
  • Knowledge of data visualization tools eg Qlik Python Power BI SAP BO
Soft Skills
  • Good communication
  • Presentation skills
  • Team player
  • Strong ability to work with client stakeholders
Skills:Mandatory Skills : IICS - IDMC,Informatica DVO,Informatica PowerCenter,ANSI-SQL,Dimensional Data Modeling,User Acceptance Testing,Selenium Testing Automation,UFT Testing Automation,API/Microservices RestAssured Testing,Functional/System Testing,Integration/Interface Testing,IOT Testing,SQL & Database testing,Performance Testing -Execution (Baseline, Load, Endurance, Stress, Volume,Network, DR, Failover, Spike, Saas based/COTS),RTM -Testing,Test Design and Execution -Testing,Test Reports and Dashboards -Testing,Jmeter, Blazemeter -Performance TestingAbout Company:LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 700 clients, LTIMindtree brings extensive domain and technology expertise to help drive superior competitive differentiation, customer experiences, and business outcomes in a converging world. Powered by 83,000+ talented and entrepreneurial professionals across more than 40 countries, LTIMindtree — a Larsen & Toubro Group company — solves the most complex business challenges and delivers transformation at scale. For more information, please visit https://www.ltimindtree.com/.

LTIMindtree