IBM ETL Database Architect

Posted on Indeed on Jun 09, 2021
No Corp-to-Corp. No sponsorship. 1099 contractor only. State or federal agency experience preferred.

Must be available to start 09/01/2021. 40 hours per week. Begins as a remote position due to COVID.

Years of required experience below must be documented on resume, with no exceptions. Do not apply if you do not meet all requirements.

Years of experience required per function below:
  • Extensive experience in architecting ETL Solutions, automation, and best practices.
  • Expertise in source data analysis, defining data granularity, data element mapping, and data warehouse design.
  • Hands-on experience with data conversion, performance tuning, and managing conceptual and physical data models.
  • Required | Extensive knowledge of/experience with data integration, data quality, multi-dimensional design, and ETL tools, processes, and methodology.
  • Experience with IBM Infosphere DataStage v8.x and above.
  • Experience with IBM Infosphere Warehouse.
  • Extensive experience with languages SQL and PL/SQL.
  • Experience working with databases DB2 LUW & zOS, Oracle 18c, and MSSQL Server.
  • Knowledge and experience with both DW and BI security architecture, especially involving disparate platforms preferably. Enterprise Resource Planning (ERP) software and Active Directory (AD).
  • Experience with highly complex application security requirements.
  • Must have Texas CPA experience with CAPPS HCM, CAPPS FIN, Texas Tax systems.
  • Experience working with metadata-driven auto-generated code performing full ETL life cycle.
  • Experience with implementing security and privacy requirements in a large enterprise environment.
  • Experience preparing all required artifacts accurately and in a timely fashion for the project.
  • Experience with UNIX scripting.
  • Experience with Socrata and Data sync file management process.
  • Knowledge of project management methodologies both traditional and Agile/Scrum.
  • Public sector experience (Federal, State, or Local Government).
  • Proficient with Microsoft Office products, including Outlook, TEAMS, Microsoft Project, Word, Visio, Excel, and PowerPoint.

  • 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 analysts 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.
  • 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.

Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Error on reporting

Related jobs