What are the responsibilities and job description for the Database Architect 3 (5148425DA3) position at LMG Technology Services LLC?
Remote, United States
Scope/Description of Services
Perform Database Architect work as a member of the Data Governance team, overseeing one or more projects concurrently. Design, develop, and test Extraction Transformation Load (ETL) processes for the data warehouse. Develop and document ETL processes to extract data from existing systems into the data warehouse.
Document the “as-is” schemas currently in use at TWC. Perform other analysis and documentation tasks as required to facilitate and support TWC’s Enterprise Data Warehouse. Define and document the technical architecture.
Perform other analysis and documentation tasks as required. Perform other duties as assigned to maintain operations.
Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will not be considered for this opportunity.
| Years | Skills/Experience |
| 8 | Design and develop Extraction, Transformation, Load (ETL) processes for enterprise data warehouse using Informatica; Deep hands-on expertise with Informatica ETL processes, development, data management, data profiling, data flows, data relationships, and data quality standards and processes |
| 8 | Hands-on experience with data warehouse development and testing (relational and dimensional) and proven evidence to implement using databases like Oracle, SQL Server etc. but preferably Oracle |
| 8 | Analyzing and generating technical requirements and design |
| 8 | Hands on experience with data modeling preferably in a data warehouse environment |
| 8 | Experience with Informatica product suite in the Informatica cloud |
| 8 | Creating source to target mapping database documentation |
| 8 | Assist with migrating data from legacy database to new target database |
Preferred
| Years | Skills/Experience |
| 5 | More than one type of RDBMS (DB2, SQL Server, Oracle) |
| 5 |
erwin or other equivalent data modeling tools
|
| 3 | Experience in Amazon Web Services |
|
| Texas Workforce Commission experience |
Note: Start Date: April 2025 End Date: 08/31/2025; may be extended for 4 years. Contract may be amended, renewed, and/or extended providing both parties agree to do so in writing.
Ideal candidates must have a secure, dedicated workspace with Internet service, ability to maintain a reliable consistent work schedule, and be available for weekly meetings and group collaboration via Microsoft Teams and other applications during regular business hours. Position may require team members to come into the office for scheduled meetings, and there may be unscheduled requests with a seventy-two (72) hour notice for any TWC business need.
