GrandPrairieRecruiter Since 2001
the smart solution for Grand Prairie jobs

ETL Architect

Company: TRC Staffing Services
Location: Grand Prairie
Posted on: January 15, 2022

Job Description:

ETL Architect/Technical LeadSummary: As an ETL Architect/Technical Lead in the Technical Operations organization, the ideal candidate will become part of a team responsible for the complete lifecycle and the management of Extract Transform Load (ETL) processes and database systems. Collaborating with business, development, and testing teams, facilitate accurate data reporting within company standards and maintain 24/7 system availability. Investigate and analyze issues, as well as research opportunities for improvement of processes. Provide expert system and technical advice and guidance to developers. Enable the use of data quality and accuracy as a strategic enabler.Required skills and abilities:Lead a team of ETL Developers/architects both onsite/offshore.Responsible for timely project deliveriesLeads in writing and reviewing software functional specifications.Participate in Architecture Review boards as an approver and participant.Mentors team and provide technical and strategic leadershipCollaborates with development teams, business units to identify, define, develop and implement new data source feeds.Monitors usage of the Data Warehouse to identify potential capacity overloads and bottlenecks.Assists with the tuning of ETL processes and database performance.Provides support for technical issues and ensuring system availability.Remains current on Enterprise Data Warehousing technologies, testing industry trends and best practicesOwnership of projects and responsible for deliverables.Design and Develop any/all ETL processes.Responsible for resource allocation, providing a level of effort for upcoming projects.Work with strategic vs. tactical requirements of the organization to fulfill the business needs.Additional responsibilities may be assigned Technical SkillsInformaticaAdvanced Informatica design and development skills using Informatica power center and power exchange. (10.1+ preferred)10+ years of experience in developing Informatica PowerCenter ETL mappings using Designer, Workflow Manager, Workflow Monitor, and Repository ManagerExperience using parameter files, parameters/variables, and troubleshooting using advanced Informatica techniques like session partitioning, push down optimization, etc.Oracle5+ years of experience in PL/SQL5+ years of experience in writing advanced queries for analysis and troubleshooting as needed.Must be well versed with database concepts like indexing, partitioning, performance tuning, explain plans, materialized viewsUnix (Sun Solaris or Linux)3+ years of experience writing shell scripts.Expertise in running jobs using various schedulers.Must be well versed with all Unix commands needed for running ETL jobs as well as for troubleshooting source and target files.Datawarehousing10+ years experience with data warehouse solution designs supporting data stores such as ODS, EDW, and DataMarts10+ years of experience with the design of large scale ETL solutions integrating internal and external data sources10+ years of experience creating design documents like High Level and Low-Level design documents.Experience troubleshooting and resolving issues related to ETL applications, ETL system performance, and data integrity.Experience with ETL design review, code review, and quality assurance review processes and deliverables.Experience in designing audit solutions.Experience with data analysis to identify data issues.Experience in working with onsite/offshore models.MDM and Data Governance experience will be a plus.Job SummaryJob number: 28660Date posted : 2021-07-28Profession: OtherEmployment type: Full Time

Keywords: TRC Staffing Services, Grand Prairie , ETL Architect, Professions , Grand Prairie, Texas

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Texas jobs by following @recnetTX on Twitter!

Grand Prairie RSS job feeds