Etl Data Analyst Jobs

• Work with Business stakeholders for requirement gathering and collaborate with QA for test cycles

2. 5+ years of extensive development experience with SQL Server SSIS, Integration Services Catalog and project deployment

3. 3+ years of experience working with BitBucket or TFS, and creating DevOps pipeline

4. You have experience working with an agile scrum team

• Experience with Azure ADF and Azure MI

• Experience with static code scans such as Fortify, Blackduck, etc.

La possibilité de sortir des sentiers battus stimule-t-elle votre créativité? Aimez-vous éprouver la sensation agréable ressentie lorsque l'on aide les gens?

Plus important encore, aimez-vous les gens et vous épanouissez-vous dans un milieu collaboratif et dynamique?

Identifie, recommande ou renvoie tout problème ou opportunité découlant des requêtes des clients à l'équipe ADP interne appropriée.

Représente les principes de Stellar Service et favorise en fin de compte la fidélité des clients

Contribuer à la documentation sur les processus et procédures assurant les meilleures pratiques cohérentes pour l'équipe.

Fournir une expertise des services de données dans le processus de vente, au besoin

La possibilité de sortir des sentiers battus stimule-t-elle votre créativité? Aimez-vous éprouver la sensation agréable ressentie lorsque l'on aide les gens?

Plus important encore, aimez-vous les gens et vous épanouissez-vous dans un milieu collaboratif et dynamique?

Identifie, recommande ou renvoie tout problème ou opportunité découlant des requêtes des clients à l'équipe ADP interne appropriée.

Représente les principes de Stellar Service et favorise en fin de compte la fidélité des clients

Contribuer à la documentation sur les processus et procédures assurant les meilleures pratiques cohérentes pour l'équipe.

Fournir une expertise des services de données dans le processus de vente, au besoin

1. 10+ years of experience with Microsoft BI stack SQL Server, T-SQL, SSIS development required

2. 5+ years of experience with data warehouse, ETL, SSIS to move data / integrate systems required

3. 5+ years of experience with databases, data modeling design required

4. Experience with SDLC methodologies e.g. Agile / Waterfall

• Knowledge on Banking / Risk related systems

• Experience developing code to consuming REST API services

Project management and communication skills.

Provide product feedback and recommendations to product management based on client experience in integration projects.

Strong analytical skills, exceptional client management skills, ability to work with minimum supervision

Ability to multitask, Superior organizational and time management skills

Maintain a thorough and up to-date understanding of all ADP product offerings and related functional capabilities and processing workflows.

Bachelor's degree in Business Administration/HR/Information systems OR equivalent in education and experience

Minimum 5 years work experience writing tests cases and tests scripts based on documented data mapping and business data transformation rules.

Minimum 5 years experience with the following:

Experience in systems development with analysis, design, development, testing and deployment of software systems.

Experience with the implementation of batch and stream data processing pipelines.

Experience writing complex SQL queries, performance tuning and data optimization.

Experience working on large scale data analytics projects.

Hold an Undergraduate Degree or Diploma in Health/Child Welfare Administration, Information Management, Math/Statistics, Business Administration, Software Development, or a related discipline.

Utilize your deep knowledge of Data modeling and database development to design and enhance the data warehouse infrastructure.

Demonstrate your data analysis and reporting capabilities, deriving valuable insights from complex datasets.

Possess strong working experience with ETL processes and a proven ability to develop SSIS, SSAS cubes/data marts.

Showcase proficient SQL programming skills for effective data manipulation and retrieval.

Exhibit in-depth knowledge of Data modeling and database development to design scalable and efficient data warehouses.

Lead, manage, plan, and coordinate the ETL/Data testing activities: Test Strategies, Test Plans, Test Cases, and Test Scripts.

Ensure the test activities are planned and performed according to requirements and standards from the Test Center of Excellence.

Collaborate, share knowledge, and mentor team members.

Minimum 5 years of experience with the following:

Experience working on large-scale data analytics projects.

Experience with the development of Microsoft Power BI reports and dashboards.

Lead, manage, plan, and coordinate the ETL/Data testing activities: Test Strategies, Test Plans, Test Cases, and Test Scripts.

Ensure the test activities are planned and performed according to requirements and standards from the Test Center of Excellence.

Collaborate, share knowledge, and mentor team members.

Minimum 5 years work experience writing tests cases and tests scripts based on documented data mapping and business data transformation rules.

Minimum 5 years experience with the following:

Experience in systems development with analysis, design, development, testing and deployment of software systems.

Lead, manage, plan, and coordinate the ETL/Data testing activities: Test Strategies, Test Plans, Test Cases, and Test Scripts.

Ensure the test activities are planned and performed according to requirements and standards from the Test Center of Excellence

Minimum 5 years work experience writing tests cases and tests scripts based on documented data mapping and business data transformation rules

Minimum 5 years experience with the following:

Experience in systems development with analysis, design, development, testing and deployment of software systems.

Experience with the implementation of batch and stream data processing pipelines.

Strong SQL experience - 5 years

Applications Programmer - SQL – Mandatory Skills

Applications Programmer - SQL - Preferred Skills

Working on ETL logic, SQL and some other vendor-based tools for reporting

Any reporting tool (Tableau) - 1 year

Data analysis - 1 year

Previous experience in Wealth management and/or banking systems highly desirable

Ideally some hands-on experience in ETL work and knowledge of ETL tools

Work with Product Owners and Business representatives to understand requirements, create stories and specs and groom developers and QAs accordingly.

Determines operational objectives by studying business functions; gathering information; evaluating output requirements and formats

Ideally 7+ years' experience in technical system analysis within a development team.

Experience in working with SQL and NoSQL tools

Experience on SQL Server/Oracle RDBMS, tables, views, indexing, tuning and data types

Experience on data transformation techniques

Advanced skills of SQL (analytical functions etc.)

Knowledge of SQL, Data warehousing, Data Modelling, Cloud based technologies and cloud tuning

Basic understanding of data modelling techniques

Data Analysis and cleansing techniques

• Must have Experience with Defect and Test cases management tool experience (ALM or JTMF).

• Hands- on Years of experience in ETL/SQL Testing with Python/ PySpark /Cucumber

• Working experience with SQL is must specially (Analytical functions, Complex joins, Aggregation functions).

• Must understand DW concepts and have tested a Datawarehouse (Natural Keys, Surrogate Keys, Slowly Changing Dimensions).

• Impact on Parent and Child tables due to Incremental and History loads.

• Understanding of STTM (Source to Target Mapping).

Consulting with data management teams to get a big-picture idea of the company’s data storage needs.

7+ years - Enterprise Data Management

3+ years’ experience in Finance / Banking industry – some understanding of Securities and Banking products and their data footprints

Must have experience creating highly efficient and customized warehouse environments that perfectly suits the data storage needs of the company.

Translates data access, transformation, and movement requirements into functional requirements and mapping designs.

4+ years with Data Warehouse Architecture, Snowflake experience preferred

1. 10+ years of experience with Microsoft BI stack SQL Server, T-SQL, SSIS development required

2. 5+ years of experience with data warehouse, ETL, SSIS to move data / integrate systems required

3. 5+ years of experience with databases, data modeling design required

4. Experience with SDLC methodologies e.g. Agile / Waterfall

• Knowledge on Banking / Risk related systems

• Experience developing code to consuming REST API services

ETL Data AnalystBFSI- Banking or Finance Domain

(3.) To interact with the client and other functional teams for gaining understanding of the requirements

Data Analysis/Core Banking/SQL Server DBA/ETL / DW Automation

To develop and deliver codes for the work assigned in accordance with time, quality and cost standards.

(2.) To coordinate with technical teams for pending RICEFs

(4.) To participate in team meetings