Previous Job
Sr. DataStage Developer
Ref No.: 18-06497
Location: Hartford, Connecticut
Senior DataStage Developer
Our client's team is growing and in need of adding additional team members. He or she will work to apply Data Stage based ETL solutions in support of identified business problems and provide direction and technical expertise for improvements. This position will be responsible for DataStage tool administration and also interfacing with business owners, triaging issues, and assisting in setting future direction for DataStage in line with the strategic roadmap for ETL. Responsibilities include, but are not limited to:

  • Technical ETL SME, liaises with the Business Technology teams – Dev Ops, DBAs, Architecture, BT Operations and Data Governance towards maintaining robust, secure and auditable ETL Development process in line with the overall software development lifecycle (SDLC).
  • Acts as a self-starter on projects and facilitate technical sessions to gather relevant input required to proceed with the next steps towards finalization and completion of design and development work.
  • Must be proactive and communicates project risks or issues encountered during the Analysis, Design, and Development phases and bring them to the Project Core team/ Technical Leader's attention.
  • Challenges status quo and mentors DataStage development staff in terms of efficient Design as well as reusable Development best practices for assigned projects and minimizing unfavorable work variances
  • Provides DataStage tool administration functions over user maintenance, tool version control as well as compatibility management by working with various technology vendors – IBM, Salesforce, Teradata etc
  • Collaborates in Project Requirements (Business, Functional) sessions, translate them into technical requirements using High Level Solution (HLS) and forecasts development effort (Level of Effort) using standard template.
  • Guides staff in writing, testing and implementing ETL jobs using the latest and the greatest features offered by the DataStage tool without compromising the job performance.
  • Ensures that work requests and reported problems are handled in a client focused, professional, organized and timely manner. Provides management with periodic formal and informal reports on the status of projects and technical problems.
  • Provides Root Cause Analysis (RCA) for assigned technical issues, participates in company's Reliability process and provide solid updates related to assigned issues.
  • Leads and delivers solutions for complex enhancements of code and business projects independently. Identifies, owns and implements operational and technical improvements
  • Handles production support activities related to tickets analysis and process monitoring as appropriate.
  • Participates in special projects and performs other duties as assigned. Shows willingness to go above and beyond to achieve success in assigned tasks.
  • Abides by general Policy Procedures and Business Technology specific policy procedures and lives up to company core values.

Required Education/Experience:
  • Bachelor's Degree in Information Science, Business, MIS, Computer Science or equivalent.
  • 8+ years of ETL tool experience and at least the last 3 years using IBM Information Server DataStage 11.x (stable version); specifically –hands on experience in designing, developing, testing and maintaining jobs using Designer, Manager, Director, Administrator and Debugger
  • 3+ years of experience in development code in PL/SQL and Linux/Windows batch scripting.
  • 5+ years of experience in software development lifecycle methodology preferably in a large company.
  • 2+ years of experience in healthcare industry or relative field is preferred.
  • Excellent analytical, interpersonal, and communication skills.
  • Experience in integration of various data sources (proprietary flat files, xls, xlsx, and XML) with Multiple Relational Databases RDBM systems Oracle, Salesforce, Teradata, SQL Server, MS Access, and DB2 using Data Stage.
  • Solid experience in working in a fast paced environment.
  • Good working knowledge on Service Oriented/ Client-Server Architecture and expertise in WebServices integration using DataStage.
  • Experience in performance tuning using various techniques is a plus.
  • Having knowledge in Triggers, Procedures, functions at Database level using PL/SQL as well as Linux /Unix Shell scripting/windows batch scripting is a plus.