TriTech Enterprise Systems (TriTech) is seeking an "ETL Developer" for a State of LA client. This candidate will design, build, and manage data pipelines that extract, transform, and load data into storage systems, ensuring data quality, consistency, and usability for analytics and business intelligence.Core Responsibilities
ETL developers are responsible for managing the flow of data from multiple sources to centralized storage systems. Their work typically involves three main stages:
- Extract: Gathering raw data from various sources such as databases, APIs, flat files, or cloud platforms to provide a comprehensive view of organizational data.
- Transform: Cleaning, validating, and reshaping the data to meet business requirements. This may include formatting, aggregating, or enriching data to ensure it is accurate and consistent.
- Load: Storing the transformed data into a target system, such as a data warehouse, data lake, or database, making it ready for reporting, analytics, or operational use.
ETL developers require a combination of technical and analytical skills:
- Programming and Scripting: Proficiency in SQL, Python, or other scripting languages for data manipulation and automation.
- ETL Tools: Familiarity with platforms like Informatica, Talend, Microsoft SSIS, Oracle Data Integrator, or modern tools like Airbyte.
- Data Modeling and Analysis: Understanding of data structures, data warehousing concepts, and business intelligence requirements.
- Workflow Orchestration: Tools like Apache Airflow to manage and schedule ETL processes.
- Data Quality Management: Ensuring accuracy, completeness, and consistency of data through validation and cleansing techniques.
Skills Required
- Must live within 30 minutes of New Orleans, Louisiana.
- Proficiency in SQL, Python, or other scripting languages for data manipulation and automation.
- Familiarity with ETL tools such as Informatica, Talend, Microsoft SSIS, Oracle Data Integrator, or Airbyte.
- Understanding of data structures and data warehousing concepts.
- Knowledge of business intelligence requirements.
- Familiarity with workflow orchestration using tools such as Apache Airflow.
- Experience with data validation, cleansing, and quality management.
Similar Jobs
What We Do
TriTech Enterprise Systems, Inc., is an Information Technology (IT) Consulting company committed to increasing the competitive advantage of our clients by providing cutting edge solutions through innovation, research and the application of emerging technologies. Consulting Services TriTech provides consulting services to both large and small clients in the federal, state and local arenas. We provide detailed solutions in: Website Design, Online Store, Online Marketing, Search Engine Optimization (SEO), Selling Globally Online, Online Assessment Program and Project Management TriTech works closely with your team to initiate, plan, control, execute, and close out a major program, from developing a major new technology, installing a state-of-the-art system, reengineering an enterprise, or implementing new processes and tools to improve quality, cost, or delivery performance. Network Infrastructure Our experienced technical consultants design, implement and maintain your LAN and WAN. We provide upgrades, configuration, administration, service desk services and computer repair. We can assist your organization in designing an existing network or a completely new network both for today's needs and tomorrow's technology. Data Management TriTech can provide a database solution designed to enhance your efforts to support customers. We have extensive experience in developing and maintaining database systems. System Integration and Testing TriTech consultants will provide requirements analysis, systems analysis, systems architecture design and development, architecture implementation, test plans and testing, deployment and maintenance for your new or existing IT system. Information Assurance TriTech provides leading edge information assurance and systems security solutions. Our specialists will work closely with you to evaluate the security posture of your IT resources and recommend solutions in line with your business needs.
