Job Description :

Duties:

  • Work with application developers, business analysts, DBAs, system administrators, data modeling teams for ETL build and design.
  • Translate business requirements into technical requirements.
  • Understanding of data quality methodologies and data governance to ensure standardization of data.
  • Contribute to the requirements elicitation process, create application architecture documents.
  • Design, develop and test ETL mappings, mapplets, workflows using Informatica BDM ( or Talend (5.x or 6.x) or Streamsets (3.6 and above).
  • Performance tuning of end-to-end ETL integration processes.
  • Determine optimal approach for obtaining data from diverse source systems.
  • Key contributor to initiatives that require technical expertise.
  • Work closely with the team responsible for maintaining the data model, including data dictionary/metadata registry.
  • Interface with business stakeholders to understand requirements and offer solutions.

Education:

  • Bachelor's Degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline.

Experience:

  • Possess expertise in project migration and release coordination activities.
  • Strong exposure working with relation databases DB2, Oracle & SQL Server including complex SQL constructs and DDL generation.
  • Experience in managing and deploying applications in AWS is preferred.
  • Strong knowledge of relational databases and extensive experience with SQL scripting / stored procedures in PostgreSQL.
  • Experience with data modeling and data mapping design.
  • Experience in SQL and conversion of SQL stored procedures into Informatica.
  • At least 2 years of experience in data lake development including Cloudera is preferred.
  • Strong scripting skills with some experience in software engineering.
             

Similar Jobs you may be interested in ..