Previous Job
ETL Developer
Ref No.: 17-00895
Location: Lewisville, Texas
Position Type:Direct Placement
Role: ETL Developer
Location: Lewisville TX
Duration: Permanent
Reports to: Sr. Data Integration Manager

The Role
We are searching for an ETL Developer to join our client team. The position is responsible for understanding requirements, solution design and ETL development. The candidate will then be responsible for the end to end development of the ETL processes, including documenting technical data flows between operational systems. This team member will analyze and review business requirement documents and complex data models. Candidates should have proven experience designing and developing transformation rules to support transaction databases. Must enjoy working closely with business partners to design flexible, supportable and extensible solutions.
 Participate in requirements and design sessions as well as being responsible for the development of ETL logic to meet business requirements for intake of data from clients and integration into systems
 Analyze and translate functional specifications and change requests into technical specifications along with the development, testing and implementation of ETL program logic
 Analyze data sources, write prototype SQL to prove data transforms
 Design, develop and tune solutions to integrate data provided by clients into systems with appropriate error handling and monitoring
 Ongoing production support and failure troubleshooting
 Design and develop solutions that identify data issues and report errors for further analysis
 Helps build positive relationships between business users and IT staff
 Utilize industry best practices and generally accepted procedures
 Collaborate with and mentor other team members
 Proactively develop and maintain technical knowledge in specialized area(s), remaining up-todate on current trends and best practices; leveraging expertise to produce world class solutions that are meaningful and useful to the business
 Understand the overall business, application and data landscape to assess the impact of change and to resolve technical issues as they arise
 Take an active role in maintaining and improving development practices, standards, procedures, and controls (e.g., documentation, development and testing)
 Evaluate and identify new technologies
 Works collaboratively with teammates
Preferred Qualifications
 Proven experience with data intake processes. Talend experience preferred. Will consider experience with other similar tools
 Working knowledge of querying complex data structures
 Highly skilled in ETL and SQL development
 Strong collaboration, multi-tasking and organization skills
 Linux and shell scripting experience is required
 Knowledgeable in Data Modeling
 Able to identify multiple approaches to problem solving and recommend the best-case solution
 Proven ability to work directly with users and management to gather requirements, provide
status updates, and build good relationships and rapport
 Must be proactive, innovative, and creative in meeting client/customer needs. Always keeping a
"Can do!” attitude
 Ability and willingness to work in a team environment and adopt a culture of ownership and initiative, and promote such within the team
 Degree in Computer Science preferred
 Experience with MySql database is a plus
 Background with Control-M is a preferred
 Exposure to GoAnywhere Managed File Transfer is a plus
 Knowledge and familiarity with database security concepts and best practices
 Comfortable contributing and debating in a casual and friendly team environment