Abinitio Data Engineer

The Applications Development Intermediate Programmer Analyst is an intermediate level position responsible for participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team The overall objective of this role is to contribute to applications systems analysis and programming activities Ab Initio Data Engineer 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 usecases 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 5 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 Education Bachelor s degree University degree or equivalent experience This job description provides a high-level review of the types of work performed Other job-related duties may be assigned as required 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