AGÕæÈË°Ù¼ÒÀÖ

We are looking for Ab Initio Data Engineer to be able to design and build Ab Initio-based applications across Data Integration, Governance & Quality domains for Compliance Risk programs. The individual will be working with both Technical Leads, Senior Solution Engineers and prospective Application Managers in order to build applications, rollout and support production environments, leveraging Ab Initio tech-stack, and ensuring the overall success of their programs. The programs have a high visibility, and are fast paced key initiatives, which generally aims towards acquiring & curating data and metadata across internal and external sources, provide analytical insights and integrate with other Citi systems.
Technical Stack:
â€� Ìý ÌýAb Initio 4.0.x software suite â€� Co>Op, GDE, EME, BRE, Conduct>It, Express>It, Metadata>Hub, Query>it, Control>Center, Easy>Graph
â€� Ìý ÌýBig Data â€� Cloudera Hadoop, Hive, Yarn
â€� Ìý ÌýDatabases - Oracle 11G/12C, Teradata, MongoDB, Snowflake
â€� Ìý ÌýOthers â€� JIRA, Service Now, Linux, SQL Developer, AutoSys, and Microsoft Office
Responsibilities:
â€� Ìý ÌýAbility to design and build Ab Initio graphs (both continuous & batch) and Conduct>it Plans, and integrate with portfolio of Ab Initio softwares.
â€� Ìý ÌýBuild Web-Service and RESTful graphs and create RAML or Swagger documentations.
â€� Ìý ÌýComplete understanding and analytical ability of Metadata Hub metamodel.
â€� Ìý ÌýStrong hands on Multifile system level programming, debugging and optimization skill.
â€� Ìý ÌýHands on experience in developing complex ETL applications.
â€� Ìý ÌýGood knowledge of RDBMS â€� Oracle, with ability to write complex SQL needed to investigate and analyze data issues
â€� Ìý ÌýStrong in UNIX Shell/Perl Scripting.
â€� Ìý ÌýBuild graphs interfacing with heterogeneous data sources â€� Oracle, Snowflake, Hadoop, Hive, AWS S3.
â€� Ìý ÌýBuild application configurations for Express>It frameworks â€� Acquire>It, Spec-To-Graph, Data Quality Assessment.
â€� Ìý ÌýBuild automation pipelines for Continuous Integration & Delivery (CI-CD), leveraging Testing Framework & JUnit modules, integrating with Jenkins, JIRA and/or Service Now.
â€� Ìý ÌýBuild Query>It data sources for cataloguing data from different sources.
â€� Ìý ÌýParse XML, JSON & YAML documents including hierarchical models.
â€� Ìý ÌýBuild and implement data acquisition and transformation/curation requirements in a data lake or warehouse environment, and demonstrate experience in leveraging various Ab Initio components.
â€� Ìý ÌýBuild Autosys or Control Center Jobs and Schedules for process orchestration
â€� Ìý ÌýBuild BRE rulesets for reformat, rollup & validation use cases
â€� Ìý ÌýBuild SQL scripts on database, performance tuning, relational model analysis and perform data migrations.
â€� Ìý ÌýAbility to identify performance bottlenecks in graphs, and optimize them.
â€� Ìý ÌýEnsure Ab Initio code base is appropriately engineered to maintain current functionality and development that adheres to performance optimization, interoperability standards and requirements, and compliance with client IT governance policies
â€� Ìý ÌýBuild regression test cases, functional test cases and write user manuals for various projects
â€� Ìý ÌýConduct bug fixing, code reviews, and unit, functional and integration testing
â€� Ìý ÌýParticipate in the agile development process, and document and communicate issues and bugs relative to data standards
â€� Ìý ÌýPair up with other data engineers to develop analytic applications leveraging Big Data technologies: Hadoop, NoSQL, and In-memory Data Grids
â€� Ìý ÌýChallenge and inspire team members to achieve business results in a fast paced and quickly changing environment
â€� Ìý ÌýPerform other duties and/or special projects as assigned
Qualifications:
â€� Ìý ÌýBachelor's degree in a quantitative field (such as Engineering, Computer Science, Statistics, Econometrics) and a minimum of 5 years of experience
â€� Ìý ÌýMinimum 8 years of extensive experience in design, build and deployment of Ab Initio-based applications
â€� Ìý ÌýExpertise in handling complex large-scale Data Lake and Warehouse environments
â€� Ìý ÌýHands-on experience writing complex SQL queries, exporting and importing large amounts of data using utilities

------------------------------------------------------

Job Family Group:

Technology

------------------------------------------------------

Job Family:

Applications Development

------------------------------------------------------

Time Type:

Full time

------------------------------------------------------

Most Relevant Skills

Please see the requirements listed above.

------------------------------------------------------

Other Relevant Skills

For complementary skills, please see above and/or contact the recruiter.

------------------------------------------------------

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.

Ìý

If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review .

View Citi’s and the poster.