Etl lead vs informatica etl developer

Differences between etl lead and informatica etl developer duties and responsibilities

Etl lead example responsibilities.

• Manage the issues raise from QA and assign work items to the team and take up critical work items.
• Lead defect review meetings with business team leads as well as QA lead and prioritize development tasks around project milestones.
• Involve in writing UNIX shell scripts and automate the sessions running processes and also write UNIX Perl scripts for business needs.
• Provide technical leadership and manage all aspects of the SDLC process-requirement analysis, design, development, testing, and support/maintenance.
• Administrate SharePoint database access; manage classified documents and applications.
• Involve in writing TeraData scripts.
Show more

Informatica etl developer example responsibilities.

• Support and maintain production Cognos web portal to manage the OLAP cube and folders.
• Used various transformations like expression, union, source qualifier, aggregator, router, store procedure, lookup transformations.
• Work on transformations such as source qualifier, joiner, lookup, rank, expression, aggregator and sequence generator etc.
• Work with relational databases like DB2.
• Develop mappings with XML as target and formatting the target data according to the requirement.
• Work with logical, physical, conceptual, star, snow flake schema data models.
Show more