ETL Database Architect

2 weeks ago

Austin, United States Indotronix International Corporation Full time

OTHER SPECIAL REQUIREMENTS

CANDIDATE SKILLS AND QUALIFICATIONS:
• Must possess strong written, verbal, and interpersonal communication skills.
• Must be able to work independently in a team environment with local and remote teams.
• Must possess knowledge of project management methodologies both traditional and Agile/Scrum
• Must possess problem-solving skills and ability to multi-task with readiness to put in extra efforts when necessary.
• Must perform related work as assigned.

Onsite Requirement: Candidate will be working hybrid with some remote work opportunities; regularly scheduled in-office days (2x week) are required. Onsite and remote attendance will be directed/coordinated by the Direct Supervisor.

Support Requirement: Candidate may be required to provide support during late nights or weekends.

As an ETL Architect, the Candidate must be innovative and creative in solving complex solutions. The Candidate must have a strong background in developing comprehensive automated processes to extract data from disparate source systems, transform data as per business requirements, and load data into a data warehouse and various presentation models.

As an ETL architect, the Candidate will be responsible for:
• Analyzing evolving sources of data, determining, and implementing extraction methodologies
• Loading operational data models and data marts and re-architecting and standardizing existing ETL processes
• Working with users and business analyst to ensure that the correct data is being sourced into the Enterprise Data Warehouse and the sourced data

is in conformance with data governance guidelines.
• Developing processes and procedures in support of a large enterprise BI/DW environment
• Working with Business Customers, Section Managers, Project Managers, Business Analysts and Subject Matter Experts (SMEs) in a professional

and collaborative manner to define strategies and implementation approaches.
• Following software development processes, preparing detailed documentation, and generating work estimates in an SDLC environment.

As an ETL Architect, the Candidate must be quality conscious and be dedicated to delivering quality products on time and on budget.

Experience

7 Required Extensive experience in architecting ETL Solutions, automation, and best practices

7 Required Expertise in source data analysis, defining data granularity, data element mapping, and data warehouse design.

7 Required Hands-on experience with data conversion, performance tuning, and managing conceptual and physical data models.

7 Required Extensive knowledge of/experience with data integration, data quality, multi-dimensional design and ETL tools, processes, and methodology

6 Required Experience with IBM Infosphere DataStage v8.x and above

6 Required Experience with IBM Infosphere Warehouse

6 Required Extensive experience with languages SQL and PL/SQL

6 Required Experience working with data bases DB2 LUW & zOS, Oracle 18c and MSSQL Server

6 Required Knowledge and experience with both DW and BI security architecture, especially involving disparate platforms preferably Enterprise Resource Planning (ERP) software and Active Directory (AD)

5 Required Experience with highly complex application security requirements

5 Required Must have Texas CPA experience with CAPPS HCM, CAPPS FIN, Texas Tax systems

4 Required Experience working with metadata driven auto generated code performing full ETL life cycle

4 Required Experience with implementing security and privacy requirements in a large enterprise environment

4 Required Experience preparing all required artifacts accurately and in a timely fashion for the project

3 Required Experience with UNIX scripting

2 Required Experience with Socrata and Datasync file management process

1 Required Knowledge of project management methodologies both traditional and Agile/Scrum

3 Preferred Public sector experience (Federal, State or Local Government)

3 Preferred Proficient with the Microsoft Office products, including Outlook, TEAMS, Microsoft Project, Word, Visio, Excel, and PowerPoint

Indotronix is an Equal Opportunity Employer

  • ) ETL Developer

    3 weeks ago

    Austin, United States Saxon Global Full time

    Work Location: local to Chicago (Hybrid work schedule 3 days/week) Potential contract to hire opportunity-based on budget and need. Project Overview: Looking for an experienced DataStage ETL developer responsible for enhancing and supporting data ingest\egress integrations with Risk & Compliance Applications. Snowflake and Power BI knowledge required.This is...

  • Database Administrator

    4 weeks ago

    Austin, United States Texas Department of Aging & Disability Services Full time

    Job Description: The Database Administrator (Database Administrator IV) position performs advanced database administration tasks for databases used by applications with complex data models, workflows, and reports. Assists the team in creating and maintaining logical and physical data models. The DBA works on activities including but not limited to...

  • Snowflake Data Architect

    4 weeks ago

    Austin, United States Infosys Full time

    Infosys is seeking a Snowflake Data Architect. In this role, you will provide best-fit architectural solutions for one or more projects; provide technology consultation; assist in defining scope and sizing of work; anchor Proof of Concept developments and support opportunity identification and pursuit processes and evangelize Infosys brand. You will...

  • Oracle Database Architect

    4 days ago

    Austin, United States Georgia IT Inc Full time

    Oracle Database Architect Austin, TX (remote) Contract Experience with Oracle databases version 11x, 12x or later Experience in writing SQL for relational databases Experience designing, developing, and supporting Oracle databases Experience troubleshooting and performance tuning Oracle databases Experience creating new databases, writing stored...

  • ETL Engineer

    2 weeks ago

    Austin, United States RevOpsforce Full time

    Job DescriptionJob DescriptionAbout RevOpsforce:RevOpsforce is a revenue operations workforce management firm supporting clients to unlock revenue potential through solutions that better align people, processes, data, and technology. We empower organizations with cutting-edge revenue operations management systems, seamlessly aligning sales, marketing, and...

  • ETL Engineer

    2 days ago

    Austin, United States RevOpsforce Full time

    Job DescriptionJob DescriptionAbout RevOpsforce:RevOpsforce is a revenue operations workforce management firm supporting clients to unlock revenue potential through solutions that better align people, processes, data, and technology. We empower organizations with cutting-edge revenue operations management systems, seamlessly aligning sales, marketing, and...

  • Database Administrator

    1 month ago

    Austin, United States Dutech Systems Full time

    **Austin,TX**: **DatePosted : 5/1/2024 8:57:52 AM **:JobNumber : DTS101766147 JobType : W2 Skills: Database Experience, Oracle, Microsoft SQL, Database Design, Database Structures, Analysis, Software Development Life Cycle. **SALARY RANGE: 120K TO 130K Per Annum** **CANDIDATE SKILLS AND QUALIFICATIONS** **10 years**: Database experience. **8 years**:...

  • ETL Developer

    3 days ago

    Austin, United States Tekfortune Inc Full time

    Title - ETL Developer (with performance tuning experience) Location - Austin (Remote OK) JD For Performance Engineer (Data) Skill and Experience Required Experience in consuming large data volume Advance SQL skills Optimize strategy process for data handling for aggregation tables (Minimize processing time for large data volume) Experience in data loading...

  • Solution Architect

    2 weeks ago

    Austin, United States Health & Human Services Comm Full time

    This role will be responsible for the systems administration and configuration of data analytical technologies and tools for strategic initiatives and Data Analytics Support (DAS) projects. This role will work closely with data architects and other technical architects.**Essential Job Functions**: Leads the work efforts for CDA strategic initiatives and/or...

  • Sr. Cloud Data Architect

    1 month ago

    Austin, United States snipeHIRE Full time

    Job DescriptionJob DescriptionCOMPANYOur client specializes in digital enablement and digital transformation solutions for Fortune companies. Using industry-leading data engineering, process mining and automation platforms, they help large enterprises become more process-efficient and improve their end-customer experience by incorporating the use of RPA, AI...

  • Sr. Cloud Data Architect

    1 month ago

    Austin, United States snipeHIRE Full time

    Job DescriptionJob DescriptionCOMPANYOur client specializes in digital enablement and digital transformation solutions for Fortune companies. Using industry-leading data engineering, process mining and automation platforms, they help large enterprises become more process-efficient and improve their end-customer experience by incorporating the use of RPA, AI...

  • ETL Developer

    2 weeks ago

    Austin, United States Allied Consultants (Texas) Full time

    Overview: Allied Consultants, Inc. is an Austin-based firm which has for 32 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced ETL Developer to be a key resource on a technical services team. Allied Consultants offers its family of consultants excellent rates, a local support...

  • Senior Database Reliability Engineer

    2 months ago

    Austin, Texas, United States NinjaOne Full time

    Senior Database Reliability Engineer (DBRE) About the Role At NinjaOne we are passionate about building unified IT solutions that simplify the way IT organizations work. We are currently looking for a Senior Database Reliability Engineer (DBRE) to join our SRE team in the Platform Engineering organization and help us scale our products to millions of...

  • Data Architect

    1 week ago

    Austin, United States IDEA Public Schools Full time

    **Description** Data Architect Software Development Role Mission: IDEA is currently undergoing a significant digital transformation initiative to modernize our data and analytics infrastructure. As the new Data Architect, you will play a pivotal role in leading the architecture, design, and implementation of our next-generation data solutions. In this...

  • Solution Architect

    2 weeks ago

    Austin, United States Texas Department of Aging & Disability Services Full time

    Job Description: The solution architect will play a key role in designing and building the data architecture for data acquisition and transformation initiatives led by the Chief Data Architect. This individual will be a strategic leader, possessing strong technical skills and a foundational understanding of business processes. They will focus on complex,...

  • Senior ETL Informatica with Axon

    2 weeks ago

    Austin, United States HireBlazer Full time

    Role: Senior ETL Informatica with AxonLocation: Austin, TX (Hybrid)Contract: 15+ MonthsJob Description:The Developer s responsibilities may include: Working with subject matter experts (SMEs) across agencies to collect and update technical and business metadata.Load collected technical business metadata into EDC and Axon.Administer EDC and AxonDevelop ETL in...

  • Technical Architect

    6 days ago

    Austin, United States Zilliant Full time

    Zilliant powers intelligent B2B commerce with our industry-leading price optimization and sales guidance software. Our data science, cloud-native software, and passion for customer success deliver the highest ROI, fastest time to value, and highest customer satisfaction. If you’re ready to make an impact at a growing company that values the time, input,...

  • Technical Architect

    2 months ago

    Austin, United States Zilliant Full time

    Zilliant powers intelligent B2B commerce with our industry-leading price optimization and sales guidance software. Our data science, cloud-native software, and passion for customer success deliver the highest ROI, fastest time to value, and highest customer satisfaction.  If you’re ready to make an impact at a growing company that values the time, input,...

  • Technical Architect

    2 months ago

    Austin, United States Zilliant Full time

    Zilliant powers intelligent B2B commerce with our industry-leading price optimization and sales guidance software. Our data science, cloud-native software, and passion for customer success deliver the highest ROI, fastest time to value, and highest customer satisfaction.  If you’re ready to make an impact at a growing company that values the time, input,...

  • Senior Database Reliability Engineer Austin, TX

    1 week ago

    Austin, United States NinjaOne, LLC Full time

    Senior Database Reliability Engineer (DBRE) About the Role At NinjaOne we are passionate about building unified IT solutions that simplify the way IT organizations work. We are currently looking for a Senior Database Reliability Engineer (DBRE) to join our SRE team in the Platform Engineering organization and help us scale our products to millions of...