Responsibilities:
• Deliver data models supporting design conforming to an enterprise conceptual model
• Develop data standards and promote their use
• Contribute to data data tool standards and governance processes
• Maintenance of data dictionary and/or metadata repositories
• Partner with other data architects to influence and support local data needs
• Classifies and establishes a priority list of data within an organization.
• Supervises the department's processes for data construction and design.
• Advises on the advanced functions and operational techniques of data administration tools and systems.
• Monitors data quality, compatibility and stability to meet current and future needs of the organization.
• Designs data access, usage and change rules for users within and across organizations.
Requirements
Bachelor’s degree in Computer Science preferred
7-8 years’ experience in the area of Informatica ETL Design and Architecture, data analysis, and/or reporting, data management, modeling,
Functional work in and familiarity with enterprise architecture concepts
Prior experience with financial services, retirement, insurance, or medical records industry highly desirable
Expertise with Star, Snowflake, and 3NF data modeling techniques as well as data warehousing data mart principles and methodologies
Expertise with data modeling tools such as ERWIN or Embarcadero ER Studio
Experience working with relational databases such as Oracle, SQL Server, DB2, Sybase
Experience working with ETL tools such as Informatica or SSIS
Successful in a matrixes work environment
Excellent documentation skills
Ability to collaborate and work in a multi-site environment
Experience working in an agile or continuous improvement environment
Head complex ETL requirements and design.
Experience with IDQ, MDM, other ETL tools
Implement an Informatica based ETL solution fulfilling stringent performance requirements.
Collaborate with product development teams and senior designers to develop architectural requirements to ensure client satisfaction with product.
Conduct impact assessment and determine size of effort based on requirements.
Develop full SDLC project plans to implement ETL solution and identify resource requirements.
Perform as active, leading role in shaping and enhancing overall ETL Informatica architecture.
Identify, recommend and implement ETL process and architecture improvements.
Assist and verify design of solution and production of all design phase deliverables.
Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL architecture.
Resolve difficult design and develop issues.
Strong understanding of SQL programming language, Stored Procedures and Indexes etc.
Working technical experience with designing, developing and supporting multi-terabyte database environments.
Good Knowledge on UNIX commands, shell scripting etc.
Good Knowledge on IBM Tivoli Scheduler (TWS) or Control-M for scheduling Workflows.
Good knowledge of applicable data privacy practices and laws.
Excellent communication skills – need to be able to interface with business as well as technical leaders
