Contract Position--> Senior ETL Programmer Analyst – Enterprise Data Warehouse in Las Vegas, NV

Hello,

 

Hope you are doing great today!!!

 

This is Anurag Srivastava from IDC Technologies.

We have a job opportunity available for the position Senior ETL Programmer Analyst – Enterprise Data Warehouse in Las Vegas, NV. Please go through the job description below and let me know if you are available and interested for this position. Please reply me back with your most updated resume.

 

POSITION: Senior ETL Programmer Analyst – Enterprise Data Warehouse

LOCATION: Las Vegas, NV

Duration: 6+ Months

 

SUMMARY 
The Data Warehouse Programmer is a key member of the Enterprise Data Warehouse (EDW) team responsible for designing, testing, maintaining and supporting applications on EDW and validating source system data loads.  This position will have a focus on developing, maintaining, and supporting EDW ETL processes.  This position will also focus on implementing best practices and procedures to ensure improved performance of data loads, integrity of data movement within the organization, and enhanced data architecture to support Business Intelligence (BI) applications and analytics.  In addition, this position will work with various project teams to ensure optimal data flow through systems, designing flexible and supportable data models, and contributing to the overall data architecture of EDW.  This role works directly with other IT application groups and end-users to analyze, troubleshoot, test and enhance applications.

 

ESSENTIAL JOB FUNCTIONS

The primary responsibility of this position is to provide expertise in the areas of system design and development, standardization, and support to solve complex business problems, primarily in the Enterprise Data Warehouse environment which is on a Teradata platform.  The programmer will support multiple interfaces from diverse in-house developed to vendor-supplied applications.  The position will focus on the day to day aspects of supporting our Teradata data warehouse and ETL jobs.

 

Responsibilities include, but may not be limited to the following:

·           Take part in an on-call rotation, providing 24-7 support for the Data Warehouse and applications which run in the environment.

·           Code, test, deploy, and maintain ETL processes using Teradata Utilities, IBM DataStage, Data Mover, and Control-M.

·          
Demonstrate growth in technical leadership skills by influencing product interface direction, managing standards, supporting other developers with technical questions, and approving system modifications.

·           Formulate systems scope and objectives by devising procedures to solve technical problems using information systems.

·           Perform complex system technical design work. Provide strategic technical direction.

·           Prepare detailed specifications from which programmers write, design, code, test and debug the most complex programs.

·           Guide the efforts of co-workers and contract personnel in accomplishing assigned tasks.

·           Demonstrate problem-solving skills by defining and presenting technical systems solutions for identified technical issues.

·           Provide suggestions for improving the overall BI architecture.  Work with the business users to ensure that the BI solution is improving analytical capabilities.  

·           Assist with tasks such as application upgrades, proof of concepts, and software selection.

·           Document activities from design to completion to assist future analysts in understanding work solutions.  Create data models, data/system flow documentation, design documents, and test documents.

·           Perform technical reviews with Project Leaders to maintain consistent technical direction and minimize system impact on projects.

·           Take complex technical ideas and bring them to a high-level to encourage understanding at all levels.

·           Deliver a complete solution to ensure thorough understanding of the system (documentation, procedures, training, escalation, error process, etc.).

·           Proactively escalates to the next level of management and provides recommendation from available options.

·           Engage others with related code/products/etc to work together to understand root cause, ripple effects, and an integrated solution.

·           Provide input into capacity plans; able to assist with load tests.

·           Write efficient, reusable and stable code for complex application logic.

·           Perform complex code reviews.

·           Set high standards of performance for others. Hold others to the standards and help them achieve these standards, if necessary.

·           Clearly define expected outcome for the initiative and organization.

 

 

KNOWLEDGE AND EXPERIENCE

 

6 - 8 years programming experience preferred, with an additional two years of project leadership, systems design/analysis and user management.  Must be competent in all aspects of programming and design with minimal direction.

 

Required

• 6+ years work experience in job as database programmer OR 3+ years work experience in job as database programmer plus Master's Degree in Information Systems or Computer Science
• 3+ years work experience with ETL tools such as IBM DataStage is required
• 2+ years work experience with architecting data warehouse solutions
• Experience with Unix Operating System is required
• Expert level expertise with Structured Query Language (SQL) is required
• Technical experience with Teradata (including Teradata-specific training) and Teradata Utilities is strongly preferred
• Experience with KornShell Scripting preferred
• Experience with scheduling tools such as Control-M is preferred
• Experience with Hadoop is preferred
• Experience with Active Data Warehousing, trickle feeds and the TIBCO toolset is preferred
• General knowledge of the BI and Data Warehousing disciplines including Physical and Logical Database Modeling, as well as OLAP, ROLAP and MOLAP concepts is required
• Experience with MicroStrategy, Cognos, Tableau, or other Business Intelligence tools is preferred

 

Rarely requires guidance, even on most complex systems analysis.

 

EDUCATION

Bachelor's degree in Information Systems, Computer Science or technical training equivalent

 

 

Thanks & Regards

Anurag Srivastava | IDC Technologies Inc

Number:- 408-668-8346

Hangout & YIM :- anuragsrivastava199

LinkedIn: https://www.linkedin.com/in/anurag-srivastava-55491056

 

Note: "We respect your Online Privacy. This is not an unsolicited mail. Under Bill s. 1618 Title III passed by the 105th U.S. Congress this mail can not be considered spam as long as we include a way to be removed from our mailing list. Simply send us an e-mail with REMOVE in the subject and we will gladly REMOVE you from our mailing list."

--
You received this message because you are subscribed to the Google Groups "US Jobs: Requirements, Clients and Consultants" group.
To unsubscribe from this group and stop receiving emails from it, send an email to recruiters-r-us+unsubscribe@googlegroups.com.
To post to this group, send email to recruiters-r-us@googlegroups.com.
Visit this group at https://groups.google.com/group/recruiters-r-us.
For more options, visit https://groups.google.com/d/optout.