ETL Developer

Overview Citi's technology team is growing at lightning speed, and we're looking for talented technologists to help build the future of global banking. Our teams are creating innovations used across the globe – we're changing the way people bank and how the world does business. Citi's technology team supports business operations in 100+ countries, across multiple lines of business spanning both Institutional and retail businesses. The group works to optimize the IT environment by standardizing production platforms, reducing complexity, and introducing innovative solutions that provide new business capabilities, reduce total cost of ownership, and create a competitive advantage for Citi. Join an environment with a laser focus on growth and progress, and take your career to the next level through the power of Citi's unmatched globality and vast expertise. Success Profile As one of the world's most global banks, Citi gives you the tools to be a trailblazer. We're not just building technology, we're building the future of banking. With thousands of employees located around the globe, we are an international team encompassing a broad range of teams, roles, and cultures, and we invite you to come and join us • Creative • Analytical • Collaborative • Productive • Adaptable • Relationship Expertise Responsibilities The Apps Support Intmd Analyst is a developing professional role. Deals with most problems independently and has some latitude to solve complex problems. Integrates in-depth specialty area knowledge with a solid understanding of industry standards and practices. Good understanding of how the team and area integrate with others in accomplishing the objectives of the subfunction/ job family. Applies analytical thinking and knowledge of data analysis tools and methodologies. Requires attention to detail when making judgments and recommendations based on the analysis of factual information. Typically deals with variable issues with potentially broader business impact. Applies professional judgment when interpreting data and results. Breaks down information in a systematic and communicable manner. Developed communication and diplomacy skills are required in order to exchange potentially complex/sensitive information. Moderate but direct impact through close contact with the businesses' core activities. Quality and timeliness of service provided will affect the effectiveness of own team and other closely related teams. Responsibilities: • The Apps Support Intmd Analyst provides technical and business support for users of Citi Applcations. • Utilizes good understanding of apps support procedures and concepts and basic knowledge of other technical areas to field issues and queries from stakeholders, provide short-term resolutions and work with relevant technology partners for long term remediation. • Develop a comprehensive understanding of how areas of apps support collectively integrate to contribute to achieving business goals. • Act as a liaison between users/traders, interfacing internal technology groups and vendors • Participates in disaster recovery testing • Participate in application releases, from development, testing and deployment into production. • perform post release checkouts after application releases and infrastructure updates. Develop and maintain technical support documentation. • Considers implications of the application of technology to the current environment. • Analyzes applications to identify risks, vulnerabilities and security issues. • Makes evaluative judgments based on analysis of factual information; resolves problems by identifying and selecting solutions Cooperation with Development colleagues to prioritize bug fixes and support tooling requirements. • Directly impacts the business by ensuring the quality of work provided by self and others; impacts own team and closely related work teams. • Exchanges ideas and information • Active involvement in and ownership of Support Project items, covering Stability, Efficiency, and Effectiveness initiatives. • Performs other duties and functions as assigned in a concise and logical manner. • 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 experience • Basic knowledge or interest about apps support procedures, concepts and of other technical areas. • Participation in some process improvements. • Previous experience or interest in standardization of procedures and practices. • Basic Business knowledge/ understanding of financial markets and products. • Knowledge/ experience of problem Management Tools. • Understands of how own sub-function integrates within the function and commercial awareness • Evaluates (sometimes complex) situations using multiple sources of information Developed communication and diplomacy skills to persuade and influence • Good customer service, communication and interpersonal skills • Good knowledge of the business and its technology strategy • Consistently demonstrates clear and concise written and verbal communication skills • Knowledge of issue tracking and reporting using tools • Good all-round team member • Effectively share information with other support team members and with other technology teams • Ability to plan and organize workload • Ability to communicate appropriately to relevant stakeholder Education: • Bachelor's/University degree or equivalent experience • Own and provide accountability for planning, managing and delivering the projects by applying SDLC standards. • Lead defect review meetings with business team leads and prioritize development tasks around project milestones. • Perform code reviews and support the code promotion process through development, QA and production using BitBucket version control. • Used Talend(7.0 and above) as an ETL tool to extract data from sources systems, load the data into the Oracle / Snowflakes database. • Desired to have Oracle PL SQL hands on experience. • Involve in creation of Autosys jobs in Linux. • Involve in writing UNIX shell scripts and automate the sessions running processes. • Provide technical leadership and manage all aspects of the ETL process-requirement analysis, design, development, testing, and support/maintenance. • Using TAC (Talend Administration Center) for managing Talend related activities. • Work on Java utility to create user define class and call methods from inbuilt libraries. • Hands on experience on Data Lakes and understanding Data Quality mitigation plan.