CrawlJobs Logo

Senior ETL Specialist

https://www.citi.com/ Logo

Citi

Location Icon

Location:
India , Chennai

Category Icon
Category:
IT - Software Development

Job Type Icon

Contract Type:
Employment contract

Salary Icon

Salary:

Not provided
Save Job
Save Icon
Apply Position

Job Responsibility:

  • Manage all technology standards across functional area, ensuring development, understanding and adherence around the globe
  • Set goals within functional area that are delivered to appropriate Operations & Technology organizations
  • Contribute to the IT Project Leadership function to harmonize with overall business / technology objectives and ensure teams within the functional area are adequately staffed and possess the required skills sets to carry out their roles
  • Provide an environment where Subject Matter Experts can work efficiently and delivery effectively
  • Apply an in-depth understanding of concepts and procedures within engineering and basic knowledge of those elements in other areas
  • Responsible for training and coaching team members, performance management activities, monitoring quantity and quality of work, and addressing development needs for assigned personnel
  • Make evaluative judgments based on information analysis in complicated or unique situations, utilizing multiple sources of information
  • Negotiate with senior leaders (across functions) and communicate and negotiate with external parties
  • 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, as well as effectively supervise the activity of others and create accountability with those who fail to maintain these standards

Requirements:

  • 10-12 years of relevant experience in Apps Development or systems analysis role
  • Extensive experience system analysis and in programming of software applications
  • Experience in managing and implementing successful projects
  • Proven engineering experience building robust, scalable, and maintainable applications in the Capital Markets Technology industry
  • Work proactively & independently to address project requirements, and articulate issues/challenges with enough lead time to address project delivery risks
  • Code reviews, test case reviews, and ensure code developed meets the requirements
  • Influence and negotiate with senior technical leaders from partner teams of software engineers, devops and production support staff to deliver robust software solutions
  • Ensure the team is collaborating effectively across functions
  • Ability to adjust priorities quickly as circumstances dictate
  • Experience working in Financial Services or a large complex and/or global environment
  • Project Management experience
  • Consistently demonstrates clear and concise written and verbal communication
  • Comprehensive knowledge of design metrics, analytics tools, benchmarking activities and related reporting to identify best practices
  • Demonstrated analytic/diagnostic skills
  • Ability to work in a matrix environment and partner with virtual teams
  • Ability to work independently, prioritize, and take ownership of various parts of a project or initiative
  • Ability to work under pressure and manage to tight deadlines or unexpected changes in expectations or requirements
  • Proven track record of operational process changes and improvement
  • Demonstrated leadership and project management skills
  • Consistently demonstrates clear and concise written and verbal communication

Nice to have:

  • Knowledge Dev-Ops technologies
  • Knowledge of RDBMS, No SQL databases and Big data technologies
  • Strong experience on Observability and monitoring tech stack
  • Experience with Docker and Kubernetes, Openshift
  • Proficiency in SQL Databases, MongoDB, Oracle, Big Data preferred
  • High proficiency in understanding Middleware like Tibco RV, EMS, Solace
What we offer:
  • Be part of Strategic team to develop, enhance, support and maintain solutions for Finance Technology
  • Participate in technical discussions/brainstorming sessions and define ideas and strategies for existing and future platforms
  • Gain exposure to Wholesale, Retail business across data, risk and finance
  • Work across diverse set of Finance platforms and have an opportunity to be part of re-architecture and re-platforming initiatives on low code automation platforms

Additional Information:

Job Posted:
April 24, 2025

Employment Type:
Fulltime
Work Type:
Hybrid work
Icon
Citi - All Job Offers
Job Link Share:
Copy Link Icon
Facebook Icon Twitter Icon LinkedIn Icon

Looking for more opportunities? Search for other job offers that match your skills and interests.

Briefcase Icon

Similar Jobs for Senior ETL Specialist

Mid-Senior Marketing Technology Implementation Specialist

FinXL IT Professional Services is an innovative Australian owned company providi...
Location
Location
Australia , Melbourne CBD
Salary
Salary:
Not provided
finxl.com.au Logo
FinXL
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 6 to 10 years of experience in Marketing Technology implementation
  • Deep proficiency in Adobe Analytics and Adobe Target
  • Expertise in Tag Management System (TMS) and Customer Data Platform (CDP) tools, specifically: Tiium (Tealium IQ, Tealium Event Stream) and Insignen (Ensighten Manage, Ensighten One, Ensighten APIs)
  • Experience in Adtech implementation and management
  • 5+ years in Application Development, Digital Marketing, or an associated field
  • Proficiency in JavaScript and SQL
  • Experience with a programming language such as JAVA, Objective C, or Python
  • Experience with build management tools, including continuous integration and delivery practices (Gradle, Jenkins)
  • Experience with continuous test automation tooling (Perfecto, Applitools)
  • Knowledge of release and configuration management practices (tagging/branching strategies)
Job Responsibility
Job Responsibility
  • Provide technical leadership for the ongoing implementation, management, and strategic design of the client's Marketing Technology
  • Serve as the primary resource for creating detailed tech specifications (approximately 75% of the role) to configure websites for effective analytics data retrieval
  • Implement media tags, set up Ensighten rules, and manage production deployment for new marketing campaigns
  • Work closely with solution designers, business analysts, product owners, and other engineering teams within an agile delivery environment
  • Demonstrate the capacity for frequent context switching and simultaneous work on different project features
  • Apply proven end-to-end consulting and solution design skills to new problems and implementations
  • Fulltime
Read More
Arrow Right

Senior Data Conversion Specialist, Salesforce

As a Data Conversion Specialist, you use software tools and scripting to extract...
Location
Location
United States
Salary
Salary:
80000.00 - 100000.00 USD / Year
evercommerce.com Logo
EverCommerce
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Strong ETL Proficiency
  • 5+ years’ work experience with SQL
  • 5+ years’ work experience with Data Conversion/Migrations
  • 5+ years work experience with Salesforce
  • Good customer and team work
  • Strong logic and critical-thinking ability
  • experience and creativity in troubleshooting data and software problems
  • Self-driven with the ability to effectively prioritize and execute tasks
  • Ability to listen, ask questions, build consensus, and solve ambiguous problems
  • Best-in-class attention to detail
Job Responsibility
Job Responsibility
  • Work with clients to extract data from legacy systems
  • Import data into clients' Salesforce based improveit360 system, review for accuracy and resolve technical issues
  • Manage multiple data conversions simultaneously and prioritize effectively
  • Use tact and diplomacy to set proper timelines and expectations
  • Provide clear documentation of progress
  • Provide guidance on industry best practices related to data transformation
  • Exercise attention to detail to ensure proper data transformation
  • Manipulate live data in databases using best practices
  • Demonstrate business analytics skills and strong interpersonal skills
  • Work collaboratively to identify, reduce or eliminate unnecessary risks
What we offer
What we offer
  • Flexibility to work where/how you want within your country of employment – in-office, remote, or hybrid
  • Robust health and wellness benefits, including an annual wellness stipend
  • 401k with up to a 4% match and immediate vesting
  • Flexible and generous (FTO) time-off
  • Employee Stock Purchase Program
  • Fulltime
Read More
Arrow Right

Software Quality Assurance Senior Specialist

The Software Quality Assurance Senior Specialist role involves testing ETL proce...
Location
Location
Mexico , Guadalajara
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Strong SQL skills must be able to validate data
  • ETL testing experience in Glue, Informatica, or similar
  • Comfortable working with Jira
  • Familiar with data warehousing concepts and reading mapping docs
  • Attention to detail and good communication are key
Job Responsibility
Job Responsibility
  • Test ETL processes across Informatica and Snowflake
  • Validate data between source systems, staging, and our downstream apps using SQL (Oracle, SQL Server, Snowflake)
  • Run queries in DBeaver, SQL Developer, and SSMS to compare results and troubleshoot issues
  • Create and update test cases in Jira and log defects with clear documentation
  • Review data mappings, job logs, and verify that ETL runs completed correctly
  • Work with devs, BAs, and SMEs to clarify requirements and confirm expected outcomes
  • Use WinSCP for file management and version control
Read More
Arrow Right

Senior Systems Testing/QA Specialist

Do you have experience with integration testing on Product Modules (e.g., Ontari...
Location
Location
Canada , North York
Salary
Salary:
414.00 - 451.98 CAD / Hour
https://www.randstad.com Logo
Randstad
Expiration Date
May 21, 2026
Flip Icon
Requirements
Requirements
  • Experience with integration testing on Product Modules (e.g., Ontario Health Client Registry, Provider Registry and Audit Services)
  • Experience with ETL process testing to verify data extracted from sources, transformed by business rules, and loaded into a target
  • Experience with enterprise-level performance testing tools involves a structured process of scripting, scenario design, execution, and analysis using tools such as LoadRunner
Job Responsibility
Job Responsibility
  • Perform functional and non-functional system testing of the interface to Panorama, called REACT, Panorama IMMS & Inventory core and extension applications, enhancements, defect resolutions, etc.
  • Test bug fixes in BO reporting as per defects found by business and as per core Panorama critical changes
  • Create complete system testing documentation and artefacts, including test plans, test cases, test scripts, automated test scripts, test results reports, defect logs for the Panorama, and associated business objects and Cognos reports
  • Transform functional, business, and system knowledge into effective test case planning and execution
  • Create test data according to the test plan
  • analyze testing results and retesting until expected results are obtained
  • perform reviews with users and ensures client acceptability levels are met (e.g. participating in walk throughs)
  • recommend changes to ensure acceptable testing results
  • retest all criteria in a live environment and recommend user sign off for implementation
  • Work closely with developers, architects, product owners, and others in establishing effective test plans based on feature documentation
What we offer
What we offer
  • Earn a competitive rate within the industry
  • Potential for extension
  • Fulltime
Read More
Arrow Right
New

Systems Integration Senior Specialist

We are seeking an experienced ETL Developer with strong expertise in DBT, Snowfl...
Location
Location
India , Bangalore
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Strong SQL (complex joins, window functions, query optimization)
  • Hands‑on expertise with DBT Core / DBT Cloud
  • Advanced experience with Snowflake: Dynamic Tables, Semantic Views, Streams & Tasks, Stored Procedures (JavaScript/Python), Snowflake Performance Tuning, Query Profile analysis
  • Experience with ETL/ELT pipeline design
  • Familiarity with Airflow or similar orchestration tools (preferred)
  • Understanding of CDC frameworks
  • Strong understanding of data warehousing concepts (Kimball/Inmon)
  • Strong analytical and problem‑solving skills
  • Excellent communication and documentation abilities
  • Ability to work in Agile environments
Job Responsibility
Job Responsibility
  • Design, build, and maintain ETL/ELT pipelines using DBT and other modern tools
  • Develop modular, testable DBT models (staging, intermediate, marts)
  • Implement CI/CD pipelines for DBT job deployments
  • Monitor pipeline performance and ensure high data quality
  • Build and manage: Dynamic Tables, Semantic Views, Stored Procedures (SP), Tasks and scheduling workflows, Streams for change data capture (CDC)
  • Implement Snowflake resource optimization including clustering, partitioning, caching, and warehouse sizing
  • Use Query Profile for performance tuning and troubleshooting
  • Manage Snowflake security (RBAC), data governance, and cost optimization
  • Design and enhance DWH structures using dimensional modeling (Star/Snowflake schema)
  • Work with business stakeholders to translate requirements into scalable data models
  • Fulltime
Read More
Arrow Right
New

Senior Specialist, Solution Architect

The Senior Specialist, Solution Architect at NTT DATA is responsible for transfo...
Location
Location
Malaysia , Selangor Darul Ehsan, Selangor
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Broad knowledge of the definition and management of scoping requirements, definition and prioritization activities
  • Broad understanding of database concepts, object and data modelling techniques and design principles and conceptual knowledge of building and maintaining physical and logical data models
  • Deep expertise in Microsoft Azure Data Factory, SQL Analysis Server, SAP Data Services, SAP BTP
  • Broad understanding of data architecture landscape between physical and logical data models
  • Analytical mindset with excellent business acumen skills
  • Problem-solving aptitude with the ability to communicate effectively, both written and verbal
  • Ability to think strategically and build effective relationships at all levels within the organization
  • Expert in programing languages (Perl, bash, Shell Scripting, Python, etc.)
  • Bachelor's degree or equivalent in computer science, software engineering, information technology, or a related field
  • Extended demonstrated experience in data engineering, data mining within a fast-paced environment
Job Responsibility
Job Responsibility
  • Leads on designing data models in a structured data format to enable analysis thereof
  • Design and develop scalable extract, transformation and loading (ETL) packages from the business source systems and the development of ETL routines to populate data from sources
  • Participates in the transformation of object and data models into appropriate database schemas within design constraints
  • Interprets installation standards to meet project needs and produce database components as required
  • Advises on test scenarios and be responsible for participating in thorough testing and validation to support the accuracy of data transformations
  • Accountable for running data migrations across different databases and applications, e.g. MS Dynamics, Oracle, SAP and other ERP systems
  • Works across multiple IT and business teams to define and implement data table structures and data models based on requirements
  • Accountable for analysis, and development of ETL and migration documentation
  • Works with cross functionally stakeholders to evaluate potential data requirements
  • Owns the definition and management of scoping, requirements, definition, and prioritization activities for small-scale changes and assist with more complex change initiatives
What we offer
What we offer
  • Diversity and inclusion
  • Hybrid working
  • Fulltime
Read More
Arrow Right

Software Development Senior Specialist

The Software Development Senior Specialist role involves designing and optimizin...
Location
Location
India , Bangalore
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Minimum of 7 years of experience in relevant fields
  • Strong SQL expertise
  • Hands-on experience with ETL/ELT pipelines
  • Solid understanding of cloud data architecture
  • Experience integrating enterprise systems
  • Experience improving operational efficiency through automation
  • Experience designing, developing, and optimizing scalable data warehouse solutions using Snowflake
  • Experience designing, developing, and implementing automated workflows and business process solutions using Microsoft Power Platform
Job Responsibility
Job Responsibility
  • Design, develop, and maintain data warehouse solutions in Snowflake
  • Build and optimize complex SQL queries, views, stored procedures, and data models
  • Develop and maintain ETL/ELT pipelines to ingest data from various sources (APIs, databases, flat files, cloud storage)
  • Implement Snowflake features such as Streams, Tasks, Snowpipe, Time Travel, Cloning, and Data Sharing
  • Perform query tuning and performance optimization
  • Monitor warehouse performance and manage cost optimization strategies
  • Implement security best practices (RBAC, masking policies, secure data sharing)
  • Troubleshoot data issues, pipeline failures, and performance bottlenecks
  • Maintain documentation for data models, transformations, and workflows
  • Design, develop, and deploy automated workflows using Microsoft Power Automate (Cloud Flows, Desktop Flows)
  • Fulltime
Read More
Arrow Right

Senior IT Specialist

NCDHHS ITD is seeking a Sr. Specialist for a critical project to replace an on-p...
Location
Location
United States , Raleigh
Salary
Salary:
Not provided
esystems-inc.com Logo
eSystems, Inc.
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Experience configuring and building complex workflow automation applications using low-code-no-code platforms
  • Experience developing custom objects, workflows, validation & business rules, and trigger notifications
  • Any System Administrator, Developer, certifications experience is preferred
  • Understanding of Software Development Lifecycle (SDLC) concepts and process
  • Experience with Microsoft Office Suite (MS Word, EXCEL, PowerPoint, Visio), Microsoft Power BI and Microsoft Project
  • Experience creating dashboards and reports
  • Experience with integration tools such as Boomi
  • Experience with data conversion
  • Experience or working knowledge of managing and maintaining Active Directory integrations and importing users and associated AD attributes along with SSO integrations
  • Experience with SharePoint end user experience, sites, libraries, lists and groups
Job Responsibility
Job Responsibility
  • Work on application development, integration development and maintenance of the application
  • Collaborate with stakeholders and other Agile team members to develop reliable, secure configuration from inception to completion, ensuring alignment with organizational goals
  • Provide support and troubleshooting for ongoing development issues reported by users during testing
  • Test finished incremental components and provide feedback to the vendor
  • Regularly monitor the SimpliGov environment to ensure system health, uptime, and performance
  • Monitor APIs and Integrations
  • Assist in performing functional and integrated testing
  • Prepare and maintain project documentation and artifacts including analysis, reports, and user documentation
  • Support required system go-live activities
  • Attend Project meetings and own SCRUM deliverables
Read More
Arrow Right