Sr. ETL Developer

Right Talent Right Now; Overland Park (KS); On-site; USD 100,000 - 120,000; Full time

Job summary

A leading recruitment agency is seeking a Senior ETL Developer to participate in the development and enhancement of business applications in Overland Park, Kansas. You will engage with project teams, provide technical leadership, and resolve production issues while working with technologies like IBM InfoSphere DataStage and SQL. Ideal candidates must have 6-8 years of extensive experience in ETL Data Warehousing and strong technical knowledge. The role requires effective communication with business partners and a proactive approach to solving complex problems.

Qualifications

• 6-8 Years of Experience in utilizing IBM InfoSphere DataStage/Quality Stage/ISD 8.7 or above.
• 6-8 Years of Demonstrated knowledge and application of ETL Data Warehousing best practices.
• 3-5 Years of Experience in SQL Server, SSIS, SSRS, and SSAS.

Responsibilities

• Provide business analysis and programming expertise within an assigned business area.
• Develop and modify procedures to solve business problems.
• Prepare detailed specifications for program development.

Skills

IBM InfoSphere DataStage

ETL Data Warehousing best practices

SQL

Oracle database

SQL Server

Informatica

Hadoop stack

Tableau BI

Collaboration with DBAs

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. The role involves working with project teams assigned to a business unit or department, utilizing various technology platforms, and collaborating with business partners and technical staff to understand functional requirements, 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.
• 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 and 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.

Qualifications

• 6-8 Years of Experience in utilizing IBM InfoSphere 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 (plus).
• 3-5 Years of Data Warehouse Architectural experience.
• 1-2 Years of Experience in Hadoop stack (PIG, Hive, Spark).
• 1-2 Years of exposure to Tableau BI, Logi, or other dashboard reporting experience (plus).
• Strong experience collaborating with DBAs, data modelers, and business analysts.

Additional Information

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