170 applicants

Company

Original Job Post

MUFG · 2 days ago

Data Analysis, Analyst

Tampa, FL

Full-time

Hybrid

Entry, Mid Level

$85K/yr - $95K/yr

2+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

Financial Services

Actively Hiring

Insider Connection @MUFG

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Develop ETL process using Informatica to implement the business requirements.

Create Unix shell scripts to build control validation, fine tune the ETL flows etc.

Develop data quality business rules using Informatica IDQ.

Work with business to prepare the data sourcing requirement and mapping documents.

Prepare functional design, detailed design, and unit testing documents.

Optimize the ETL code to achieve performance improvement.

Perform data analysis and validation.

Perform unit testing along with providing support to QE and business users testing.

Troubleshooting and fixing the issues identified in testing phase.

Perform Peer review and migrate the code to higher environment.

Involve in change management process to deploy the code in production environment.

Perform post-production deployment validation and support batch run.

Provide production support as necessary.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SDLCInformatica PowerCenter ETLData WarehousingData ModellingIDQ DevelopmentData QualityData ProfilingData MappingMeta DataBusiness RulesMapping LineagesWaterfall MethodologiesAgile MethodologiesUnix Shell ScriptsHTMLSchedulersPerformance TuningSQLPL SQLDatabase ManagementEncryption TechniquesBanking Domain KnowledgeProblem-SolvingAnalyticalTeam PlayerCommunicationPython scripting

Required

Bachelor’s degree or master’s degree (Preferably in Computer applications/Information technology related or a closely related field)

Minimum 2+ years of experience who has extensively worked on SDLC phases (Data profiling and analysis, Design analysis, requirement gathering, code development, Testing, Migration etc..)

Should be proficient in various Informatica PowerCenter ETL transformations like Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy, Java transformation etc, along with source to target data mapping, ability to define, capture Meta data and Business rules

Good knowledge is expected on Data warehousing / Data Modelling concepts

Proficiency in IDQ development around data quality, data profiling will be an added advantage

Knowledge of understanding / compiling mapping lineages, FDD, DDD, etc

Work experience on any of the data sources such as Relational (Oracle, SQL Server, DB2 etc.), Files (XML Files, Fixed Width Flat Files, Delimited Flat Files etc.)

Experience in both Waterfall and Agile methodologies is expected

Expertise is needed in troubleshooting the issues from end to end with quick work around solutions

Hands on experience is expected under Unix shell scripts along with basics of HTML code

Basic knowledge of IDQ tool is a plus

Should have been worked on Schedulers like Autosys at the development level along with supporting activities

Experience in performance tuning is expected

SQL and PL SQL scripting should be known with both debugging and development aspects

Exposure to the various Database like Relational (Oracle / SQL Server / DB2 / Greenplum etc..), Flat Files (Delimited, XML files, csv files), Encryption / Decryption techniques like PGP/ ENC etc. is required

Banking domain knowledge is good to have

Should be self – driven and expected to have good analytical and problem-solving skills with enthusiastic nature to work as both team player and as independent player

Good communication skills are key