Specialty Development Consultant/Expert (Job Code: 1020)


Specialty Development Consultant/Expert (Job Code: 1020)

Employer: Fast Switch-Great Lakes
Specialty Development Consultant/Expert (Job Code: 1020)

Responsible for participating in requirement gathering meetings and providing the estimates for the design and development activities; design and review Data Stage code and unit testing of the same; create various parallel jobs and sequence jobs for automating the entire process of loading the data; use various stages like XML Hierarchical Stage, XML Input, External Source, Join, Transformer, Lookup, Aggregator, Funnel, Filter, Remove Duplicate, Sort, Address Verification Stage (AVI), and Web Services Stage to complete assigned tasks; design, develop and deploy Datastage jobs using various Quality stages including Investigate, Standardization, Match Frequency, Unduplicate, Reference Match and Survivor Stages; use Pattern Action Language to standardize Name, Address, Phone and Email data; work on troubleshooting, performance tuning and debugging to optimize the performance of the jobs; utilize IBM Infosphere DataStage and Quality Stage, Information Server Web Console, Teradata, MS-SQL Server 2005, Unix Shell Scripting, HP Quality Center, WinSCP, AutoSys, Teradata Studio, Advance Query Tool, TOAD and DB2 Control Center to perform duties; write custom SQL queries using joins and subqueries; tune SQL queries to improve the performance; support system and integration testing to ensure the correct functionality of the system and its interfaces with various test scenarios and review of Test Cases and Test Results; provide support for the implementation plan and creation of relevant supporting documents for the Production move; provide Production support and troubleshoot during the support period for the project; create scripts needed for handling incoming data and staging the data using Hive queries; and develop oozie workflows for sequential execution of jobs and scheduling of them.

Location: Livonia, Michigan and other multiple undetermined worksites throughout the U.S.;
Salary: $115,440 per year

Bachelors - Electronics Engineering, Electrical Engineering, Electrical and Computer Engineering, Computer Science, or related field of study (will accept equivalent foreign degree);
Training: None
Experience: Five (5) years in the position above, as a Programmer Analyst, as an IT Consultant, as a Module Leader, or in a related occupation;
Other Requirements: Experience must include two (2) years use of all the following: IBM Infosphere DataStage and Quality Stage, Information Server Web Console, Teradata, MS-SQL Server 2005, Unix Shell Scripting, HP Quality Center, WinSCP, AutoSys, Teradata Studio, Advance Query Tool, TOAD and DB2 Control Center.
Will also accept any suitable combination of education, training, and/or experience.
At Fast Switch – Great Lakes (FSGL), Our Purpose is Our People and Our Planet. We come to work each day and are reminded we are helping people find their success stories.  Isn’t that cool? Also, Doing the right thing is our mantra.  We act responsibly, give back to the communities we serve, and have a little fun along the way.
We at FSGL, have been doing this for 22 years with pride, dedication and plain old-fashioned hard work.
We're a financially strong, privately-held company that is 100% consultant and client focused.
We've differentiated ourselves by being fast, flexible, creative and honest. Throw out everything you've heard, seen, or felt about every other IT Consulting company. We do unique things, and we do them for Fortune 10 companies, Inc. 500 companies, and technology start-ups.
Our benefits are second to none and thanks to our flexible benefit options you can choose just the benefits that you need or want, options include:
  • Medical and Dental (Fast Switch pays majority of the medical program)
  • Vision
  • Personal Time Off (PTO) Program
  • Long Term Disability (100% paid)
  • Life Insurance (100% paid)
  • 401(k) with immediate vesting and 3% (of salary) dollar-for-dollar match
Plus, we have a lucrative employee referral program and an employee recognition culture.
One of our pride points as that in 2013, 2014, 2015, 2016, 2017, 2018 and 2019, Fast Switch was named one of the Top Work Places in Michigan by the Detroit Free Press.
To view all of our open positions, please go to: https://clientapps.jobadder.com/45103/fast-switch
Follow us on Twitter at: https://twitter.com/FastSwitchGL
Follow us on Instagram at: https://www.instagram.com/fastswitchgl/
Find us on LinkedIn at: https://www.linkedin.com/company/fast-switch-great-lakes
And you can become a fan of Fast Switch on Facebook at: https://tinyurl.com/v4p9yy7