Data Architect

Location: Remote (US)

Employment Type: USC & GC only

Client: Staritas

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