ETL Developer in Cincinnati, OH at APEX Systems

Date Posted: 5/23/2018

Job Snapshot

Job Description

Job #:  851823

Long term-contract

ETL Developer

  • Experience with designing, developing, testing and mapping server and parallel jobs using IBM InfoSphere Information Server Datastage 11.5, all at a medium to high level of complexity.
  • 5+ years of experience in IBM InfoSphere Information Server Datastage 9.X+
  • 3+ years of experience with shell scripting in any flavor of UNIX
  • Proficiency in developing strategies for Extraction, Transformation and Loading (ETL) mechanism
  • Expertise in designing parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator, XML, MQ, Hierarchical
  • Experience in schema designing for data marts, data transformation and data integration
  • Expertise in designing complex SQL queries in ANSI format joining more than 10 tables with aggregations, partitions, order by, etc
  • Ability to analyze customer requirements and transform them into technical design specifications
  • Experience in production support with quick turn-around time for hot fixes
  • Experience in any of the following will make you a stronger candidate:
    • Oracle PL/SQL development
    • SQL Server development
    • Unix scripting knowledge
    • Enterprise scheduling knowledge 
  • Experience developing projects that have high level of complexity, being responsible for structuring the work, prioritizing and assigning project tasks, providing guidance and resolving issues.
  • Experience creating and reviewing detailed technical specifications of high complexity and performing the review of technical design for tasks of high level of complexity. Providing technical approval of technical design for tasks of medium to high level of complexity
  • Experience consulting on the estimates, design preparation and operational support escalations for large tasks of high complexity Strong understanding of IT regulations including SOX, PCI and privacy laws, security methodologies, controls and access.
  • Experience solving highly technical complex problems and be called on to consult for other projects.
  • Act in Development Lead capacity for medium to high initiatives, prioritizing and assigning project tasks, providing guidance and resolving issues. Reports status to management and interfaces with other domains, IT areas and 3rd party vendors as needed.
  • Experience leading the definition of processes, development of best practices and standards, and actively participates in new technology, vendor package and tool road mapping, evaluation and introduction.
  • Ensures compliance with performance, security, availability, recoverability and supportability standards and polices and provides monitoring recommendations for tasks of medium to high level of complexity.
  • Strong organizational, presentation, and business partnering skills
  • Ability to multi-task and alter direction easily to accommodate changing priorities
  • 6+ years’ experience in a similar role
  • Bachelor’s degree in a related field or equivalent experience desired

 

Please send word doc. resumes to pcollins@apexsystems.com

 

 

 

 

 

EEO Employer

Apex is an Equal Employment Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at employeeservices@apexsystemsinc.com or 844-463-6178.

 

 

 

 

 

 

 

 

EEO Employer

Apex is an Equal Employment Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at employeeservices@apexsystemsinc.com or 844-463-6178.