About the Opportunity
- We are only considering US Citizens and Green Card holders for this position. We are unable to sponsor for this role.
- We are only considering local candidates who currently reside within 45 minutes of postal code 20024
- No Third Party Agencies
- $130 per hour 1099, $113 per hour (W2 - Benefits), or $102 per hour (W2 + Benefits)
- Location: 100% Work from home, downtown SW DC (Orange/Blue/Silver/Yellow/Green Line: L’Enfant Plaza)
- Job Id: CAI-743751
- Must be able to provide proof of COVID-19 vaccination plus booster shot
- Contract Term: Till end of the 2025 fiscal year with extension based upon performance
- Hours per week: 40
Short Description
The District of Columbia’s Department of Health Care Finance (DHCF) is seeking a Senior Informatica ETL Developer to design, develop, test, and administer Informatica PowerCenter workflows and mappings in support of the DC Access System (DCAS). The ideal candidate will possess 9+ years as a business analyst, 9+ years with Software Development Lifecycle (SDLC) methodologies, and 9+ years of requirements gathering and documentation.
Required Skills/Years of Experience:
- Bachelor’s degree in IT or related field or equivalent experience
- 9+ years of experience as a business analyst
- 9+ years of experience with Software Development Lifecycle (SDLC) methodologies
- 9+ years of experience with requirements gathering and documentation
- 9+ years of experience with MS Office/PowerPoint
- 9+ years of experience with PL/SQL
- 9+ years of experience in Linux and Windows environments
- 8+ years of experience with Informatica Powercenter 9.X
- 8+ years of experience with Oracle Database
- 8+ years of experience in SQL Developer
- 8+ years of experience with SQL
- 6+ years of experience with ODS/Datawarehouse concepts
- 4+ years of experience with excellent communication and leadership skills
- 4+ years of experience with Informatica Powercenter HTTP Adapter, JMS Adapter, Webservices Hub
- 3+ years of experience with installation, administration, configuration, and monitoring of Informatica Powercenter
- 3+ years of experience with Curam Data Model Exp - V6.2
- 1+ year of experience with Microstrategy development
Desired Skills/Years of Experience:
- 6+ years of experience in SOAP WebServices
Complete Description
The District of Columbia’s Department of Health Care Finance (DHCF) is seeking a Senior Informatica ETL Developer to design, develop, test, and administer Informatica PowerCenter workflows and mappings in support of the DC Access System (DCAS). The ideal candidate will possess 9+ years as a business analyst, 9+ years with Software Development Lifecycle (SDLC) methodologies, and 9+ years of requirements gathering and documentation.
The Senior Informatica ETL Developer will be tasked to:
- Design, development, testing and administration of Informatica PowerCenter workflows and mappings
- Collaborate with other team members to design and develop ETL processes using Informatica Powercenter
- Become an integral part of the DCAS Team, making every problem associated to the platform a problem of their own
- Demonstrate the required initiative and critical thinking abilities necessary to resolve all problems and challenges accordingly
- Create data mapping and workflows using Informatica Powercenter to extract, transform and load data into the target environments (batch files, databases)
- Create technical design documents and develops test plans for ETL unit testing and integration testing
- Work and interact with functional and integration teams on architecture and design
- Tune and optimize ETL batch jobs for performance and throughput
- Conform to Informatica workflow and mapping standards so that development is done in a consistent manner across all development resources (no hard coding, leverage of mapplet / reuse concept)
- Develop ETL workflows and mappings from ODS to Datawarehouse using Informatica Powercenter
- Provide development support and mentor junior developers
- Assist with troubleshooting ETL batch job issues in production, PreProd, QA and UAT
- Work and support infrastructure and development teams
- Demonstrate experience in Informatica Powercenter installation, administration and configuration
- Demonstrate familiarity with Informatica Powercenter HTTP Adapter, JMS Adapter, and Webservices Hub
- Work closely with the DHCF and its partner agencies to ensure the agencies’ priorities are met
- Formulate and define systems scope and objectives based on both user needs and a thorough understanding of business systems and industry requirements
- Devise or modify procedures to solve complex problems considering computer equipment capacity and limitations, operation time, and form of desired results
- Analyze business and user needs, document requirements, and translate into proper system requirements specifications
- Provide consultation on complex projects and be the top level contributor/specialist of most phases of systems analysis, while considering the business implications of the application of technology to the current and future business environment
Hiring Expectations
- We are only considering US Citizens and Green Card holders for this position. We are unable to sponsor for this role.
- No Third Parties
- Right to Represent authorization is required
- Expect technical interview screening
- Expect F2F interview
- Background checks and verifications will be required
About Dantech
Dantech Corporation, Inc. is a Certified Business Enterprise (CBE) in the District of Columbia and a federally recognized Woman Owned Small Business (WOSB). The company has a history of technology, innovation and transformation since its launch in 1999. As an Equal Opportunity/Affirmative Action Employer, all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, protected veteran status, or disability status. For more information, please see: www.dantechcorp.com.