Shire Jobs

Mobile Shire Logo

Job Information

TEKsystems Informatica Developer (Datastage Experience) in New York, New York

100% remote

Ideal candidates will have Informatica experience but converted/migrated Datastage jobs to Informatica

Working within a Snowflake data warehouse is a huge plus

Datastage experience is important

Top Skills:

  • Strong Hands on Informatica Development experience

  • Must be very technical within Informatica

  • It would be nice if candidates had datastage (They just switched from Datastage to Informatica for ETL tools)

  • Healthcare experience would be a plus but not a necessity


The client recently migrated from Datastage to Informatica so they need a strong Informatica Developer that can come on board and help with the development. Candidates with Datastage experience are a plus since they have a lot of their jobs still in Datastage that need to be converted to Informatica.

Principal Duties and Responsibilities

To design and implement complex ETL processes for the Data management and Quality program. The Sr. ETL Developer is primarily responsible for the design, implementation and maintenance of ETL development to support the needs of data warehousing. The position is responsible for automation, job scheduling and streamlining all data exchange needs of the organization.

• Data Extraction Programming

• Source to Destination Mapping

• Data Preparation

• Essential duties include designing and streamlining various inter and intra organization ETL processes.

• Develop and implement schedule / dependency logic for automated ETL processing. This includes inbound and outbound data share from data warehouse.

• Accountable for implementing architectural, developmental and operational standards and practices including creation of ETL metadata.

• Identify and enforce data standards and best practices to ensure consistent and maintainable structures in the database.

• Design and develop enterprise and departmental analytical engine and data warehousing solutions.

• Develop and maintain source‐to‐target mapping specifications for ETL development.

• Strong relational database and SQL skills required, with MS SQL/Server and Oracle preferred. An understanding of DB2 is a plus.

• Work with other team members to continually improve our quality of service delivery.

• Actively participate on project team meetings to achieve team goals and departmental goals.

• Compliance with business policies and industry standard best practices with regard to data exchange and information security.

• Managing risk associated with handling sensitive data.

• Off‐hours and on‐call production support may be required.

• Adherence to internal and external production SLAs.

• Limited travel may be required.

Qualifications / Required Skills

• Bachelor’s degree with 7+ years of work experience in design and implementation of ETL framework for complex data warehouse initiatives.

• 7+ years of strong knowledge of Informatica and Informatica solutions

• Experience with full lifecycle enterprise data warehouse build.

• Minimum 4 years of experience working with healthcare data and secure inbound and outbound data exchange.

• Minimum 4 years of strong experience to design scalable data models and data flows.

• Experience with Informatica

• Experience with UNIX shell scripts for automation of jobs is a plus

• Experience with process documentation and efficiency improvement

• Willingness to participate in team on‐call rotation, and perform off hours work as needed.

• Strong technical and project management/process leadership skills

• Knowledge of healthcare industry systems and applications is a plus.

• Ability to work within a diverse, technically oriented, team setting is a must.

• Demonstrated ability to take ownership of incidents, coordinate effective response, and drive improvements through root cause analysis and lessons learned.

• The ability to quickly absorb new changes in computer technologies is necessary.

• 5+ years of experience with DataStage V.11.7 required.

About TEKsystems:

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

We are an equal opportunity employers and will consider all applications without regard to race, genetic information, sex, age, color, religion, national origin, veteran status, disability or any other characteristic protected by law. To view the EEO is the law poster click here. Applicants with disabilities that require an accommodation or assistance a position, please call 888-472-3411 or email This is a dedicated line designed exclusively to assist job seekers whose disability prevents them from being able to apply online. Messages left for other purposes will not receive a response.