Consultant, Software Engineer (ETL)

St. Louis, MO

Post Date: 09/07/2017 Job ID: 135789 Job Category: Database

Are you looking for a new and challenging opportunity? Do you have experience with programming in SQL and PL/SQL? Technology Partners can help you make your next big career move a reality.

Our client is currently seeking a talented person for a Consultant, Software Engineer (ETL) position.

What You Will Be Doing:

You will be responsible for the development, maintenance and support of data extraction (ETL) processes from source systems to targets. You will work with ETL tools, such as Syncsort. You will also identify data sources, assists in the design of dimensional data models and designs/develops processes that ensure data accuracy. You will develop code to summarize data and calculate metrics for dashboards and Business Intelligence applications. You will have fluency with best practices for ETL design and development such as data profiling, data cleansing, change data capture, and performance optimization. You will have the ability to evaluate and implement solutions balancing reuse, extensibility, reliability and performance. You will develop, test, migrate, document, and maintain databases, applications, stored procedures, and associated reports. You will translate business needs into analytics/reporting requirements, and interface with stakeholders to ensure successful delivery of client reporting solutions. You will improve and streamline processes regarding data flow and data quality to improve data accuracy, viability and value. You will also provide technical support for database creation, modification, testing, administration, monitoring, tuning, backup, and recovery.

What We Are Looking For:

  • 10+ years hands on experience in programming in SQL and PL/SQL, using SQL developer, TOAD or similar program development applications.

  • Full Stack Experience in Oracle Exadata.

  • Proficiency in database design concepts and techniques for OLTP.

  • Advanced database development knowledge including performance tuning in Oracle and/or Big Data environments.

  • Strong extraction, transformation and loading (ETL) skills using Syncsort and PL/SQL.

  • Strong analytical and problem solving skills with ability to clearly articulate solution alternatives.

  • Experience in database reorganization procedures, scripted database alerts, and monitored scripts.

  • Experience in database server tuning, application tuning, maintaining documentation, capacity planning and database security.

  • Reorganized databases and sized database objects to meet standards and improve performance 30%.

  • In-depth knowledge of data warehouse principles and related technologies

  • Experience in building tabular models using MSBI and SQL Server.

  • Experience with a variety of programming languages including but not limited to PL/SQL

  • Writing PL/SQL programs for accomplishing more complex queries or data modifications Non-technical skills.

  • Knowledge of data mapping and transformation processes.

  • Experience with performing data modeling and applying the modeling to IT solutions

  • Bachelor's Degree in Computer Science or equivalent

  • Professional development experience in data warehouse or data analytics.

If this position sounds like you, WE SHOULD TALK!

Your better future is ready, and we want to put the right tools in your hands to get you there. Let's go!

Looking for more opportunities with Technology Partners?

Check out

Scott Lawler

Not ready to apply?

Send an email reminder to:

Share This Job:

Related Jobs:

I am convinced Technology Partners and their team were able to save Enterprise millions of dollars on hardware upgrades.

Rick Butler, Senior Manager, Database Management of Enterprise Rent-a-Car

Find out how our database performance solutions can make a difference for you today.

Learn More