ETL Analyst
3 weeks ago
Analyzes, defines, develops, and maintains complex database structures and ETL architectures and applications.
Creates data flows and ETL models defining the data transformation needs of projects. Ensures effective and efficient utilization of ETL processes when accessing, integrating, and delivering data between systems.
Develops and implements data validation, auditing, reconciliation, testing methodologies, and integration processes. Coordinates with business/data analysts on data cleansing and data profiling activities to improve quality of data.
Works closely with DBA Team and Operations to establish ETL job workflow with reliable error/exception handling and rollback framework, including scheduling, error management, restart ability, email notifications, and information publishing.
Develops and maintains accurate system documentation including information about attributes, lineage, and business rules. Assists in the gathering of metadata and maintenance of repositories and data dictionaries.
Helps set standards and comply with Bank and data governance policies, procedures, and regulations to ensure safe and sound business operations. Recognizes and identifies potential areas where existing policies and procedures require change, or where new ones need to be developed, especially regarding the security of financial data.
Works with IT groups to implement a disaster recovery and business continuance solutions for ETL processes, including the installation, configuration, and testing of software.
Participates in the development and maintenance of strategic, architectural, and tactical plans for the Bank's data integration technologies. Conversant with and cognizant of the future direction of systems, how that direction impacts the Bank, and how future and current systems can be exploited for the benefit of the Bank.
Maintains understanding of data modeling and data integration technology trends and best practices and uses this knowledge to bring solutions to business units and IT; makes recommendations on buy vs. build decisions. Mentors Team members and is a technical resource on data integration and ETL technologies.
Maintains understanding of information flows and the data integration technology to support the documentation of all of the banks' structured data flows.
Provide production support for the banks integrated batch processing.
Provides periodic reports on activities, accomplishments, issues and their solutions, as well as assisting in forecasts of future utilization, tools, and resource requirements.
Ensures compliance with applicable policies, procedures and regulations to ensure safe and sound business operations.
Prefer to be knowledgeable in Data Warehousing and Change Data Capture lifecycle and methodologies. Performs modeling of data sources and flows and works with Data Services staff to identify, design, and implement data warehouse objects – star schemas, multidimensional tables, and BI Universes – using best practices. Designs and develops prototypes, data classifications, and database tables and views to aggregate data as required for reporting optimization.
Requirements
Bachelor’s or master’s degree in computer science, Information Systems, or related field. Or equivalent work experience that includes knowledge of Data Warehousing, Data Integration, Data Transfer methodologies, and Database Management
Five or more years of experience using Informatics tools such as Power Center, Data Quality and Metadata management in a bank or financial institution working with IT staff and business units to complete complex system design, development, and implementation of ETL solutions.
Prefer at least three years of experience in Data Modeling, or Data Integration, including experience using relational, star-schema, and multidimensional data models. Knowledge of current practices, theories, and approaches to performance tuning and optimization, collection of metadata, table partitioning, materialized views, and parallel processing. Proficiency in PL/SQL, SQL, and UNIX scripting
Prefer three or more years of experience as ETL Architect/Designer, including experience installing and configuring database and ETL software. Advanced-level experience in designing, developing, and maintaining data transfer maps and processes and database structures, including measure, dimension, and hierarchy objects. Ability to analyze and interpret financial information and data to implement business/transformation rules, data profiling, data cleansing, and reconciliation processes to ensure data quality.
Knowledge of operating systems hardware and software, relational databases, and software development tools including but not limited to Linux, Windows, Oracle, SQL-Server, Erwin, MS-Access, and MS-Excel
Strong interpersonal, communication, and writing skills; able to work independently or in a team environment.
Experience with Agile methodologies to effectively participate in cross functional teams.
Benefits
Medical Insurance
Prescription drug coverage with Home Delivery option
Dental Insurance with child orthodontia feature
Voluntary Vision Insurance
Company matched 401K retirement plan
Employee Assistance Plan
Life Insurance with AD&D Coverage
Long Term Disability Coverage
Optional Short Term Disability Coverage
Paid Time Off for Holidays, Vacation, Illness
Employee Referral Bonuses
RequirementsBachelor’s Degree in Computer Science, Information Systems, a comparable technical/engineering field, or equivalent work experience required Minimum of 7 years of team-oriented development experience in a relational database environment required Minimum of 5 years of experience with programming languages (i.e. PERL, C, Python, Unix Shell Scripting) is required Experience with EAGLE Investment Systems (Eagle PACE, Eagle Star) is required Experience with ETL development is preferred (Informatica PowerCenter, IBM Data Stage, Oracle Data Integrator) Experience with database programming (i.e. Oracle PL/SQL or Microsoft T-SQL) is preferred Experience with the Software Development Lifecycle, Waterfall & Agile software development is desirable Experience with version control toolsets (i.e. Microsoft Team Foundation Server (TFS), Harvest, etc.) is preferred Experience in the Investment Management Industry and major data domains including Equity, Fixed-Income, Security Master, Positions & Lots, Trades, Corporate Actions, Prices/FX Rates, Cash, Benchmarks strongly preferred
-
ETL Tester
1 week ago
Delhi, India Mastek Full timeETL TesterAs an ETL Tester, your primary responsibilities include manual testing for ETL testing, such as SQL, scripting languages, and tools like SSIS and Query surge. Able to test ETL processed efficiently. With 5 years of experience will have a strong foundation in data validation and be able to handle complex ETL processes. Here are some key roles and...
-
ETL Tester
1 week ago
Delhi, India Mastek Full timeETL TesterAs an ETL Tester, your primary responsibilities include manual testing for ETL testing, such as SQL, scripting languages, and tools like SSIS and Query surge. Able to test ETL processed efficiently. With 5 years of experience will have a strong foundation in data validation and be able to handle complex ETL processes. Here are some key roles and...
-
Etl
2 months ago
New Delhi, India Nityo Infotech Full timeETL DeveloperExp - 3 to 5 yrsShift time - 10 am to 7 pm (Should be available as per our international/national clientneeds)Budget - 18 to 25 LPANo of position - 2Location - Bangalore (Wfo/Hybrid)Notice period - Immediate joinerResponsibilities● Independently plans, designs, develop, executes and monitor complex data integration activitiesto support project...
-
ETL Developer
4 weeks ago
Delhi, India TMF Group Full timeWe never ask for payment as part of our selection process, and we always contact candidates via our corporate accounts and platforms. If you are approached for payment, this is likely to be fraudulent. Please check to see whether the role you are interested in is posted here, on our websiteKey Functions and ResponsibilitiesAct as a technical SME to explain...
-
ETL Developer
4 weeks ago
delhi, India CIEL HR Full timeJob Summary :- We are seeking an experienced ETL Developer to join our team.- The ETL Developer will be responsible for designing, developing, implementing, and maintaining ETL processes for our data warehouse.- The ideal candidate will have a strong understanding of ETL principles, data modeling, and database concepts, along with experience working with...
-
ETL Developer
4 weeks ago
Delhi Division, India CIEL HR Full timeJob Summary :- We are seeking an experienced ETL Developer to join our team.- The ETL Developer will be responsible for designing, developing, implementing, and maintaining ETL processes for our data warehouse.- The ideal candidate will have a strong understanding of ETL principles, data modeling, and database concepts, along with experience working with...
-
ETL Developer
4 weeks ago
Bangalore/Delhi, India CIEL HR Full timeJob Summary :- We are seeking an experienced ETL Developer to join our team.- The ETL Developer will be responsible for designing, developing, implementing, and maintaining ETL processes for our data warehouse.- The ideal candidate will have a strong understanding of ETL principles, data modeling, and database concepts, along with experience working with...
-
ETL Tester
3 weeks ago
delhi, India Synechron Full timeGoodday,We have immediate opportunity for QA ETL Test Engineer.Job Role: QA ETL Test EngineerJob Location: Pune HinjewadiExperience 5 to 8 Years.Notice Perod : Upto 15 days preferred.About Company:At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative...
-
Etl - New Delhi
1 month ago
New Delhi, India Nityo Infotech Full timeETL DeveloperExp - 3 to 5 yrsShift time - 10 am to 7 pm (Should be available as per our international/national clientneeds)Budget - 18 to 25 LPANo of position - 2Location - Bangalore (Wfo/Hybrid)Notice period - Immediate joinerResponsibilities● Independently plans, designs, develop, executes and monitor complex data integration activitiesto support project...
-
Etl - New Delhi
2 months ago
new delhi, India Nityo Infotech Full timeETL DeveloperExp - 3 to 5 yrsShift time - 10 am to 7 pm (Should be available as per our international/national clientneeds)Budget - 18 to 25 LPANo of position - 2Location - Bangalore (Wfo/Hybrid)Notice period - Immediate joinerResponsibilities● Independently plans, designs, develop, executes and monitor complex data integration activitiesto support project...
-
IT Software Engineer
1 week ago
Delhi, India UBS Full timeYour roleAre you a passionate engineer/data analyst that loves all things data and database technologies? Do you have strong PostgreSQL skills? Are you experienced with Informatica, Azure Data Factory, Fabric and UNIX Scripting? Then we're looking for someone like you to strengthen our engineering team to help:Develop and implement ETL solutions by analyzing...
-
IT Technical analyst
1 month ago
Delhi, India Inxigma Full timeJob DescriptionThe Technical Analyst elaborates the technical analysis and design of the solution as defined by the Application Analyst, in such way that it can be implemented by a Developer. The technical solution must be in line with company standards concerning quality and performance, and resource usage.During the elaboration phase:Technical elaboration...
-
Delhi, India EXL Full timeJob description (Technical Business Analyst) Job Location: Hyderabad/Pune/Gurgaon/Bangalore Experience: 4+ years Notice Period: Immediate Joiner to 30 days. Join EXL's innovative data science team, where we harness the power of generative AI to push the boundaries of data-driven solutions. At EXL, we're committed to exploring new frontiers in technology, Job...
-
Data Analyst
2 weeks ago
Delhi, India Affluent Global Services Full timeJob Title: Data Analyst Department: Parts Data Governance Project Location: Pan India notice period: immediately or 15 days Summary: Min Requirements: Minimum 5 years experience as a data analyst and working for a manufacturing company Experience supporting Supply supply chain, including knowledge of item or part data and attributes Gathers data from...
-
Senior Quality Analyst
1 week ago
Delhi, India BrightEdge Full timeWe are seeking a highly skilled and experienced Senior QA cum Data Analyst to join our team. The ideal candidate will have expertise in ETL (Extract, Transform, Load) processes, data testing, and handling large volumes of data. This role requires a meticulous attention to detail, strong analytical skills, and the ability to ensure data accuracy and integrity...
-
Application Security, Analyst
1 month ago
Delhi, India Agensi Pekerjaan BTC Sdn Bhd Full timeJob DescriptionOpen Position: Application Security, Analyst (MNC Company)A well-known MNC company is currently hiring Application Security, Analyst to join them in their Kuala Lumpur office.Key responsibilities include:• Degree holder or an equal level of work experience.• Maintain application security-specific tools in accordance with corporate...
-
Data Analyst
2 weeks ago
delhi, India Affluent Global Services Full timeJob Title: Data AnalystDepartment: Parts Data Governance ProjectLocation: Pan Indianotice period: immediately or 15 daysSummary:Min Requirements:Minimum 5 years experience as a data analyst and working for a manufacturing companyExperience supporting Supply supply chain, including knowledge of item or part data and attributesGathers data from numerous...
-
70 - Functional Business Analyst
1 week ago
Delhi, India ANGARAI Full timeJob DescriptionANGARAI is looking for aFunctional Business Analystfor an IT Modernization project for its client in the State of Maryland. The Business Analyst will have demonstrated experience in gathering, analyzing, and documenting business requirements to drive data-driven decision-making. The ideal candidate will have the minimum qualifications, strong...
-
new delhi, India EXL Full timeJob description (Technical Business Analyst)Job Location: Hyderabad/Pune/Gurgaon/BangaloreExperience: 4+ yearsNotice Period: Immediate Joiner to 30 days.Join EXL's innovative data science team, where we harness the power of generative AI to push the boundaries of data-driven solutions. At EXL, we're committed to exploring new frontiers in technology,Job...
-
Junior Data Analyst
1 week ago
Delhi, India Tiger Resourcing Group Full timeJob DescriptionJunior Data AnalystLocation: Mereworth, MaidstoneEmployment Type: Full-TimeCompany Overview:An independent digital transformation & cloud migration consultancy focusing on the full end-to-end transformation journey. We work with customers to capture visibility across their current environments, document the processes needed to transform their...