Talent.com
DataStage Developer

DataStage Developer

Diverse LynxOregon, OH, United States
2 days ago
Job type
  • Full-time
Job description
  • IT experience in Design, Development, and implementation of large scale and medium scale Data Warehousing applications using ETL tool IBM Infosphere Information server DataStage, SQL and Unix.5-7 years with a broad portfolio of AWS Infrastructure tools (EBS, S3, EC2, Elastic IP, Route 53, VPC) and with cloud infrastructure Management and automation technologies.
  • Working with basic structured, semi-structure, and unstructured data.
  • Exposure to modern data / analytics architecture (Big Data, Cloud, etc.,).
  • Exposure to advance analytics tools(Python, R, etc.). Scripting(shell, python, ruby) skills for monitoring and automation.
  • Developing and maintaining pipelines for efficient data extraction, transformation and loading (ETL) processes.
  • Advanced knowledge and expertise in designing and developing ETL jobs using IBM Infosphere DataStage and sounder experience in other IIS Suite like Information Analyzer and basics on Quality Stage.
  • Performance Tuning and Optimization of ETL Jobs and SQLA queries in ad-hoc and complex report environments.
  • Worked in various databases like Oracle 10g / 9i / 8i, DB2, SQL Server, Teradata.
  • Experience in writing PL / SQL stored procedures, functions and packages.
  • Proficient in writing Unix shell scripts and extensive experience working with Unix operating systems.
  • Extensive experience with ETL to load data from Flat files, XML, Oracle and DB2 to ODBC databases and to perform various transactions using Filter, Transformer, Join, Lookup, Aggregator, Change Capture, Remove Duplicate, Shared Container, Nested condition, Routines, Command activity stages to create robust mappings in the DataStage Designer.

    • Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.