What are the responsibilities and job description for the Informatica ETL Developer position at Tal-Ex?
Over 8 years of IT experience in Data warehouse Environment in System Analysis, Design, Development and Testing fields of Data Warehousing, Client server technologies with ETL tool Informatica 9.x,8.x.
Expertise in all activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using Power Center and Power Exchange.
Experience in Data Warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources systems Oracle, Teradata, MS SQL Server, Mainframe, MySQL, Composite, Matrix, Salesforce.com and Flat Files into data warehouse using Informatica Power Center.
Extensively used Informatica tools, Designer, Workflow Manager, Work flow Monitor, Repository Manager.
Proficient in writing complex PL/SQL Packages, Stored Procedures, Triggers, Performance tuning, Application tuning and Query Optimization using Hints, Explain plan.
Worked on Job Monitoring tools IBM Control-M, Corn Scheduler, Tivoli Maestro, Autosys
Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
Worked in production support role, maintained and monitored informatica jobs. Extensively worked on Control-m monitoring tool and Informatica monitoring tools to identify the Informatica data load , server connectivity issues
Worked on Impact Analysis to identify the dependencies using Metadata Manager for lineage and extensively used Metadata queries for validating/analysis of Production Support jobs.
Strong experiences in UNIX shell scripting. Created scripts for calling pmcmd command, file watcher, FTP and file archiving scripts. Experience in writing UNIX Shell Script / Batch Script for various ETL/Database jobs and schedules.
Worked on Agile Methodology, Software development lifecycle (SDLC), Perform Release Management by undertaking Agile Methodology's Sprints.
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a Informatica ETL Developer?
Sign up to receive alerts about other jobs on the Informatica ETL Developer career path by checking the boxes next to the positions that interest you.
