Lead ETL Developer in Dallas, TX at DISYS

Date Posted: 10/3/2018

Job Snapshot

Job Description

Job Description:

Must have skills- ETL, Greenplum, Datastage, SQL ,Linux


Principal Responsibilities:

Process Management & Documentation

• Work with Leadership to assess project scope and define project plans (schedule and cost estimates)

• Experience in the Software Implementation Lifecycle (SILC) including collection of requirements, documentation of specifications (controls and outputs, workflows, logical processes), and overseeing application design and implementation.


Application Design

• Analyze and translate business requirements into functional and technical requirements and design

• Research and evaluate capability with other systems, alternative solutions and recommend the most efficient and cost effective solution for system design

• Advises on mechanisms for delivering solutions that demonstrate effective business-IT alignment


Application Development

Lead knowledge capital development efforts through:

Extensive data warehouse and ETL development expertise using star schema design and real-time data loads

Designing innovative system solutions and software development techniques

Provide testing and production support as necessary


Technology Architecture

•        Evaluate new and existing tools and technologies

•        Maintain a detailed knowledge of the business’s current technology and infrastructure, marketplace changes, client processes

•        Determine tools and strategies to address business problems through modeling and understanding key business processes and impact of technology on business processes

•        Determine and roll out overall security and systems control policies and procedures

Job Requirements


•        Minimum 12 years’ experience in application development and system analysis.

•        Experience with Greenplum and Data Stage a must.

•        Demonstrated capabilities in the following disciplines:

o   Data Warehousing

o   IBM DataStage

o   CA AutoSys

o   Business Intelligence (Cognos)

o   Data Quality and Profiling

o   Data Architecture and Data Modeling

•        Experience with load strategy and data validation for large data warehouse

•        Good knowledge in loading real time data warehousing for intraday ETL processes

•        Preferred experience with enterprise scheduling tool like Autosys

•        Experience with loading massively parallel processing system like Greenplum, Teradata

•        Experience with AWS Cloud Services

•        Database performance tuning experience

•        Very strong UNIX skills and SQL experience

•        Strong understanding of Kimball Methodology

•        Good SQL writing capabilities with PG SQL

•        Profile Data Sources and provide analytics to Business Partners

•        Translates business rules into technical specifications

•        Perform Unit Testing and assist Enterprise Quality Assurance and User Acceptance testing teams

•        Demonstrated experience and expertise in the Software Implementation Lifecycle (SILC) including collection of requirements, documentation of specifications, application design, implementation and support.

•        Demonstrated advanced technical and analytical skills.

•        Experience reviewing documentation for the user (i.e. installation, use, and customization of products and services) as necessary.

•        Possesses deep, specialized knowledge of Domain/Area/Team applications and their development throughout all phases of the lifecycle

•        Possesses strong communication and interpersonal skills.

•        Degree in a technical discipline OR equivalent work history.

Digital Intelligence Systems, LLC. is an Equal Opportunity Employer, M/F/D/V. We do not discriminate against any employee or applicant because they inquired about, discussed, or disclosed compensation. Email recruitinghelp @ disys.com to contact us if you are an individual with a disability and require accommodation in the application process.