+1 844 678 44 27


Company : Optghar
Req/job Title : ETL Informatica Developer
Job Ref No : 4857
Post Date : 06/19/2018
Country : USA
Job State/Province : Minnesota
Job City : Minneapolis
Experience : 8 - 0
OtherSkill :
Subject : ETL Informatica Developer
Description :

Duration: 12 months

Role Description: 8+ years 

  • Interpreting and analyzing business requirements and converting them into high and low-level designs.
  • Designing and developing ETL mappings keeping in view the performance criteria.
  • End-to-end ownership for developing, unit testing and migrating the ETL code with quality and minimal supervision.
  • Writing tuned SQL queries.
  • Performance Tuning of ETL code.
  • Work closely with customers, business analysts and technology & project team to understand business requirements, drive the analysis and design of quality technical solutions that are aligned with business and technology strategies and comply with the organization's architectural standards.
  • Understand and follow-up through change management procedures to implement project deliverables.
  • Coordinating with support groups such as DBA, Unix, Informatica admins to get the issues resolved in a quick turnaround time.
  • Working with data and ETL architects to help design an optimal solution.
  • Bachelor’s degree in Computer Science or similar field or equivalent work experience.
  • 4 to 8 years of experience with Informatica Power Center on Data Warehousing or Data Integration projects.
  • Proven ability to write high quality code.
  • Comfortable in writing complex ETL code.
  • Experience in writing complex SQL queries.
  • Experience in Oracle Environment using tools like Toad, Oracle SQL Developer.
  • Good knowledge of relational database preferably ORACLE and SQL Server.
  • Basic Knowledge of UNIX/LINUX shell scripting.
  • Strong problem-solving, multi-tasking and organizational skills.
  • Good written and verbal communication skills.
  • Demonstrated experience of working in a team spread across multiple locations.
  • TWS scheduler hands-on experience.
  • Experience in Informatica Power exchange.
  • Insurance business domain knowledge.
  • Experience in Big Data Technologies like Hadoop, Hive, Sqoop
  • Experience in ETL support.