Job Description :
Position: Data Warehouse Lead Developer – Greenplum and DataStage
Location: Coppell TX 75019
Duration: 6 Months contract

Role is a highly technical position – considered a technical expert in system implementation - with an emphasis on providing design and warehouse modeling expertise.

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

Experience:
Minimum 12 years’ experience in application development and system analysis.
Experience with Greenplum and Data Stage a must.
Demonstrated capabilities in the following disciplines:
Data Warehousing
IBM DataStage
CA AutoSys
Business Intelligence (Cognos)
Data Quality and Profiling
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.


Client : Direct Client

             

Similar Jobs you may be interested in ..