ETL Analyst

3 weeks ago

india Visvero, Inc. Full time
Job Description
  • Translates data requirements into applications that employ appropriate data models and ETL solutions.
  • 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

Requirements
Bachelor’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

    india Mastek Full time

    ETL Tester As 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...

  • Data Analyst

    2 months ago

    india Huquo Full time

    Role Description :- Participate in the end-to-end delivery lifecycle of data warehousing projects from business requirements gathering to solution design, development, testing and roll-out. - Support the data development lifecycle activities, including data profiling, ETL and data model design and development, testing, and support. - Leverage data analysis...

  • ETL Developer

    4 weeks ago

    india TMF Group Full time

    We 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 website Key Functions and Responsibilities Act as a technical SME...

  • ETL Developer- AnBC GCP App Migration

    2 months ago

    india Ascendion Full time

    DayToDay Responsbilities: - Design and implement scalable ETL solutions using GCP services such as Dataflow, Dataprep, BigQuery, and Cloud Storage. - Collaborate with data architects and business analysts to understand data requirements and translate them into ETL workflows. - Develop and optimize ETL pipelines to ensure high performance, reliability, and...

  • ETL Developer

    3 days ago

    india TMF Group Full time

    We 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 website. About TMF Group TMF Group is a leading global provider of...

  • ETL Tester

    3 weeks ago

    india Synechron Full time

    Goodday, We have immediate opportunity for QA ETL Test Engineer. Job Role: QA ETL Test Engineer Job Location: Pune Hinjewadi Experience 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 Tester

    3 weeks ago

    india Synechron Full time

    Goodday, We have immediate opportunity for QA ETL Test Engineer. Job Role: QA ETL Test Engineer Job Location: Pune Hinjewadi Experience 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...

  • Data Analyst

    4 weeks ago

    Anywhere in India/Multiple Locations Huquo Full time

    Role Description :- Participate in the end-to-end delivery lifecycle of data warehousing projects from business requirements gathering to solution design, development, testing and roll-out. - Support the data development lifecycle activities, including data profiling, ETL and data model design and development, testing, and support. - Leverage data analysis...

  • ETL Informatica Developer

    1 month ago

    india RapidBraiins Full time

    - UST, formerly known as UST Global, is a provider of digital technology and transformation, information technology, and services, headquartered in Aliso Viejo, California, United States.- Stephen Ross founded UST in 1998 in Laguna Hills.- The company has offices in the Americas, EMEA, APAC, and India. Key Responsibilities : - Collaborate with business...

  • Senior Data Engineer

    2 months ago

    india Nthinsight Full time

    Job Description : We are seeking a skilled and experienced Data Engineer with expertise in Python, data warehousing, ETL (Extract, Transform, Load), and SQL. As a Data Engineer, you will play a crucial role in designing, developing, and maintaining our data infrastructure to support the organization's data needs. You will collaborate with cross-functional...

  • IT Software Engineer

    2 weeks ago

    india UBS Full time

    Your role Are 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...

  • IT Technical analyst

    1 month ago

    india Inxigma Full time

    Job Description The 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...

  • Quality Assurance Analyst

    1 week ago

    india Yo HR Consultancy Full time

    Job Description : Title : Senior QA Analyst/EngineerLocation : Remote Experience : 4 to 8 Years Working Hours : Work in shifts to support clients in US EST time zone (rotational shifts) Role And Responsibilities: - Follow quality assurance procedures, measure and test standards for new applications, products, and/or enhancements to existing applications...

  • Senior Data Engineer

    2 months ago

    india SWAI TECHNOLOGIES PRIVATE LIMITED Full time

    Job Description : We are seeking a highly skilled Senior Data Engineer with 5 - 12 years of experience in building scalable data solutions. The ideal candidate should be proficient in Python programming and SQL, with extensive experience in utilizing various AWS services for data processing and storage. Experience with big data processing environments,...

  • Data Engineer

    4 weeks ago

    Anywhere in India/Multiple Locations Vithamas Technologies Private Limited Full time

    Description : Seeking a skilled Data Engineer to join our IT team. Responsible for designing, implementing, and managing data infrastructure. Collaborate with teams to ensure smooth data integration and analysis, enabling data-driven decisions.Responsibilities : - Design, build, and optimize scalable data pipelines and ETL processes. - Extract, transform,...

  • Lead Data Analyst

    2 weeks ago

    Anywhere in India/Multiple Locations Optimal Virtual Employee Full time

    About the Company : Optimal Virtual Employee is the part of the Optimal Transnational Group. Optimal specializes in all forms of Digital Marketing, Online Marketing, Software Development and Mobile Application Development Services. Outsourcing your needs helps you to utilize your time, money and resources efficiently, which in return boosts your bottom...

  • Data Analyst

    5 days ago

    India Workafy Full time

    About Workafy:Join Workafy, a leading freelance marketplace, where over 250,000 vetted Indian freelancers collaborate with global businesses. Our platform delivers speed, reliability, and exceptional results, helping you to harness the potential of freelance work to achieve your professional goals.Job Description:We are seeking detail-oriented and analytical...

  • Data Analyst

    5 days ago

    india Workafy Full time

    About Workafy: Join Workafy, a leading freelance marketplace, where over 250,000 vetted Indian freelancers collaborate with global businesses. Our platform delivers speed, reliability, and exceptional results, helping you to harness the potential of freelance work to achieve your professional goals. Job Description: We are seeking detail-oriented and...

  • Application Security, Analyst

    1 month ago

    india Agensi Pekerjaan BTC Sdn Bhd Full time

    Job Description Open 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...

  • Job Application-Tech Business Analyst-Immediate Joiner

    3 days ago

    india EXL Full time

    Job 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,...