- Senior Data Analyst with ETL
- Brooklyn, NY
- Contract
- Mandatory Skills/Experience
- • Minimum of five (5) years of source-to-target data mapping experience in a mixed Mainframe and Relational Database environments.
- • Experience creating data dictionary documentation that includes business terms, valid values, and definitions.
- • Experience converting/migrating VSAM data to relational/dimensional SQL distributed databases.
- • Minimum of three (3) years of recent experience developing applications using IBM DataStage ETL.
- • Experience extracting field references and calculated data from COBOL programs.
- • Experience with BMC Control-M workload automation software.
- • Experience with GIT version control software.
- • Minimum of three (3) years of recent experience with Pension Administration systems.
- . Technical Ability Mandatory:
- • Strong SQL knowledge working with complex queries and stored procedures.
- • Proficiency in SSRS reports’ development.
- • Strong analytical skills demonstrated by the ability to receive requirements, analyze them, and propose a suitable solution that adheres to the team’s methodology.
- • Ability to work in multiple environments: IBM Mainframe, Windows Server, and SQL Server.
- • Proficiency in mainframe applications encompassing COBOL, CICS and DB2.
- • Understanding of data structures and their relationship to ETL applications.
- • Ability to develop complex SQL data validations based on STTMs and target data Models.
- • Excellent analytical, problem-solving, and information gathering skills along with fundamental technical troubleshooting abilities.
- Desirable Skills/Experience
- • Experience extracting business rules from the existing legacy code.
- • Experience with Data Quality/Profiling tools.
- • Experience with Data Warehouses/Data Marts.
- • Experience with SQL Server Reporting Services (SSRS).
- • Prior experience working in a pension system, preferably New York State or New York City pension systems.
- Thanks
- Nithya
- [email protected]
Mention you found this on Data First Jobs — it helps us bring you more roles like this.
Senior Data Analyst with ETL
Trinity Technology Solutions LLC
Similar Analytics Jobs
View all Analytics jobs→SIG SAUER, Inc.
Business Analyst
New
Newington, New Hampshire (USA)
TELUS Digital AI Data Solutions
French Speaking Search Analyst (Canada)
New
RemoteCanada
Murtech Staffing & Solutions
Business Operations Analyst
New
Cleveland, Ohio (USA)$35,000 - $40,000
Torstaff
Sales Support Analyst
New
Vaughan, Ontario (Canada)
State of Delaware
Fiscal Analyst II
New
Delaware (USA)
State of Delaware
Management Analyst III
New
Delaware (USA)
Like this role? Get carefully selected jobs like it, twice a week, straight to your inbox.
Free, no spam. Unsubscribe anytime.