Sr. ETL Developer

Right Talent Right Now; Kansas City (MO); On-site; USD 80,000 - 110,000; Full time

Job summary

A recruiting company is seeking a Senior ETL Developer to enhance business applications in Kansas City. The ideal candidate should have 6-8 years of experience in ETL Data Warehousing, be proficient in IBM DataStage and SQL, and possess strong analytical skills. Responsibilities include collaborating with teams to define project scope, preparing specifications, and providing technical leadership. This role requires ownership of production issues and the ability to communicate effectively with business partners.

Qualifications

• 6-8 Years of experience in utilizing IBM Info Sphere DataStage/Quality Stage.
• Strong experience with SQL against relational databases.
• Leadership with hands-on experience managing systems development.

Responsibilities

• Provide business analysis and programming expertise.
• Formulate and define application scope and objectives.
• Prepare detailed specifications and document programs.

Skills

IBM Info Sphere DataStage/Quality Stage

ETL Data Warehousing best practices

SQL

SQL Server

Hadoop stack (PIG, Hive, Spark)

Tableau BI

Tools

Oracle database (10g and above)

Informatica

SSIS

SSRS

SSAS

Job description

Job Posting Title: DWH/ ETL Developer Level III (Senior) - RECRUITED - US

Description: The Senior ETL Developer is responsible for participating in development, maintenance and enhancement of business applications. Participate in project teams assigned business unit or department and utilize various technology platforms. Collaborate with business partners and other technical staff to understand functional requirements and create system requirements, assess available technologies and recommend solution options.

Responsibilities

• Provide business analysis and programming expertise within an assigned business unit/area in the analysis, design, and development of business applications
• Formulate and define application scope and objectives; devise and modify procedures to solve Business problems.
• Prepare detailed specifications from which programs will be written, and design, code, test Debug and document programs.
• Participate in business and IT project estimation activities.
• Provide technical leadership for small to medium-scale projects.
• Utilize business knowledge to collaborate and offer technical solutions.
• Be self-guided and complete tasks with minimum assistance.

Qualifications

• 6-8 Years of Experience in utilizing IBM Info Sphere DataStage/Quality Stage/ISD 8.7 or above
• 6-8 Years of Demonstrated knowledge and application of ETL Data Warehousing best practices
• 6-8 Years of Experience with SQL against relational databases preferably with Oracle database platforms 10g and above on Linux/Unix.
• 3-5 years of Experience in SQL Server, SSIS, SSRS and SSAS
• 1-2 years of Informatica experience is a plus
• 3-5 Years of Data Warehouse Architectural experience
• 1-2 Years of Experience in Hadoop stack (PIG, Hive, Spark)
• 1-2 year’s exposure to Tableau BI or Logi or other dash boarding reporting experience is a plus
• Strong of Experience in collaboration with DBA’s, data modelers, and business analysts
• Under minimal supervision, effectively analyze and resolve medium to moderately large risk production problems related to assigned applications, assess alternatives and implement long-term solutions.
• Successful performance includes demonstrated ownership and timely responses to production problems and business unit inquiries.
• Under minimal supervision, effectively analyze and resolve medium to moderately large risk production problems related to assigned applications, assess alternatives and implement long-term solutions.
• Successful performance includes demonstrated ownership and timely responses to production problems and business unit inquiries.
• Ability to communicate effectively with business partners
• Ability to provide fundamental technical and business analysis on projects
• Strong technical knowledge, Leadership, with hands-on experience managing systems development in new computing architectures and environments.
• Knowledge of relevant technology and tools is critical, including development methodologies and programming/scripting languages.
• Ability to accurately estimate project development activities.
• Experience with design, development, and implementation of new computing architectures.

Additional Information

All your information will be kept confidential according to EEO guidelines.