Job Description:
Position Title :ETL Designer/Lead – DataStage
Location :Bangalore, KA-India
Responsibilities:
Working closely with business & IT stakeholders and understand ETL requirements and build end to end ETL migration processes using IBM Information Server stack and DataStage
Performing ETL in Master Data Management context into IBM Infosphere AE (11.7)
Designing and building scalable DataStage solutions
Writing complex SQL queries, Unix shell commands
Testing and troubleshooting problems in ETL system designs and processes
Analyzing and improving existing ETL approaches and solutions
Providing Architectural Guidelines
Experience and expertise other ETL tools, preferably Snaplogic
Expected to be part of the ideation, design, and deployment of DataStage solutions
Required Skillsets:
Minimum 3 to 5 years of relevant experience, should be able understand and develop complete ETL migration process
Strong business analysis and requirement definition background in the areas of data integration (ETL)
Excellent hands-on knowledge in DataStage (preferably 11.3) designing / developing complex ETL jobs
Hands on experience using DataStage in UNIX environment
Strong ETL and database (Oracle) concepts
Experienced with implementation methodologies and best practices (e.g. Waterfall, Agile
Proven ability to work creatively and analytically in a problem-solving environment.
Experience in establishing criteria for data use/test cases
Experience defining and implementing error and exception handling strategies
Ability to balance multiple projects and work both independently and as part of a team
Strong verbal and written communication skills, presentation, analytical, organizational and interpersonal skills
Strong troubleshooting, problem solving and conceptualization skills
Strong leadership, customer focus and influential skills
Ability to work independently as well as being a collaborative team member
Able to manage own duties including setting priorities
The ability to work within a multidisciplinary team
Experience in Cloud Migration Projects & Reverse Engineering
Good Understanding of Cloud Concepts
Having good knowledge of Caterpillar policies, standards and procedures, with broad understanding of Caterpillar’s organization is a plus
Work Timings – 1:00PM to 10:00PM IST (Approx.)
Caterpillar is an Equal Opportunity Employer (EEO).
Not ready to apply? Submit your information to our Talent Network here .
401 & 402, 4th Floor, IT Tower 3, InfoCity, Gandhinagar 382007, Gujarat GJ, India Join a team of two system...
Apply For This JobMadurai RSS Feed needed a experienced candidate Experience 2 – 5 Years Salary Not Disclosed Industry IT Software – Application...
Apply For This JobFrom 10 to 12 year(s) of experience ₹ 22,50,000 – 25,00,000 P.A. Mumbai or Job Description Roles and Responsibilities Please...
Apply For This JobJob role – Selling of IT products like Oracle, Adobe,Sonicwall, Microsoft,Mercure,QNap etc. Requirements – 1. Experience in IT sales 2.good...
Apply For This JobPublish Date: Nov 2, 2022 Location:Pune, MH, IN, 411062 Company:Atos Release Manager for IT Infrastructure Industry experience of 8+ years...
Apply For This JobCompany Description Our Mission At Palo Alto Networks® everything starts and ends with our mission: Being the cybersecurity partner of...
Apply For This Job