Job Description
Role - ETL (Informatica) Lead/Architect
Experience Required - 5+ Years
Must Have Technical/Functional Skills
ETL Architect with Informatica expertise to design, develop, and optimize enterprise data integration solutions..
" Strong experience with Informatica PowerCenter
" Experience with Informatica IDMC and Google Cloud Platform (GCP)
" Expertise in ETL/ELT architecture and data warehousing concepts
" Strong SQL and database development skills
" Experience with databases such as:
Oracle Database
Microsoft SQL Server
DB2
Yellowbrick
BigQuery
" Knowledge of data modeling techniques (Star Schema, Snowflake Schema)
" Experience with cloud platforms:
Google Cloud
Informatica IDMC
" Familiarity with Unix/Linux shell scripting
" Knowledge of scheduling tools
" Understanding of DevOps, CI/CD, and version control
Roles & Responsibilities -
" Design and implement scalable ETL solutions using Informatica PowerCenter
" Develop enterprise data integration architecture and data migration strategies
" Analyze source systems and create efficient data mapping and transformation logic
" Build and maintain data pipelines for data warehouses and analytics platforms
" Optimize ETL performance, scalability, and reliability
" Collaborate with Product Teams, DBAs, and application teams
" Implement data quality, governance, and security standards
" Troubleshoot ETL failures, data discrepancies, and production issues
" Create technical design documents, architecture diagrams, and best practices
" Lead code reviews, deployment planning, and ETL framework improvements
" Support cloud migration and modernization initiatives.
Experience Required - 5+ Years
Must Have Technical/Functional Skills
ETL Architect with Informatica expertise to design, develop, and optimize enterprise data integration solutions..
" Strong experience with Informatica PowerCenter
" Experience with Informatica IDMC and Google Cloud Platform (GCP)
" Expertise in ETL/ELT architecture and data warehousing concepts
" Strong SQL and database development skills
" Experience with databases such as:
Oracle Database
Microsoft SQL Server
DB2
Yellowbrick
BigQuery
" Knowledge of data modeling techniques (Star Schema, Snowflake Schema)
" Experience with cloud platforms:
Google Cloud
Informatica IDMC
" Familiarity with Unix/Linux shell scripting
" Knowledge of scheduling tools
" Understanding of DevOps, CI/CD, and version control
Roles & Responsibilities -
" Design and implement scalable ETL solutions using Informatica PowerCenter
" Develop enterprise data integration architecture and data migration strategies
" Analyze source systems and create efficient data mapping and transformation logic
" Build and maintain data pipelines for data warehouses and analytics platforms
" Optimize ETL performance, scalability, and reliability
" Collaborate with Product Teams, DBAs, and application teams
" Implement data quality, governance, and security standards
" Troubleshoot ETL failures, data discrepancies, and production issues
" Create technical design documents, architecture diagrams, and best practices
" Lead code reviews, deployment planning, and ETL framework improvements
" Support cloud migration and modernization initiatives.
Numbers & Facts
| Location | Phoenix, AZ |
| Industry | Computer/IT Services |
| Company Size | 500 to 999 employees |
| Year Founded | 1990 |
| Website | http://q1tech.com/ |
About Company
Q1 consists of experienced and recognized experts providing the capability to respond to market demand in order to provide professional services for our clients including Enterprise software implementations, application integration and technical / functional support.
Q1 has steadily grown into a Quality IT services and solutions organization with the average experience of our team being over 10 years. We have continuously met or exceeded client expectations by delivering professional services and project implementations on time and under budget to help clients truly recognize return on investment.
Skills
- Best Practicesunmatched
- Cloud Computingunmatched
- Code Reviewsunmatched
- Continuous Deployment/Deliveryunmatched
- Continuous Integrationunmatched
- Data Analysisunmatched
- Data Managementunmatched
- Data Mappingunmatched
- Data Migrationunmatched
- Data Modelingunmatched
- Data Qualityunmatched
- Data Warehousingunmatched
- Database Extract Transform and Load (ETL)unmatched
- Database Programmingunmatched
- Database Technologyunmatched
- Design Documentunmatched
- DevOpsunmatched
- Enterprise Architectureunmatched
- Enterprise Data Integrationunmatched
- GCP (Good Clinical Practices)unmatched
- Identify Issuesunmatched
- Informaticaunmatched
- Linux Operating Systemunmatched
- Migration Strategyunmatched
- Performance Tuning/Optimizationunmatched
- SQL Databasesunmatched
- Snowflake Schemaunmatched
- Source Code/Configuration Management (SCM)unmatched
- Star Schemaunmatched
- Systems Analysisunmatched
- Technical Writingunmatched
- Technical/Engineering Designunmatched
- Unix Shell Programmingunmatched
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesFree resume builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder