Informatica Architect Job Description

Informatica Architect Job Description

4.6
175 votes for Informatica Architect
Informatica architect provides solutions based on strong technical acumen and technical currency in a variety of ETL technologies specifically Informatica and SQL Server.

Informatica Architect Duties & Responsibilities

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

Sample responsibilities for this position include:

Create functional design for overall business intelligence solutions
Design Data Integration (ETL) projects using the Inofrmatica
Work with the Data Architecture group in the implementation of data warehousing solution
Develop and implement design and coding standards in Informatica
Participate in the entire project lifecycle including design and development of ETL solutions
Design data integration and conversion strategy, exception handing mechanism, data retention and archival strategy
Creating advanced mapping, mapplets, transformations, sessions, and workflows using Informatica PowerCenter 9.6
Designing and developing data extraction, cleansing, transformation, and loading processes and workflows to load data into Tata Communications Teradata environment
Guiding other team members and external vendors to perform the same
Analyzing data integration requirements, analyzing data sources and targets, business rules, and transformation logic

Informatica Architect Qualifications

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

Licensing or Certifications for Informatica Architect

List any licenses or certifications required by the position: MDM

Education for Informatica Architect

Typically a job would require a certain level of education.

Employers hiring for the informatica architect 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, Education, Information Systems, Business, Technical, Mathematics, Engineering, Computer Engineering, Technology, Statistics

Skills for Informatica Architect

Desired skills for informatica architect include:

DB2 and SQL Server
Hands on experience in Unix shell scripting to track /automate the jobs using scripts
Informatica ETL
Red Hat Linux
Relational Database Management Systems like Oracle
SQL
UNIX Shell scripts and should be able to write/debug Shell Scripts
Application architecture and design patterns
BI architecture
Core and advance Java

Desired experience for informatica architect includes:

Involved in all phases of software development from review of functional specification through assisting with test plans and final QA cycle
B.E./B
Collaborating with technical and business users to define performance requirements and improve efficiency
Performing code reviews for internal team members external vendor developers
Perform SIT testing for ETL processes / Review SIT testing for ETL processes performed by others
Support UAT for ETL processing

Informatica Architect Examples

1

Informatica Architect Job Description

Job Description Example
Our company is growing rapidly and is looking for an informatica architect. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for informatica architect
  • Support the definition and enforcement of ETL standards, guidelines and best practices related to TCL’s data warehouse
  • Analyze and optimize performance
  • Present the papers in national/ international publications & conferences
  • Understand the customer problem / engagement objectives
  • Develop custom solution by leveraging assets / services from the global market place
  • Provide recommendations to the client on tools, technologies for deployment on the basis of features, cost, performance
  • Build relationships and credibility with customers
  • Identify the appropriate quality model/ standard/ measure to be adopted in the project in conjunction with the customer requirements
  • Influence the customer to adopt the appropriate point of view on the solution aspects ( eg, quality standard, solution option, technology option etc)
  • COE / Practice Roadmap Business Planning and Development
Qualifications for informatica architect
  • Use the Informatica platform to extract, transform, and load data
  • 8+ years of hands-on experience with Informatica
  • 8 years Information Technology and Software Development experience within data warehousing domain required
  • Minimum of 4 years’ experience in the Telecom industry
  • Capability of articulating and communicating ETL design / strategy to other internal / external team members
  • Experience with OSS / BSS applications / functions including Order Management, Fulfillment, CRM, Service Delivery, Collection / Billing, Service Assurance, Business Intelligence / Reporting and Alarm Management / Ticketing systems highly desirable
2

Informatica Architect Job Description

Job Description Example
Our innovative and growing company is hiring for an informatica architect. 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 architect
  • Understand pain points from a customer/vertical perspective for developing specific solutions
  • Develop business case for the new service offering
  • Identify the customer segment to position the new offering
  • Develop business case for the initiatives
  • New Solution Development
  • Identify objectives and define the planning process
  • Develop solution blueprint involving partner capabilities, inhouse capabilities and new build
  • Create inhouse capabilities to support delivery in these new offerings
  • Develop business case , joint GTM plan with the partner and collaterals
  • Create artifacts from perspective of technology, product, domain and infrastructure as applicable
Qualifications for informatica architect
  • Analyze source system data to assess data quality
  • Ability to work across large teams, prioritize, collaborate and meet product release schedules
  • Bachelor of Science or equivalent in Computer Science, Computer / Electrical Engineering
  • Experience with BI tools such as SAP BI Suite (BO, Design Studio & Lumira) and Power BI highly desired
  • Knowledge of Salesforce.com (SFDC), CloudSense, BigMachines and Geneva a plus
  • Ability to effectively work in a fast-paced, energetic team environment
3

Informatica Architect Job Description

Job Description Example
Our company is hiring for an informatica architect. 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 architect
  • Provide technical SME support in reviewing large transformational / complex technical solutions / data models in terms of compliance to requirements, efficiency of solution or implementation
  • Act as the final escalation support for the respective technology areas
  • IP Building and Management
  • Identify patentable components in the solution and follow up on IP filing with the necessary teams
  • For the teams reporting to this role
  • Understand aspirations of associates, identify programs and certifications, growth areas for associates based on aspirations, project requirements
  • Monitor and manage the team member performance
  • As part of innovation / solution development, arrive at the asset development plan and business case
  • Provide the technical leadership, support and governance to build the assets
  • Propagate the appropriate consumers both internal and external
Qualifications for informatica architect
  • Established consulting background
  • 8+ years of Informatica
  • Data architecture and modeling experience implementing proper data structures for an ETL solution using INFORMATICA and is required
  • Knowledge of Microsoft's Master Data Services a plus
  • Technical expert centered around a technology, technologies or a portfolio of applications
  • Experience using Informatica 8.x or higher in a data warehouse environment including warehousing concepts, design and development of complex mappings, and merging data from multiple source systems including but not limited to ORACLE and flat files
4

Informatica Architect Job Description

Job Description Example
Our growing company is looking for an informatica architect. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for informatica architect
  • Sales Support and Project Estimation Develop (for large deals) / Review technical solution proposed
  • Develop (for large deals) / Review estimates for proposed solution
  • Develops and reviews implementation plans and contingency plans
  • Participate in Design and Build of different MDM domains
  • Work with third party suppliers and vendors for support, upgrades and implementations
  • Interface with and provide technical leadership to others in the IT division and business to address ongoing business needs
  • Document the application infrastructure and teach/share with others as necessary
  • Responsible for unit testing upgraded services
  • Defines and manages the governance structure for Informatica integration development and production support
  • Ensures that standard architecture decisions are implemented consistently across business and IT in order to support the business and IT strategy (researching, analyzing, designing, proposing, and delivering IT architecture solutions)
Qualifications for informatica architect
  • Demonstrated experience with Informatica Data Quality processes, approaches, measurement techniques and business cases for data profiling, data cleansing, standardization, match and merge with IDQ 8.x or higher
  • Demonstrated work experience implementing Fine Grain Access Control Audit (FGACA) and Virtual Private Database (VPD) to protect Health Care data such as Medicaid, Pharmacy, and HIPAA Protected Health Information (PHI)
  • Demonstrated Experience leading the ETL team in shaping and enhancing the overall ETL architecture using Informatica
  • Demonstrated experience writing complex UNIX scripts to validate and ftp files, and for calling Informatica workflows
  • Demonstrated experience specifying and conducting system testing
  • Demonstrated Experience in Dimensional Data Modeling for creating logical and physical data models using a commercial data modeling tool like ERWIN or ERStudio
5

Informatica Architect Job Description

Job Description Example
Our growing company is looking for an informatica architect. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for informatica architect
  • Design and Mentor project team members in the development of complex Informatica ETL solutions
  • Leads by example quality solution delivery
  • Works on multiple initiatives simultaneously
  • Highlights technical issues and challenges, and proposes creative solutions to clients and senior management
  • Provides technical direction to ETL developers, data architects, and application developers to architect, design, and implement solutions
  • Stays current on the Informatica suite of tools
  • Works closely with others to implement best-of-class ETL solutions
  • Actively participates in business requirements sessions, design review and test case review meetings
  • Design and Develop the architecture, roadmap, and standards for the DI platform
  • Establish self as subject matter expert (SME) for efficient/effective use of Informatica’s Cloud Services iPaaS platform (earn “Trusted Advisor” status)
Qualifications for informatica architect
  • Rhapsody experience working with Rhapsody, or Intersystems Ensemble, or equivalent messaging engines
  • 5 years of demonstrated experience using Informatica 8.x or higher in a data warehouse environment including warehousing concepts, design and development of complex mappings, and merging data from multiple source systems including but not limited to ORACLE and flat files
  • 3 years of demonstrated experience with Informatica Data Quality processes, approaches, measurement techniques and business cases for data profiling, data cleansing, standardization, match and merge with IDQ 8.x or higher
  • 5 years of demonstrated work experience implementing Fine Grain Access Control Audit (FGACA) and Virtual Private Database (VPD) to protect Health Care data such as Medicaid, Pharmacy, and HIPAA Protected Health Information (PHI)
  • 5 years of demonstrated Experience leading the ETL team in shaping and enhancing the overall ETL architecture using Informatica
  • 5 years of demonstrated experience writing complex UNIX scripts to validate and ftp files, and for calling Informatica workflows

Related Job Descriptions

Resume Builder

Create a Resume in Minutes with Professional Resume Templates