דרושים Etl Engineer Abinitio - C11 Pune ב-Citi Group ב-India, Chennai

Responsibilities:

• Utilize knowledge of applications development procedures and concepts, and basic knowledge of other technical areas to identify and define necessary system enhancements, including using script tools and analyzing/interpreting code
• Consult with users, clients, and other technology groups on issues, and recommend programming solutions, install, and support customer exposure systems
• Apply fundamental knowledge of programming languages for design specifications.
• Analyze applications to identify vulnerabilities and security issues, as well as conduct testing and debugging
• Serve as advisor or coach to new or lower level analysts
• Identify problems, analyze information, and make evaluative judgements to recommend and implement solutions
• Resolve issues by identifying and selecting solutions through the applications of acquired technical experience and guided by precedents
• Has the ability to operate with a limited level of direct supervision.
• Can exercise independence of judgement and autonomy.
• Acts as SME to senior stakeholders and /or other team members.
• Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.

Qualifications:

• 2-5 years of relevant experience in the Financial Service industry
• Intermediate level experience in Applications Development role
• Consistently demonstrates clear and concise written and verbal communication
• Demonstrated problem-solving and decision-making skills
• Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements

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.

Other Relevant Skills

Responsibilities:

• Utilize knowledge of applications development procedures and concepts, and basic knowledge of other technical areas to identify and define necessary system enhancements, including using script tools and analyzing/interpreting code
• Consult with users, clients, and other technology groups on issues, and recommend programming solutions, install, and support customer exposure systems
• Apply fundamental knowledge of programming languages for design specifications.
• Analyze applications to identify vulnerabilities and security issues, as well as conduct testing and debugging
• Serve as advisor or coach to new or lower level analysts
• Identify problems, analyze information, and make evaluative judgements to recommend and implement solutions
• Resolve issues by identifying and selecting solutions through the applications of acquired technical experience and guided by precedents
• Has the ability to operate with a limited level of direct supervision.
• Can exercise independence of judgement and autonomy.
• Acts as SME to senior stakeholders and /or other team members.
• Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.

Qualifications:

• 4-8 years relevant experience in Data Analytics OR Big Data
• Hands on experience over SQL , Python, Pyspark, with Spark components
• 2-4 years of experience as Big Data Engineer to develop, optimize, and manage large-scale data processing systems and analytics platforms.
• 4 years of experience in distributed data processing & near real-time data analytics using PySpark.
• ETL Experience preferred over Abinitio.
• Strong understanding of PySpark execution plans, partitioning & optimization techniques.

Education:

• Bachelor’s degree/University degree or equivalent experience

Other Relevant Skills

Responsibilities:

• Test Automation Strategy: Develop and implement a comprehensive test automation strategy for data pipelines, data warehouses, and data-driven applications.

• Test Case Design: Design, develop, and maintain automated test cases to validate data quality, data integrity, and data transformations.

• Test Script Development: Write and maintain robust and reusable test scripts using Python and relevant testing frameworks.

• Data Validation: Develop automated data validation techniques to compare data sets, identify discrepancies, and ensure data accuracy.

• Performance Testing: Design and execute performance tests to assess the scalability and performance of data pipelines and data processing systems.

• Big Data Technologies: Utilize Apache Spark and Python to develop test automation solutions for big data environments.

• CI/CD Integration: Integrate automated tests into the CI/CD pipeline to enable continuous testing and faster feedback loops.

• Collaboration: Work closely with data engineers, data experts, and software developers to understand testing requirements and ensure test coverage.

• Defect Management: Identify, track, and manage defects using a bug tracking system.

• Reporting: Generate test reports and metrics to communicate test results and identify areas for improvement.

• Continuous Improvement: Stay up-to-date with the latest trends and technologies in data testing and test automation and recommend best practices.

Qualifications/Experience:

• 6+ years experience in an IT Quality role. Ability to work independently or within groups on projects assigned

• Minimum of 10 years of experience in Data test automation.

• Proven experience in testing data pipelines, data warehouses, and data-intensive applications.

• Strong proficiency in Python programming language.

• Hands-on experience with Apache Spark and Big Data Ecosystem.

• Experience with Enterprise test automation frameworks

• Experience with CI/CD tools such as Jenkins, GitLab CI, or similar.

• Experience with SQL and data validation techniques.

• Education: Bachelor's degree in Computer Science, Engineering, or a related field.

Skills:

• Strong understanding of data testing methodologies and best practices.

• Excellent analytical and problem-solving skills.

• Ability to work independently and as part of a team.

• Excellent communication and interpersonal skills.

Anticipated Posting Close Date:

Responsibilities:

• Conducts strategic data analysis, identifies insights and implications and make strategic recommendations, develops data displays that clearly communicate complex analysis.
• Mines and analyzes data from various banking platforms to drive optimization and improve data quality.
• Deliver analytics initiatives to address business problems with the ability to determine data required, assess time & effort required and establish a project plan.
• Consults with business clients to identify system functional specifications. Applies comprehensive understanding of how multiple areas collectively integrate to contribute towards achieving business goals.
• Consults with users and clients to solve complex system issues/problems through in-depth evaluation of business processes, systems and industry standards; recommends solutions.
• Leads system change process from requirements through implementation; provides user and operational support of application to business users.
• Formulates and defines systems scope and goals for complex projects through research and fact-finding combined with an understanding of applicable business systems and industry standards.
• Impacts the business directly by ensuring the quality of work provided by self and others; impacts own team and closely related work teams.
• Considers the business implications of the application of technology to the current business environment; identifies and communicates risks and impacts.
• Drives communication between business leaders and IT; exhibits sound and comprehensive communication and diplomacy skills to exchange complex information.
• Conduct workflow analysis, business process modeling; develop use cases, test plans, and business rules; assist in user acceptance testing.
• Collaborate on design and implementation of workflow solutions that provide long term scalability, reliability, and performance, and integration with reporting.
• Develop in-depth knowledge and proficiency of supported business areas and engage business partners in evaluating opportunities for process integration and refinement.
• Gather requirements and provide solutions across Business Sectors
• Partner with cross functional teams to analyze, deconstruct, and map current state process and identify improvement opportunities including creation of target operation models.
• Assist in negotiating for resources owned by other areas in order ensure required work is completed on schedule
• Develop and maintain documentation on an ongoing basis, and train new and existing users
• Direct the communication of status, issue, and risk disposition to all stakeholders, including Senior Management
• Direct the identification of risks which impact project delivery and ensure mitigation strategies are developed and executed when necessary
• Ensure that work flow business case / cost benefit analyses are in line with business objectives
• Deliver coherent and concise communications detailing the scope, progress and results of initiatives underway
• Develop strategies to reduce costs, manage risk, and enhance services
• Deploy influencing and matrix management skills in order to ensure technology solutions meet business requirements
• Performs other duties and functions as assigned.
• Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.

Qualifications:

• MBA or Advanced Degree Information Systems, Business Analysis / Computer Science
• 6-10 years experience using tools for statistical modeling of large data sets
• Process Improvement or Project Management experience

Education:

• Bachelor’s/University degree or equivalent experience, potentially Masters degree

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

Time Type:

Responsibilities

• Developing and supporting scalable, extensible, and highly available data solutions
• Deliver on critical business priorities while ensuring alignment with the wider architectural vision
• Identify and help address potential risks in the data supply chain
• Follow and contribute to technical standards
• Design and develop analytical data models

Required Qualifications & Work Experience

• First Class Degree in Engineering/Technology (4-year graduate course)
• 5 to 10 years’ experience implementing data-intensive solutions using agile methodologies
• Experience of relational databases and using SQL for data querying, transformation and manipulation
• Experience of modelling data for analytical consumers

• Ability to automate and streamline the build, test and deployment of data pipelines
• Experience in cloud native technologies and patterns
• A passion for learning new technologies, and a desire for personal growth, through self-study, formal classes, or on-the-job training
• Excellent communication and problem-solving skills

echnical Skills (Must Have)

• ETL: Hands on experience of building data pipelines. Proficiency in two or more data integration platforms such as Ab Initio, Apache Spark, Talend and Informatica
• Big Data:Experience of ‘big data’ platforms such as Hadoop, Hive or Snowflake for data storage and processing
• Data Warehousing & Database Management : Understanding of Data Warehousing concepts, Relational (Oracle, MSSQL, MySQL) and NoSQL (MongoDB, DynamoDB) database design
• Data Modeling & Design:Good exposure to data modeling techniques; design, optimization and maintenance of data models and data structures
• Languages : Proficient in one or more programming languages commonly used in data engineering such as Python, Java or Scala
• DevOps : Exposure to concepts and enablers - CI/CD platforms, version control, automated quality control management

Technical Skills (Valuable)

• Ab Initio : Experience developing Co>Op graphs; ability to tune for performance. Demonstrable knowledge across full suite of Ab Initio toolsets e.g., GDE, Express>IT, Data Profiler and Conduct>IT, Control>Center, Continuous>Flows
• Cloud : Good exposure to public cloud data platforms such as S3, Snowflake, Redshift, Databricks, BigQuery, etc. Demonstratable understanding of underlying architectures and trade-offs
• Data Quality & Controls : Exposure to data validation, cleansing, enrichment and data controls
• Containerization : Fair understanding of containerization platforms like Docker, Kubernetes
• File Formats : Exposure in working on Event/File/Table Formats such as Avro, Parquet, Protobuf, Iceberg, Delta
• Others : Basics of Job scheduler like Autosys. Basics of Entitlement management
• Certification on any of the above topics would be an advantage.

Time Type:

Responsibilities:

• Conduct tasks related to feasibility studies, time and cost estimates, IT planning, risk technology, applications development, model development, and establish and implement new or revised applications systems and programs to meet specific business needs or user areas
• Monitor and control all phases of development process and analysis, design, construction, testing, and implementation as well as provide user and operational support on applications to business users
• Utilize in-depth specialty knowledge of applications development to analyze complex problems/issues, provide evaluation of business process, system process, and industry standards, and make evaluative judgement
• Recommend and develop security measures in post implementation analysis of business usage to ensure successful system design and functionality
• Consult with users/clients and other technology groups on issues, recommend advanced programming solutions, and install and assist customer exposure systems
• Ensure essential procedures are followed and help define operating standards and processes
• Serve as advisor or coach to new or lower level analysts
• Has the ability to operate with a limited level of direct supervision.
• Can exercise independence of judgement and autonomy.
• Acts as SME to senior stakeholders and /or other team members.
• Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.

Qualifications:

• 8-12 years of relevant experience in design development using ETL Tools - AB-Initio / MS SQL Server Technology
• Must have worked on Various Ab-Initio Products like EME/Express-IT and Experience in Continuous Flows.
• Must be Familiar with ETL Concepts and good on Implementing them .
• Knowledge of NoSQL Databases/Hadoop-Hive, Spark will be added advantage
• Experience in systems analysis and programming of software applications
• Experience in managing and implementing successful projects
• Working knowledge of consulting/project management techniques/methods
• Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements

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.

Time Type:

Transaction Management will be responsible for supporting multiple aspects of the lending lifecycle including but not limited to loan closing and servicing coordination, facilitating complex client onboarding, data management, and quality control. The team will be accountable and responsible for operational oversight of the closing and servicing of all loan transactions of the business division being supported to ensure all internal and external requirements are met.

Responsibilities:

• Contribute to the build and development team to support loan origination and lifecycle management which includes large complex syndicated and bilateral loans covering but not limited to corporate, commercial, real estate, structured lending and trade.
• Assist with the creation of processes, standards, procedures, controls, training, and implementation of transaction management.
• Aid in the design and implementation of technology including testing and rollout.
• Provide training and support to transaction management staff and business constituents.
• Partner with each of the originating and coverage business lines, credit risk, operations, legal, etc.
• Ensure that quality of data, controls and processes performed meet internal policies and regulatory requirements/expectations.
• Work with lines of business, transaction management, and loan operations to define and implement operational metrics and risk and control reviews to ensure all stakeholders have end to end transparency.
• Constantly improve processes, controls and efficiencies within the group and front to back across loan lifecycle
• Participate in projects to enhance performance and efficiency.
• Take part in loan remediation and loan system testing / migrations.
• Actively manage and maintain a deal closing pipeline of loan transactions.
• Coordinate and close loan transactions/lifecycle events, capture data, store documentation, troubleshoot issues/roadblocks, perform quality control
• Focus on achieving/exceeding key operating standards within a KPI/metrics driven culture
• Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.

Qualifications:

• Minimum 1-2 years of experience
• Individual must have excellent communication, organizational and interpersonal skills.
• Ability to work well under tight deadlines, manage priorities, and complete assigned tasks with minimal management follow up.
• Strong Excel and other Microsoft based programs.
• Experience with Loan IQ, transaction capture tools, etc.
• Keen attention to detail
• Developed analytical and problem-solving abilities
• Client relationship and solution skills

Additional non-core qualifications which will be considered are:

• Experience within a large global team supporting wholesale lending at large financial Institution
• Knowledge of wholesale loan (syndicated / bilateral) product and business, including an understanding of legal loan documentation, loan a plus
• Experience working with clients under time constraints to facilitate a transaction or process.
• Proven ability to collaborate with team members, Senior management, and other business constituents
• Critical decision-making capabilities including the ability to identify, escalate, and propose solutions to problems
• Ability to manage multiple concurrent deadlines through the practice of strong organizational and time management skills
• Understanding and awareness of appropriate corporate and regulatory policies in relation to Lending
• Deep understanding of operational processes supporting Wholesale lending a plus
• Ability to work in an environment where priorities are frequently changing

Education:

• Bachelor's/University degree or equivalent experience

Anticipated Posting Close Date: