Job Title: Database Architects
Location: Leander, TX
Employer: 4Consulting, Inc
Position Type: Full Time
Worksite: Hybrid
Position Summary
4Consulting, Inc is seeking a qualified Database Architects to support technology consulting, application development, systems analysis, testing, data management, cybersecurity, infrastructure, or project delivery services for client projects. The selected candidate will perform duties consistent with the client’s project requirements and company delivery standards.
Essential Duties and Responsibilities
The candidate will be responsible for:
- Develop and maintain ETL workflows using Informatica PowerCenter and cloud-based integration tools, including mappings, sessions, workflows, and reusable transformations.
- Integrate data from heterogeneous sources such as flat files, APIs, relational databases, and mainframe extracts into enterprise data platforms.
- Develop and optimize Oracle SQL/PL-SQL and Snowflake solutions, including data loading, schema design, queries, stored procedures, and performance tuning.
- Gather data requirements, develop source-to-target mappings, troubleshoot production ETL failures and data quality issues, and support batch scheduling and orchestration.
Minimum Qualifications
The position requires:
|
Education
|
Bachelor’s degree in Computer Science, Information Technology, Engineering, Business, or related field, or equivalent combination of education and experience.
|
|
Experience
|
8+ years of experience as a Data Engineer, ETL Developer, or Systems Analyst designing and supporting enterprise data integration solutions, including extensive Informatica, Oracle, Snowflake, SQL/PL-SQL, and production ETL experience.
|
|
Technical Skills
|
Informatica PowerCenter, Informatica Cloud Data Integration, Oracle SQL/PL-SQL, Snowflake, ETL/ELT Development, Data Integration, Source-to-Target Mapping, Batch Scheduling & Orchestration
|
|
Business / Domain Skills
|
Data Engineering, Enterprise Data Integration, Data Quality Management, Data Pipeline Operations, Data Management, SDLC & Change Management
|
|
Communication
|
Ability to communicate with technical and business stakeholders.
|
|
Documentation
|
Ability to prepare project documentation, status updates, and deliverables.
|
|
Work Authorization
|
Must be legally authorized to work in the United States. Sponsorship may be considered where permitted by company policy and project requirements.
|
Certification Required
None
Travel Required
None
Supervisory Role
No
Preferred Qualifications
- Experience with SAP BusinessObjects Universe design and maintenance.
- Experience supporting data integration solutions in state government or large enterprise IT environments.
Equal Employment Opportunity Statement
4Consulting, Inc is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion, sex, national origin, age, disability, veteran status, citizenship status, immigration status where protected by law, or any other legally protected status. All candidates will be evaluated based on job-related qualifications, experience, skills, availability, and ability to perform the essential duties of the position.
Never miss an opportunity! Create an alert based on the job you applied for.
