Blog

Greetings,

Here is our open requirement which can be filled immediately. Kindly respond to this requirement with your resume, contact and current location info to speed up the interview process. 

Position: ETL DataStage Developer

Location: Milwaukee, WI~ Milford, OH (Onsite)

Duration: 12 months

Client: TCS

Job Description

• 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.

Education: At least a bachelor’s degree (or equivalent experience) in Computer Science, Software/Electronics Engineering, Information Systems, or closely related field is required.

Thanks & Regards,

Pavan Yantrapati,

PH: +1 904-242-1993 Ext 352

Email: [email protected]

ITech IT Solutions Private Limited