Business Analyst

Job Title : Ab Initio Developer

Location : Pune

Experience : 5+ Years

Notice Period : Immediate Joiners Only

Job Summary :

We are looking for an experienced Ab Initio Developer to join our team in Pune.

The ideal candidate should have strong hands-on experience in Ab Initio development, data integration, and Unix scripting, with a solid understanding of SDLC and data warehousing concepts.

Mandatory Skills :

Ab Initio (GDE, EME, graphs, parameters), SQL/Teradata, Data Warehousing, Unix Shell Scripting, Data Integration, DB Load/Unload Utilities.

Key Responsibilities :

• Design and develop Ab Initio graphs/plans/sandboxes/projects using GDE and EME.
• Manage and configure standard environment parameters and multifile systems.
• Perform complex data integration from multiple source and target systems with business rule transformations.
• Utilize DB Load/Unload Utilities effectively for optimized performance.
• Implement generic graphs, ensure proper use of parallelism, and maintain project parameters.
• Work in a data warehouse environment involving SDLC, ETL processes, and data analysis.
• Write and maintain Unix Shell Scripts and use utilities like sed, awk, etc.
• Optimize and troubleshoot performance issues in Ab Initio jobs.

Mandatory Skills :

• Strong expertise in Ab Initio (GDE, EME, graphs, parallelism, DB utilities, multifile systems).
• Experience with SQL and databases like SQL Server or Teradata.
• Proficiency in Unix Shell Scripting and Unix utilities.
• Data integration and ETL from varied source/target systems.

Good to Have :

• Experience in Ab Initio and AWS integration.
• Knowledge of Message Queues and Continuous Graphs.
• Exposure to Metadata Hub.
• Familiarity with Big Data tools such as Hive, Impala.
• Understanding of job scheduling tools.

• Install, configure, and maintain Kubernetes clusters.
• Develop Kubernetes-based solutions.
• Improve Kubernetes infrastructure.
• Work with other engineers to troubleshoot Kubernetes issues.

• Kubernetes administration experience, including installation, configuration, and troubleshooting
• Kubernetes development experience
• Linux/Unix experience
• Strong analytical and problem-solving skills
• Excellent communication and interpersonal skills
• Ability to work independently and as part of a team

• Strong knowledge of MERN stack (MongoDB, Express JS, React JS, Node JS, HTML5, CSS3, jQuery, Bootstrap, SASS)
• You will also need to interact with mysql databases.
• Develop user interfaces for modern rich internet applications with the latest front-end technologies
• Should have knowledge of of consuming and creating APIs
• Developing features to enhance the user experience.
• Should have excellent in-depth knowledge of Nodejs and MongoDB
• Hands-on experience working with Object-Oriented JavaScript (OOJS), JavaScript libraries, and their practical uses in building complex interactive experiences
• Building reusable code for future use

Job Role : Associate Manager (Database Development)

Key Responsibilities:

• Optimizing performances of many stored procedures, SQL queries to deliver big amounts of data under a few seconds.
• Designing and developing numerous complex queries, views, functions, and stored procedures
• to work seamlessly with the Application/Development team’s data needs.
• Responsible for providing solutions to all data related needs to support existing and new
• applications.
• Creating scalable structures to cater to large user bases and manage high workloads
• Responsible in every step from the beginning stages of the projects from requirement gathering to implementation and maintenance.
• Developing custom stored procedures and packages to support new enhancement needs.
• Working with multiple teams to design, develop and deliver early warning systems.
• Reviewing query performance and optimizing code
• Writing queries used for front-end applications
• Designing and coding database tables to store the application data
• Data modelling to visualize database structure
• Working with application developers to create optimized queries
• Maintaining database performance by troubleshooting problems.
• Accomplishing platform upgrades and improvements by supervising system programming.
• Securing database by developing policies, procedures, and controls.
• Designing and managing deep statistical systems.

Desired Skills and Experience  :

• 7+ years of experience in database development
• Minimum 4+ years of experience in PostgreSQL is a must
• Experience and in-depth knowledge in PL/SQL
• Ability to come up with multiple possible ways of solving a problem and deciding on the most optimal approach for implementation that suits the work case the most
• Have knowledge of Database Administration and have the ability and experience of using the CLI tools for administration
• Experience in Big Data technologies is an added advantage
• Secondary platforms: MS SQL 2005/2008, Oracle, MySQL
• Ability to take ownership of tasks and flexibility to work individually or in team
• Ability to communicate with teams and clients across time zones and global regions
• Good communication and self-motivated
• Should have the ability to work under pressure
• Knowledge of NoSQL and Cloud Architecture will be an advantage

• Synthesize business requirements and translate them to appropriate technology solutions.
• Product development for C# and SQL based solutions.
• Modify existing software to correct errors, allow it to adapt to new hardware, or to improve its performance.
• Analyze user needs and software requirements to determine feasibility of design within time and cost constraints.
• Coordinate software system installation and monitor equipment functioning to ensure specifications are met.
• Design, develop and modify software systems, using scientific analysis and mathematical models to predict and measure outcome and consequences of design.
• Think strategically and balance short-term needs with longer-term business priorities
• Challenge status quo and champion new ideas throughout cross functional organizations; ability to inspire confidence and trust with peers and cross functional business teams

Required Qualifications:

• Bachelor's Degree in Computer Science, Computer Engineering, Chemical Engineering or related field
• 4+ years overall and as a C# programmer and 1.5+ years in WPF.
• Should have hands on experience on desktop application development using UWP or WPF
• Should have worked on WPF in recent projects.
• Well versed in C#, SQL, HTML5, Java Script, ASP.NET, WPF, and MVC
• Excellent communication skills
• Team oriented

Preferred Qualifications

• Familiar with project management methodology, Agile/Scrum and TFS or JIRA
• Proven experience working directly with end customers or internal business units
• Prior experience working with global development teams
• Experience in IoT environments
• Experience in working in Azure