Senior ETL/ Data Analyst
Mississauga, Canada
Job Req ID 21342061Overview
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 the world’s most global bank, 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
Glassdoor Reviews
Responsibilities
Experience:
1. 5-8 years of hands on work experience in the Financial Services Data Warehousing.
2. Experience with high performance & high volume data ware house systems.
3. Strong database development capabilities.
4. Demonstrated design and delivery experience in the full lifecycle of data. Knowledge of information delivery architecture.
5. Broad and deep understanding of challenges with data management in large enterprises, data acquisition, integration and data quality architecture.
6. Extensive experience in developing and managing full life cycle of ETL deliverables. Sourcing from multiple source systems using ETL to implement the data transformation rules and load into the data warehouse.
7. Post Trade Processing Experience; Familiarity with Transactional costs of various securities, Trade Capture and Exception Handling.
8. Ability to carry out adaptive changes necessitated by changes in Business Requirements and Technology.
9. Display sound analytical, problem solving, presentation and inter-personal skills to handle various critical situations.
10. Technology: - Strong ETL (Extract, Transform and Load) concepts, DW (OLTP and OLAP) methodology and Strong SQL skills. Python,Java and Scripting knowledge is a plus.
11. Tools and Applications: - Oracle, Netezza, Talend/Informatica, Java, Unix Shell Scripting, PL/SQL and Store Procedures.
12. Knowledge in Financial products like EQ, FX, Fixed Income , Futures.
13. Knowledge in GMI system.
Responsibilities:
1. Responsible for developing new business functionality and new features of a variable transactional expense system.
2. Extract data from heterogeneous data sources with multiple databases and transform into a harmonized data store under stringent business deadlines.
3. Responsible to design and implement all stages of data life cycle. Maintain coding and naming standards.
4. Interact closely with the Data Analysts and Users during Unit Testing, Integration, UAT and PROD rollout.
5. Design database table structures for transactional and reference data sources, maintain data model up to date as per the requirements.
6. Analysis design development installation and configuration of databases on multiple platforms and operating systems. Configure and administer Database servers. Create new functions, procedures and packages using NZSQL to implement business rules.
7. Generate automated and load procedures batch job administration, optimize database performance and SQL queries. Provide capacity planning and space allocation.
8. Designing, testing and implementation of backup / recovery procedure for database. Design and implement database security. Trouble shoots network databases. Design table structures and custom reports.
9. Program new transformations, mappings, workflows and loading procedures using ETL technologies to implement business rules using the best practices to achieve high performance load times.
10. Performs technical analysis of software, hardware, identifies and resolves complex problems utilizing structured troubleshooting methods, techniques and tools.
11. Evaluates systems specifications for complex business requirements, develops and prepares computer solutions; determines and implements the most efficient and cost effective solution. Prepare technical specification documents and mapping documents.
12. Designs logical and physical data bases and coordinates database development as part of project team, applying knowledge of data base design standards and data base management system.
13. Reviews project request describing database user needs. Estimates time and cost required to accomplish project. Determines if project requires creating series of new programs or modifying existing programs that access data stored in data bases.
Qualifications
Bachelor’s Degree in Computer Science & Engineering.
Master’s Degree in Computer Science & Engineering is a plus.
Citi Canada is an equal opportunity employer. Accordingly, we will make accommodations to respond to the needs of people with disabilities (including, without limitation, physical and mental health disabilities) during the recruitment process and otherwise in accordance with law. Individuals who view themselves as Aboriginals, members of visible minority or racialized communities, and people with disabilities are encouraged to apply.
-------------------------------------------------
Job Family Group:
Technology-------------------------------------------------
Job Family:
Applications Development------------------------------------------------------
Time Type:
Full time------------------------------------------------------
Citi is an equal opportunity and affirmative action employer.
Qualified applicants will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Citigroup Inc. and its subsidiaries ("Citi”) invite all qualified interested applicants to apply for career opportunities. 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 Accessibility at Citi.
View the "EEO is the Law" poster. View the EEO is the Law Supplement.
View the EEO Policy Statement.
View the Pay Transparency Posting
-
Join our team
of 220,000+
strong diverse employees -
Socially minded employees volunteering in communities across 90 countries
-
Meaningful career opportunities thanks to a physical presence in over 95 markets
We foster a culture that embraces all individuals and encourages diverse perspectives, where you can make an impact and grow your career. At Citi, we value colleagues that demonstrate high professional standards, a strong sense of integrity and generosity, intellectual curiosity, and rigor. We recognize the importance of owning your career, with the commitment that if you do, we promise to meet you more than half way.
Innovation Through Diversity
-
Citi has an immense network with over 200,000 colleagues across 6 continents in over 100 countries and has been able to serve over 200 million clients for over 200 years. Gain insights into how our firm draws from a diverse pool of ideas and talent to transform ideas into strategies and deliver diverse opportunities to our colleagues.
Success Stories
Get inspired and hear what employees who started their careers in Technology have to say about Citi
Featured Career Areas
Saved Jobs
You have no saved jobs
Previously Viewed Jobs
You have no viewed jobs