Design and govern enterprise data architectures within the Informatica ecosystem. Lead data modeling, ETL/integration using Informatica tools, enforce data quality and governance, optimize performance, manage metadata and lineage, collaborate with stakeholders, document solutions, and train teams.
Key Responsibilities:
- Data Architecture Design: Collaborate with stakeholders, including business analysts, data engineers, and database administrators, to understand business requirements and design data architectures that support data integration, transformation, and storage within the Informatica ecosystem.
- Informatica Tool Selection: Evaluate and recommend appropriate Informatica tools and components for specific data-related projects and initiatives, ensuring alignment with organizational goals and data management standards.
- Data Modeling: Develop and maintain data models that capture the structure, relationships, and definitions of data entities, ensuring data accuracy, consistency, and integrity throughout the data lifecycle.
- Data Integration: Design and implement data integration solutions using Informatica PowerCenter, PowerExchange, and other relevant Informatica products to facilitate seamless data flow between various systems and platforms.
- Data Quality and Governance: Define and enforce data quality standards, data governance policies, and data security measures to ensure compliance with industry regulations and organizational data governance requirements.
- Performance Optimization: Identify opportunities to enhance data processing efficiency, optimize data workflows, and improve overall system performance using Informatica's performance tuning techniques.
- Metadata Management: Implement and maintain metadata repositories, enabling effective data lineage, data impact analysis, and data cataloging to support data governance and data lineage requirements.
- Collaboration and Support: Work closely with cross-functional teams, including data analysts, data scientists, and business stakeholders, to understand their data needs and provide guidance on leveraging Informatica solutions effectively.
- Documentation and Training: Create and maintain comprehensive technical documentation for data integration processes, data models, and system architectures. Conduct training sessions for end-users and team members to promote knowledge sharing and best practices adoption.
- Continuous Improvement: Stay abreast of the latest developments in Informatica technologies and data management practices, and proactively identify opportunities to improve existing processes and adopt new features to enhance overall data solutions.
Requirements:
- Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
- Proven experience as a Data Architect, with a focus on Informatica tools and technologies.
- In-depth knowledge of data modeling, data integration, ETL (Extract, Transform, Load) processes, and data governance principles.
- Hands-on experience with Informatica PowerCenter, PowerExchange, Informatica Data Quality (IDQ), and Informatica MDM (Master Data Management) is highly desirable.
- Strong SQL and database management skills.
- Familiarity with data warehousing concepts and data analytics tools.
- Excellent analytical, problem-solving, and communication skills.
- Ability to work collaboratively in a team environment and lead data-related projects.
- Experience in data profiling, data mapping, and data lineage analysis is a plus.
- Industry certifications in Informatica or data management domains are advantageous
Photon Chicago, Illinois, USA Office
11 East Adams Street Suite 1100, Chicago, IL, United States, 60603
Similar Jobs
Cloud • Information Technology • Security • Software • Cybersecurity
Lead the enterprise data platform strategy and architecture, driving Snowflake/dbt-based platform evolution, self-service Data Mesh and medallion models. Build AI-ready pipelines, RAG systems, and observability/cost frameworks while managing a central data team, supporting federated BI, and executing hands-on technical work.
Top Skills:
AiopsAutomated TestingCi/CdCortexData MeshDbtGitGraph RagMatillion Data Productivity Cloud (Matillion Dpc)Medallion ArchitecturePythonRetrieval-Augmented Generation (Rag)SnowflakeSnowparkSQLStreamlit
Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
Design and develop FPGA systems using VHDL and vendor toolchains. Create testbenches and perform simulation with QuestaSim, perform lab verification and debugging, manage configurations with Git, provide architectural input, and mentor/lead a team of engineers on communications-related FPGA projects.
Top Skills:
GitIntel QuartusLinuxMentor Graphics QuestasimVhdlWindowsXilinx Vivado
Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
Lead and deliver enterprise-scale IT projects (infrastructure modernization, cloud migration, cybersecurity, compliance) across the project lifecycle. Manage schedules, EVM, budgets, vendors, resources, risks, stakeholder engagement, change management, and benefits realization. Drive agile execution and executive communications.
Top Skills:
AgileCloud MigrationEarned Value Management (Evm)ExcelMicrosoft ProjectPowerPointServicenow SpmWord
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
