ETL Developer

August 26, 2021
Application ends: October 31, 2021
Apply Now

Job Description

Experience: 5-8 years

Educational Qualification: Bachelor degree in Computer Science or related field

Key Technical Skills: ETL, Python scripting

Roles & Responsibilities:

  • Extensive experience in designing and developing of complex mappings, applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter, joiner, and sorter transformations
  • Experience in integration of various data sources like DB2, SQL Server, and Flat Files into the staging area
  • Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Modify, Aggregator, XML parsing stages
  • Good experience with ETL tools: Informatica or SSIS/Data Stage-Good knowledge in identifying performance bottlenecks and also in tuning the Mappings and Sessions
  • Expert knowledge of DB2, SQL Stored Procedures, Triggers, and data querying optimization
  • Extensive experience working on UNIX platform, Perl scripting, python scripting, and managing Autosys jobs.
  • Excellent communication, interpersonal, analytical, and leadership skills, self-motivated, quick learner, and a team player Ability to work in a team and individually, independent thinker, focused on meeting deliverables in a remote environment
  • Ability to effectively interact with, present information to, and respond to questions from all levels of the organization and partners.
  • Ability to communicate complex analysis in a clear, precise, and actionable manner
  • Comfortable with ambiguity, creative thinking, and leading change
  • Financial Services experience, will be a strong plus
  • Desire working knowledge on building web pages, Java and MQ
  • Ability to research and troubleshoot technical problems