Previous Job
Informatica developer
Ref No.: 18-18597
Location: McLean, Virginia
Position Type:Contract
Start Date: 03/20/2018
""ETL Typically has 3-5 years of experience in Informatica or other ETL tools and technologies. Strong background in processing large volumes and variety of data (Structured and unstructured data, XMLS, JSONs, PDFs). Cleanse, analyze and Develop ETL scripts to load large datasets into Relational databases, Understand re-usability, parametrization, workflow design, etc. Develop ETL maps using Informatica, Scripting (Batch, shell), Data analysis, data mapping, data loading, and data validation. Maintain and manage technical meta data and documentation for data warehousing and ETL processes. Perform overall ETL solution design and creation of design specifications to implement changes. Strong scripting experience in Python.Database Good knowledge of database concepts with working knowledge on SQL and Stored Procedures. SQL Development - ability to write, troubleshoot and optimize SQL code and design (stored procedures, functions, views, triggers, indexes, constraints). Understanding of logical & physical data design, tables, normalization techniques, relationships, primary & foreign keys, and data types. Automation/Production Support Participate in Requirements Analysis, design Applications based on System Requirements and Architecture, prototype if necessary, develop, unit test and deploy applications Experience with Unix Shell script, Autosys, Stored Procedures, Complex SQLs tuning, data replication between databases is preferred.Testing Develop test plan and/or test application in development status or debug application in production mode. Document or review documentation of steps in specification development, coding, testing and user acceptance for future reference and for internal control purposes. Analytical Skills Independently determines and develops approach to solutions, ability to work under limited direction. Collaborate with team members and Must be able to manage multiple priorities and meet deadlines. Ability to demonstrate a constant and quick learning ability and should be flexible to adapt to the new developing technologies. Excellent problem solving skills and the ability to handle pressure situations without compromising on quality are a must. Basic Requirements: - Strong experience in ETL tool – Informatica and exposure to data modeling- Strong experience in development and troubleshooting of complex ETL/Data applications (Informatica tool sets preferred) - Strong experience in Python Programming- Analytical and testing support for others in the team - Hands-on experience with XML and XSD based interfaces and tools- Experience working with JSON, XML and unstructured data processing- Possess Excellent analytical, programming, written and verbal communication skills.Preferred Skills:- Knowledge of SAS would be helpful - Knowledge of Python is preferred - Familiarity with Big Data Hadoop environment is a plus.- Agile development methodology experience preferred- Experience with ParAccel/Matrix is highly desired.- Understanding of the secondary mortgage industry, experience with Freddie Mac and/or Client is desirable."