ETL Developer

Milford, Ohio

Diverse Lynx
Apply for this Job
IT experience in Design, Development, and implementation of large scale and medium scale Data Wareshousing 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 infrastrcuture Management and automation technologies.Working with basic structured, semi-structreu, and unstructed data.Exporusre to modern data/analytics archuiecture (Big Data, Cloud, etc.,).Exporusre to advance analytics tools(Python, R, etc). Scripting(shell, python, ruby) skills for montoiring and automation.Developing and maintaining pipelines for efficient data extraction, transformation and loading (ETL) processes.Advanced knwoledge 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, Terdata.Experience in writing PL/SQL stored porcedures, funcitons and packages.Proficient in writing Unix shell scripts and extensive experience working with unix operating systesm.Extensive experience with ETL to load data from Flat files, XML, Oracle and DB2 to ODBC databases and to perform various transactions using Filtern, Transformer, Join, Lookup, Aggregator, Change Capture, Remove Duplicate, Shared Container, Nested condition, ROutines, Command activity stages to create robus mappings in the DataStage Designer. IT experience in Design, Development, and implementation of large scale and medium scale Data Wareshousing 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 infrastrcuture Management and automation technologies.Working with basic structured, semi-structreu, and unstructed data.Exporusre to modern data/analytics archuiecture (Big Data, Cloud, etc.,).Exporusre to advance analytics tools(Python, R, etc). Scripting(shell, python, ruby) skills for montoiring and automation.Developing and maintaining pipelines for efficient data extraction, transformation and loading (ETL) processes.Advanced knwoledge 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, Terdata.Experience in writing PL/SQL stored porcedures, funcitons and packages.Proficient in writing Unix shell scripts and extensive experience working with unix operating systesm.Extensive experience with ETL to load data from Flat files, XML, Oracle and DB2 to ODBC databases and to perform various transactions using Filtern, Transformer, Join, Lookup, Aggregator, Change Capture, Remove Duplicate, Shared Container, Nested condition, ROutines, Command activity stages to create robus 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.

Date Posted: 07 April 2025
Apply for this Job