Ab Initio Professional

We are looking for experienced Ab Initio ETL developers with 6-8 years of hands-on experience to analyze, design, build and test complex ETL applications. Candidate should have strong leadership abilities with experience in leading development teams, communicating with cross-functional groups including Product and Business Development.. This role requires strong data integration development skills, experience in a team-based software development lifecycle, and familiarity working with remote clients. This role develops code for high complex modules, creates high complex application designs, reviews team s designs and guides them appropriately. Participates in design reviews, conducts code reviews, creates test plans and participates in testing reviews, and resolves complex defects. Experience on Apache Spark or willingness to learn will be an added advantage. Job Responsibilities The Lead Consultant Application Developer will participate in designing, building and maintaining solutions, design and code reviews, working closely with peers, coordinating across US, near shore, offshore resource teams and product owners to ensure delivery as well as performance, availability, and stability of the solution. The Lead Consultant Application Developer develops code for intermediate modules, participates in design reviews, conducts code reviews, creates test plans and participates in testing reviews, and resolves moderate defects. The Lead Consultant Application Developer designs, documents, reviews, and maintains components of software solutions for intermediate projects. It also includes reacting to production problems or supporting production changes where those applications are operating. Be able to evaluate technical designs and data mapping documents, in partnership with onshore designers and developers, based on user requirements Utilize designs to develop accurate, defect-free code Create and update technical documentations using high level technical specification documents Create unit test plans and conduct unit testing accordingly Participate in code reviews, and test plan reviews Work with QC Analyst to ensure appropriate conditions are identified, provide technical expertise on execution of applications, and support QC processes Provides input in creating detailed ETL development estimates or change requests Be able to coordinate and work with outside vendors for application development Perform performance tuning on both UNIX ETL and Oracle database environments Participate in Production Support transition meetings Other responsibilities include enhancement, performance tuning and support of existing applications Job Qualifications: 6-8 years of hands on experience in Ab Initio tools such as Graphical Development Environment (GDE), Enterprise Metadata Environment including air commands (EME) and data profiling 6-8 years of UNIX scripting, job scheduling tool, Oracle SQL and PL/SQL experience with full development lifecycle from inception through implementation Experience in Hadoop technology- 1 + yrs Experience in any scheduling tools such as ESP, IBM tivoli, Control M, AutoSys, etc. Knowledge of data warehousing techniques Knowledge of Dimensional Modeling Excellent English oral and written communication skills Demonstrated work experience with projects of complex scope Willingness to work outside of normal business hours in order to coordinate with US and offshore based teams Bachelor s degree in computer science or related field or a combination of related experience and education. Good working knowledge of data warehouse, database design, Microsoft Office Products and Microsoft Visio Responsible for setting up and leading development team Collaborate and communicate well with others, strong written and verbal communication, comfortable with varying (and reactive) daily responsibilities Communicates effectively with individuals and teams in the organization to ensure high quality and timely completion of projects. Good interpersonal, verbal, listening and written communication skills Familiarity with intgerating APIs, webservice calls, Kafka is a plus Primary Skills Ab Initio and tools such as Graphical Development Environment (GDE), Enterprise Metadata Environment including air commands (EME) UNIX scripting Oracle SQL and PL/SQL SQL server kafka +-