The selected candidate is expected to work on the ETL layer (IBM Datastage) of the Cloud Native IDP platform that is designed based on Hexagonal Microservices architecture, including a proprietary solution leveraging the Spring State Machine framework, for workflow management, scheduling & monitoring with Oracle ExaCC as the database.
Responsibilities
Direct Responsibilities
- Work with business analysts/users to understand requirements.
- Ability to perform technical analysis, design and identify impacts (functional/technical).
- Develop, test and provide support during implementation.
- Bug fixing & performance optimization.
- Mentor and carry out code reviews of junior members on the team.
- L3 support in case of post-production issues/incidents
Contributing Responsibilities
- Mentor and carry out code reviews of junior members on the team.
- Deliver technical documentation & solutions in line with group standards.
- Work in a rapidly changing environment in achieving Team goals.
- Ability to work to tight deadlines.
Technical & Behavioral Competencies
Ability to perform technical analysis, design and identify impacts (functional/technical)
Proficiency in:
- Design, develop, and implement data integration solutions using IBM Infosphere DataStage Parallel Edition
- Create data jobs, design data flows, and optimize data processing performance
- Manage and monitor data integration processes using DataStage Designer, Director, and Administrator
- Ensure data quality, data validation, and data transformation techniques are applied to all data integration processes
- Collaborate with cross-functional teams to identify and prioritize data integration requirements
- Troubleshoot and resolve data integration issues and performance problems
- Hands on experience in designing Robust Data Pipelines in DataStage PX to deal with huge data volumes.
- Experience in connecting Oracle data sources, ability to develop customization around DataStage PX and Oracle.
- Realtime working experience in dealing with DataStage 8.0 x, 9.0 x, 11.0 x and greater version, Data Dictionary, Deployment, Designer client, Director client.
- Oracle SQL and PL/SQL in 12c or latest version
- Triggers, Views and Performance Tuning related to SQL Queries
- Unix Shell scripting
- Any Scheduler concept awareness
Nice to Have:
- Experience with other data integration tools and technologies
- Knowledge of data architecture and data modelling
- Experience with core Java and Frameworks is an added advantage.
- Experience with agile development methodologies
- Certification in IBM DataStage or related technologies
Specific Qualifications:
- Experience in the financial services industry will be a distinct advantage
- Inclination to understand and learn application/business functionality
- Good communicator, fast learner & a Team player
- Attention to detail, disciplined and reliable
- High motivation and confidence levels
- Can do attitude and attention to detail
Skills Referential (Required knowledge, skills and abilities)
Technical Skills:
-
DataStage 8.0 x, 9.0 x, 11.0 x and greater version, Data Dictionary, Deployment, Designer client, Director client.
o Oracle SQL and PL/SQL in 12c or latest version
o Triggers, Views and Performance Tuning related to SQL Queries
o Unix Shell scripting
o Any Scheduler concept awareness
Behavioral Skills:
- Creativity & Innovation / Problem solving
- Ability to deliver / Results driven
- Communication skills - oral & written
Education Level:
First class Graduate in any discipline (Computer Science preferred) from a reputed university with a good background of software development and IT experience of 7-9 years
Resource who is Enthusiastic, Energetic and with a lot of interest to learn and adapt to new technical framework
Location: Chennai