Etl Data Analyst Jobs in Manitoba

• 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.

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

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.

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).

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