The #1 Site for IT and Engineering Jobs - search all IT and Engineering  jobs.

Informatica Developer

Job Description

Demonstrable experience as ETL/Oracle/Unix developer Lead with total experience in IT as minimum 12-15 years. Job duties and experience must include..
* Hands-on development experience at ETL development and ETL architecture using Informatica and understanding the flat file/Fixed file structures
* Strong Oracle Database technical knowledge in building general SQL and PL/SQL, stored procedures, cursors, triggers etc…
* Strong development experience in UNIX Shell scripting , AutoSys, Informatica on Informatica Designer Components and development tools -Source Analyzer, Power center Designer, Power Center Repository Manager, PowerCenter Workflow Manager, PowerCenter Workflow Monitor using Unix
* Perform Data analysis, data mapping, data loading, and data validation using informatica and oracle, and implement data controls
* Works closely with Information Technology staff, business, FLUs through the phases of design, coding and implementation of onboarding data source files providing clarifications and data quality as necessary. Maintains effective ongoing communications with the business and IT community and operational management regarding system plans, projects, ,and economic sanctions policies
* Understand reusability, parameterization, Informatica workflow designs, and build Oracle reports
* Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions
* Perform Oracle Performance tuning and end-to-end lifecycle experience with Enterprise wide data and optimize the execution timings
* Perform overall ETL solution design and creation of design specifications and mapping document to implement changes
* Perform Functional and technical impact analysis of potential changes to the clients ETL environment
* Work with DBA, middleware, Informatica, and L@ support team to create deployment plan, migrate change sin lower lanes and validate releases in production.
* Knowledge of working in Agile team is highly preferred
* Perform Functional and technical impact analysis of potential changes to the clients ETL environment
* Experience with migration projects in AML and economic sanctions is a plus. Knowledge of AML/FinCEN process is huge plus
* Good written and verbal communication skills
* Experiencing working with production support in troubleshooting and resolving ETL and oracle issues.
* Independent learner and able to handle production releases in a shared environment




About TEKsystems:

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.



The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please call 888 472-3411 or email accommodation@teksystems .com for other accommodation options.

Job Requirements

 

Job Snapshot

Location US-NY-New York
Employment Type Full-Time
Pay Type Year
Pay Rate N/A
Store Type Finance & Accounting
Apply

Company Overview

TEKsystems, Inc

We’re partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services and real-world application, we work with progressive leaders to drive change. That’s the power of true partnership. TEKsystems is an Allegis Group company. Learn More

Contact Information

US-NY-New York
Jake Healey
201-783-6557
Snapshot
TEKsystems, Inc
Company:
US-NY-New York
Location:
Full-Time
Employment Type:
Year
Pay Type:
N/A
Pay Rate:
Finance & Accounting
Store Type:

Job Description

Demonstrable experience as ETL/Oracle/Unix developer Lead with total experience in IT as minimum 12-15 years. Job duties and experience must include..
* Hands-on development experience at ETL development and ETL architecture using Informatica and understanding the flat file/Fixed file structures
* Strong Oracle Database technical knowledge in building general SQL and PL/SQL, stored procedures, cursors, triggers etc…
* Strong development experience in UNIX Shell scripting , AutoSys, Informatica on Informatica Designer Components and development tools -Source Analyzer, Power center Designer, Power Center Repository Manager, PowerCenter Workflow Manager, PowerCenter Workflow Monitor using Unix
* Perform Data analysis, data mapping, data loading, and data validation using informatica and oracle, and implement data controls
* Works closely with Information Technology staff, business, FLUs through the phases of design, coding and implementation of onboarding data source files providing clarifications and data quality as necessary. Maintains effective ongoing communications with the business and IT community and operational management regarding system plans, projects, ,and economic sanctions policies
* Understand reusability, parameterization, Informatica workflow designs, and build Oracle reports
* Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions
* Perform Oracle Performance tuning and end-to-end lifecycle experience with Enterprise wide data and optimize the execution timings
* Perform overall ETL solution design and creation of design specifications and mapping document to implement changes
* Perform Functional and technical impact analysis of potential changes to the clients ETL environment
* Work with DBA, middleware, Informatica, and L@ support team to create deployment plan, migrate change sin lower lanes and validate releases in production.
* Knowledge of working in Agile team is highly preferred
* Perform Functional and technical impact analysis of potential changes to the clients ETL environment
* Experience with migration projects in AML and economic sanctions is a plus. Knowledge of AML/FinCEN process is huge plus
* Good written and verbal communication skills
* Experiencing working with production support in troubleshooting and resolving ETL and oracle issues.
* Independent learner and able to handle production releases in a shared environment




About TEKsystems:

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.



The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please call 888 472-3411 or email accommodation@teksystems .com for other accommodation options.

Job Requirements

 
Sologig Advice

For your privacy and protection, when applying to a job online: Never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction.Learn More

By applying to a job using sologig.com you are agreeing to comply with and be subject to the workinretail.com Terms and Conditions for use of our website. To use our website, you must agree with theTerms & Conditionsand both meet and comply with their provisions.
Informatica Developer Apply now