Go Back
ETL and Integration Developer Loc:Dallas, TX
2015-11-23 09:06:26
Job Type:
Full Time only
Budget $:
100,000 - 200,000
Responsibilities: - Follow standard SDLC processes, from requirements gathering, functional design, technical design, system testing, integration testing, deployment and support as they relate to data warehouse projects and enterprise data integration efforts.
- Engage closely with business analysts and report developers to determine business needs and provide expertise to deliver extract, transform and load process solutions.
- Support and maintain data warehouse and operational data store environments with proactive approach towards upgrades and performance enhancements to improve report and dashboard user experience.
- Troubleshoot and resolve DW and ODS data load job and related scheduler issues.
- Create and maintain data dictionary, source-target mapping, data lineage and DW and ODS operational documentation.
- Work closely with system and business owners on data quality initiatives.
- Understand all components in the data movement lifecycle, including data source interrogation, interface types, network infrastructure and impact, tool design and data processing methods.
- Carefully track and document solutions for ETL and data integration requests through change management ticketing system.
- Drives discussion and challenges business units on innovative ways to successfully utilize data and available tools to advance business objectives.
- Pilot and provide proof-of-concept solutions around next-generation business intelligence and analytics tools, specifically in the ETL and data integration space.
Qualifications:- Minimum 5 years experience working with Finance, Operations, Marketing, Sales and HR teams, from an end-to-end ETL and data integration development perspective.
- Minimum 5 years hands-on experience writing ETL and data integration code using related toolsets (i.e. SSIS, Informatica, ODI, DataStage, etc.).
- Minimum 5 years hands-on experience writing stored procedures (T-SQL, PL/SQL) or complex queries in relational databases (SQL Server 2008+ and/or Oracle 10g+).
- Minimum 5 years hands-on experience writing ETL and data integration processes in an enterprise data warehousing environment.
- Minimum 5 years hands-on experience developing dimensional and relational data models.
- Experience with middleware technologies is a plus.
- Experience with TM1 Turbo Integrator is a plus.
- Experience developing solutions in the travel and hospitality industry is a plus.
- Demonstrate core customer service behaviors as a trusted IT advisor to the business.
- Goal driven and desires to produce high customer satisfaction.
- Ability to work independently with minimum supervision with strong attention to detail.
- Ability to work flexible hours, as needed, given tight project deadlines.
- Ability to communicate status, issues, designs and plans to managers, peers and business partners.
- Ability and desire to learn new technologies quickly and manage multiple tasks.
- Must adhere to organizational codes of conduct and confidentiality.
- Bachelors degree required, preferably in Management of Information Systems or Computer Science.
Key Skills: