Informatica ETL Developer Job Description

Informatica ETL Developer Job Description

4.5
180 votes for Informatica ETL Developer
Informatica ETL developer provides platform Administration for ETL platforms like Informatica PowerCenter, Informatica BDM, Tibco Composite, etc.

Informatica ETL Developer Duties & Responsibilities

To write an effective informatica ETL developer job description, begin by listing detailed duties, responsibilities and expectations. We have included informatica ETL developer job description templates that you can modify and use.

Sample responsibilities for this position include:

Perform advanced ETL development activities using Informatica, PL/SQL, Oracle Database tuning, SQL tuning, Informatica Server administration
Oracle experience from the development perspective (database and application), PL/SQL, Solaris
Informatica PowerCenter developer needed to develop and enhance ETLs from various sources to Oracle data warehouse
Plans and conducts Informatica ETL unit and development tests
Design, implement, test and maintain ETL components for multiple applications
Provide post-production application support as required
Provide data analysis to support new project definition/design to troubleshoot/resolve issues with existing subject areas
Work independently or as part of a team to deliver data warehouse ETL projects
Follow established standards and best practices and provide input for improvement of those processes
Maintain a high volume, multi-terabyte 24/7 data warehouse application

Informatica ETL Developer Qualifications

Qualifications for a job description may include education, certification, and experience.

Licensing or Certifications for Informatica ETL Developer

List any licenses or certifications required by the position: BODS, SAP

Education for Informatica ETL Developer

Typically a job would require a certain level of education.

Employers hiring for the informatica ETL developer job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Engineering, Education, Business, Information Systems, Technical, Information Technology, Management Information Systems, Technology, Design

Skills for Informatica ETL Developer

Desired skills for informatica ETL developer include:

BI architecture and data warehousing concepts
SQL
Informatica ETL
Informatica PowerCenter
Oracle
PL/SQL
TOAD
DB2 and SQL Server
Database design
Design and development of ETL packages

Desired experience for informatica ETL developer includes:

Must have 5 to 8 years of ETL experience
Experience with business intelligence tools like Business Objects is a plus
Practical experience with UNIX, UNIX & LINUX Scripting, Scheduling tools
Past experience in Asset Management is an added advantage
Should have hands on experience in Unix Shell Scripting
SAP HANA experience preferred

Informatica ETL Developer Examples

1

Informatica ETL Developer Job Description

Job Description Example
Our innovative and growing company is looking for an informatica ETL developer. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for informatica ETL developer
  • Create, maintain, and optimize stored procedures, functions, inline SQL, database structures, and ETL processes to adapt to changes in needs and requirements
  • Manage and direct the task of a team with up to two resources
  • Develops data movement processes for the data warehouse
  • Works closely with IT and business team members in the design and implementation of the data warehouse
  • Analyzes data structures in existing legacy systems in order to design extract, transform and load processes and data warehouse data structures
  • Makes recommendations, based on data profiling and data analysis, for changes to existing/legacy systems particularly in the area of automated data validations
  • Uses standard data modeling, data flow, and data documentation tools to analyze, document and present data analysis work
  • Works cooperatively with others to resolve data and process issues
  • Works with non-technical, subject matter experts to understand underlying data behavior and characteristics in ways that will be new for such non-technical people
  • Responsible for developing and managing ETL configurable artifacts (code, environment, configuration files, documentation, ) for client program
Qualifications for informatica ETL developer
  • Ramp-up and be adept in the processes related to WM TeraData and work closely with the review teams like TD engineering, TD DBAs and operations
  • Willingness to maintain and improve existing data transformations write new transformations
  • Knowledge of version
  • 3-5 years of Data Warehouse ETL experience
  • Current experience with Informatica PowerCenter v9+
  • Familiarity with Data Architecture and Data Modeling concepts
2

Informatica ETL Developer Job Description

Job Description Example
Our growing company is hiring for an informatica ETL developer. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for informatica ETL developer
  • Reviews test results with users, completes final program documentation, and obtains approval for changes
  • Gathers and documents business requirements for small and medium projects
  • Independently analyzes and documents impacts of business requests on existing system
  • Independently analyzes issues and uses judgement to make decisions
  • Create and refine system specifications
  • Translate detail program specifications for complex problems into coded computer instructions
  • Create and maintain processes / programs to adapt to changes in needs and requirements
  • Provide complete life-cycle in designing, developing, implementing and supporting sophisticated data manipulation processes
  • Strong knowledge on using Excel to Text formatting of data
  • Develops customized queries
Qualifications for informatica ETL developer
  • Minimum 2 years experience on Data Warehouse development
  • Strong aptitude and attitude for learning new concepts / skills
  • Experience with automated testing tools, SAP BO and Power BI a plus
  • Capability of articulating and communicating the overall architecture to development teams, business users, and executives
  • Proven experience designing and delivering data warehouse roadmaps in a large-scale environment w/ global reach
  • Minimum of 6 months of Informatica /ETL experience
3

Informatica ETL Developer Job Description

Job Description Example
Our company is hiring for an informatica ETL developer. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for informatica ETL developer
  • Work with key members of various departments to determine the definitions of essential data elements
  • Assist development teams to maintain all data sources and data storage options
  • Coordinate with application team and develop all ETL processes
  • Provide an efficient interface with brand for all processes across various platforms
  • Administer all requests and analyze issues and provide efficient resolution for same
  • Design all program specifications and perform required tests in same
  • Prepare codes for all modules according to require specification and client requirements and prepare all required test plans
  • Design all programs and systems and associate documentation for same
  • Prepare all program and system implementation for all informatics programs
  • Monitor all production issues and inquiries and provide efficient resolution for same
Qualifications for informatica ETL developer
  • Minimum 2 years of Informatica/ETL experience
  • Familiarity with performance tuning of sources, mappings, targets and sessions
  • Experience in high data volume environments
  • Knowledge of other ETL tools
  • Expertise in analytics and data analysis, report general tools and relational databases
  • Bachelor's Degree in Computer Science or a related field required with 6 years related data warehouse experience required and 10+ year of ETL development experience preferred
4

Informatica ETL Developer Job Description

Job Description Example
Our growing company is hiring for an informatica ETL developer. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for informatica ETL developer
  • Actively engage in building robust ETL solution using Informatica to harness the best practices in a typical Oracle environment
  • Lead the administration and development on a small Informatica PowerCenter implementation
  • Senior expertise in Informatica ETL development
  • Works with our project team members and business contacts to understand business needs and drivers, develop domain expertise, and identify analysis and reporting requirements
  • Excellent exposure on ETL tools like Informatica
  • Understand the source data available and map sources to the target design using a variety of tools, but primarily using the ETL tool of choice (Informatica)
  • Good to have OLAP tool development exposure like Qlikview, Qliksense and/or Tableau
  • Manage and perform data cleansing, de-duplication and harmonization of data received from, and potentially used by, multiple systems
  • Optimise the current ETL mappings and workflows
  • Engage in maintaining and troubleshooting daily data loads and addressing any issues
Qualifications for informatica ETL developer
  • Strong development background in Informatica ETL systems – Power Centre 8.5 and above
  • Practical experience in database technology with Oracle, DB2 and Sybase
  • Data modeling, data analysis, and database development experience required and extract transform and load (ETL) development experience preferred
  • Familiarity with business intelligence tools such as with Business Objects, Tableau, SSRS, or Cognos is desirable, but not required
  • Good knowledge of ETL development
  • Familiarity with dimensional data modeling
5

Informatica ETL Developer Job Description

Job Description Example
Our company is searching for experienced candidates for the position of informatica ETL developer. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for informatica ETL developer
  • Informatica PowerCenter base system configuration and support including installation, upgrades, performance tuning
  • Performance tuning and testing of the application code
  • May participate in a 24x7 rotational on-call responsibility
  • Create and maintain Tasks, Worklets, Workflow, Sessions, Mappings, Mapplets, Transformations
  • Trouble-shoot and solve configuration issues
  • Ability to work with business users in a dynamic development environment to collaboratively generate a solution that meets their requirements
  • Ability to design and build robust integrations
  • Ability to confidently identify and communicate recommendations to clients in response to their needs and problems
  • Take ownership of a piece of work and see it through to successful completion and hand off to support
  • Develop a trusting relationship with the client and act as a single point of contact for assigned projects
Qualifications for informatica ETL developer
  • Understands data profiling and data analytics
  • Proficient with MS Word, MS Excel, MS PowerPoint, MS Outlook, Internet, and Visio
  • Ability to support and work within standard software development life cycle practices
  • Demonstrates teamwork in facilitating workflow
  • High level of cooperation with others and is responsive to the Bank's needs
  • Able to put forward ideas for consideration and work toward foal irrespective of whether their ideas are adopted

Related Job Descriptions

Resume Builder

Create a Resume in Minutes with Professional Resume Templates