ONLY US CITIZENS AND GREEN CARD HOLDERS AS PER CLIENT'S REQUEST!!!!
Title: ETL Administrator / Developer
Location: Reston, VA
Duration: 4 Months (Possible Extension)
We are seeking a senior-level, skilled Informatica PowerCenter Administrator & Developer. The selected ETL Administrator / Developer will join the development team to design, develop, implement informatica based ETL solutions, including coding of Informatica mappings, design/code/test ETL packages, triggers, stored procedures, views, and SQL transactions. The resource will function as part of a team and must demonstrate sufficient written and communication skills to ensure success and will also coordinate builds and deployments across environments and perform admin work as necessary.
Required Skills:
· Over 5 years of experience in Data Warehouse/Mart environments
· Over 5 years of demonstrated experience in Informatica suite of products
· Experience with development using Informatica PowerCenter and Informatica Power Exchange (Change Data Capture/CDC methodologies)
· Thorough understanding of building and supporting Informatica Mappings, Workflows
· Several years’ experience in building/implementing scalable, reliable and high performance ETL architectures
· Proficiency with RDBMS systems, Oracle, SQL, PL/SQL, UNIX shell scripting, and database optimizations
· Strong experience in using transformations such as XML Parser, xml Generator, SQL, filter, router, aggregator, lookup, source qualifier, joiner, Union, Sequence generator, stored procedure etc
· Familiar with database analysis, design, and programming with an understanding of related technologies specifically Java, XML, and web services
· Excellent ETL design skills, hands-on experience in developing ETL mappings
· Demonstrated experience in optimizing/troubleshooting poorly performing ETL mappings
· Hands-on experience in Informatica administration work, perform all Informatica administration functions such as user access accounts, roles, privileges, and LDAP configuration
· Configure and maintain domain and application services like repository services and integration services for Informatica Power Center
· Ability to work well independently and within a team environment
· Excellent communication skills, able to explain complex technical structures in an understandable user-friendly format
Preferred Skills:
· Experience of ETL in enterprise-wide initiatives
· Experience in integrating data quality suites
· Create batch scripting to automate the Informatica admin process
· Proficiency with job scheduling tools
Education/Certifications:
· Bachelor’s Degree in computer science or related subject, plus additional related college courses or professional training, and six to eight years of progressively responsible directly related experience.
· Current Informatica Developer Course Certification is preferred
· Current Informatica Administration Course Certification is preferred
Job Type: Contract