Data Architect

Role: Data Architect

Location: Remote (US)

Employment Type: USC & GC only

Client: Staritas

We are looking for a Data Architect (Lead Engineer / Jr Architect) with strong Informatica experience to design, build, and govern enterprise data integration and data warehouse solutions. You will combine hands-on ETL development with data modeling and architecture ownership, guide the delivery team, and work with business and technical stakeholders from design through production support.

Required Skills:

- 10+ years in data engineering, ETL development, or data architecture

- Strong hands-on Informatica: PowerCenter (Designer, Workflow Manager, Monitor) and/or IDMC/IICS (Cloud Data Integration, Cloud Application Integration)

- Data modeling: conceptual, logical, and physical; star schema, snowflake schema, SCD Types 1/2/3, 3NF

- Data modeling tools such as Erwin, ER/Studio, or similar

- Advanced SQL and PL/SQL; query and index tuning on Oracle, SQL Server, Snowflake, or similar

- Data warehouse and data mart design, including staging, ODS, and reporting layers

- ETL best practices: error handling, restartability, audit and reconciliation, incremental and CDC loads

- Experience integrating varied sources: relational databases, flat files, APIs, XML/JSON, and mainframe or legacy feeds

- Job scheduling and orchestration (Control-M, Autosys, Airflow, or similar)

- Version control and release management (Git, Jenkins, or similar)

- Ability to lead design reviews, set standards, and mentor engineers

- Strong written and verbal communication with technical and business audiences

Responsibilities:

- Design and build scalable ETL/ELT pipelines in Informatica

- Create and maintain conceptual, logical, and physical data models

- Define architecture standards, mapping patterns, reusable components, and naming conventions

- Make and document architecture decisions for the warehouse and integration layers

- Review and approve designs and code from the development team

- Tune Informatica mappings, sessions, workflows, and SQL for performance and scalability

- Plan and support migrations, including PowerCenter to IDMC where applicable

- Define data quality checks, reconciliation, and audit controls

- Work with business analysts, QA, and stakeholders to turn requirements into designs

- Support data governance, metadata, lineage, and security requirements

- Troubleshoot production issues and own root-cause analysis and fixes

- Maintain design documentation, source-to-target mappings, and data dictionaries

- Take part in Agile ceremonies, estimation, and sprint planning

Typical Deliverables:

- Conceptual, logical, and physical data models

- Solution architecture and design documents

- Source-to-target mapping documents and data dictionary

- Informatica mappings, workflows, and reusable components

- Performance tuning reports and recommendations

- Data quality and reconciliation framework

- Deployment and runbook documentation

Preferred Qualifications:

- AWS, Azure, or GCP experience; Snowflake, Redshift, or Databricks

- Informatica Data Quality, MDM, Axon, or EDC exposure

- Data governance, metadata management, and lineage tools

- Python or shell scripting for automation

- CI/CD for data pipelines and Agile delivery experience

- Informatica or cloud certifications

- Experience in regulated industries such as healthcare or financial services

- Bachelor's degree in Computer Science, IT, or a related field