Skip to content


McLean Virginia - 115-130K Full Time Posted: Tuesday, 20 March 2018
Applicants must be eligible to work in the specified location

Prestigious Enterprise Company is currently seeking a Sr. Informatica Developer. Candidate will be responsible for the design, development, maintenance and production support for various Data Mart applications. Candidate will work with initiative leads, business areas, technical leads, business architects, application architects, stakeholders, subject matter experts, analysts, developers, technical support groups and test teams to define and accomplish ETL responsibilities.


* Design and deliver ETL and related components as specified in the design, functional and non-functional requirements, within established budget, time and quality standards.

* Refine and decompose requirements to the level of detail required to initiate development.

* Design, prototype, develop, test, and document existing and new ETLs, and related components; make recommendations for related functions that result in a more cost effective product delivery.

* Perform unit testing of ETLs and related components and document test results.

* Complete code reviews for ETLs and related components, and complete documentation of issues identified and action items.

* Correct testing defects and support all testing, including but not limited to: Unit testing, Integration testing, System testing, User Acceptance testing, End-to-End testing, and Performance testing.

* Analyze current ETLs and related components for performance, diagnosis and troubleshooting.

* Identify application bottlenecks and opportunities to optimize performance.

* Work on issues of diverse scope where analysis of situation or data requires evaluation of a variety of factors, including an understanding of current IT environment.

* Provide resolution to an extensive range of complicated ETL-related problems, proactively and as issues surface.

* Develop and document internal Datastage ETL standards and best practices.

* Provide application integration support.* Perform code version control activities.

* Create and update all necessary documentation for the Project.


* 5-7 years of current and hands-on experience with Informatica (including at least three (3) years on v 9.6 and higher) design, development and performance tuning for Multi-Dimensional Data Marts (Star Schema).

* College Degree or equivalent experience

* Minimum three (3) years of current and hands-on experience with reading and loading high-volume type 2 dimensions (Slowly Changing Dimensions) in Multi-Dimensional Data Marts (Star Schema).

* Minimum five (5) years of current and hands-on experience with complex SQL and high-volume Relational databases and SQL Query performance tuning.

* Minimum three (3) years of current and hands-on UNIX Shell Scripting experience.

* Minimum one (1) year of current and hands-on experience with code management tools.

* Ability to manage multiple priorities and meet critical deadlines.

* Demonstrated partnership with business clients and value proposition of projects/portfolio.

Preferred Skills

* Experience working with data virtualization tools like Denodo.

* Experience with Big Data.

* Experience with MicroStrategy reporting tool.

* XML shredding experience.

* Datastage development experience.

* Autosys development experience.

* Agile Development methodology experience.

McLean Virginia, United States of America
Craig Johnson 
3/20/2018 2:19:15 PM

About Request Technology - Craig Johnson
You may be just a keystroke away from fulfilling yourREQUEST for success...REQUEST is an executive search firm specializing in recruiting Information technology professionals for organizations in the...

We strongly recommend that you should never provide your bank account details to an advertiser during the job application process. Should you receive a request of this nature please contact support giving the advertiser's name and job reference.

Other jobs like this

McLean Virginia
125k flex
McLean Virginia
McLean Virginia
Columbia, Maryland