Informatica ETL Developer Job Description
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:
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:
Desired experience for informatica ETL developer includes:
Informatica ETL Developer Examples
Informatica ETL Developer Job Description
- 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
- 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
Informatica ETL Developer Job Description
- 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
- 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
Informatica ETL Developer Job Description
- 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
- 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
Informatica ETL Developer Job Description
- 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
- 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
Informatica ETL Developer Job Description
- 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
- 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