Praescient Analytics
Senior ETL Architect (Remote)
Praescient Analytics, Lanham, Maryland, United States, 20706
Praescient Analytics is seeking a talented
Senior ETL Architect
that will lead the effort to design, build and configure applications. This role will support the Return Review Program (RRP), a mission-critical, automated system that is part of the IRS's tax processing pipeline component which detects and selects potentially fraudulent returns to prevent/stop the issuance of invalid refunds. RRP maintains an integrated data warehouse that stores return data and taxpayer information for data mining, runtime scoring, scheme development and research. The successful candidate possesses strong organizational skills to create and maintain source to target documentation and a strong technical acumen needed for
Informatica
development.
This position can be supported
remotely.
U.S. citizenship is required.
Responsibilities:
Analyze source to target data definitions and develop high-quality Informatica mappings and workflows based on business transformations rules and Informatica best practices.Identify source data definitions and data quality gaps and recommend mitigation strategiesWork closely with Data Modeler and DBA for Target Data Model changes to support ETL requirementsSupport ETL Testing and resolve testing defectsRequired Qualifications:
Active IRS MBI Clearance required.7+ years working with specified software language as a developer3+ years using Rational Team Concert or equivalent toolsetDemonstrated Control-M experience (for ETL developers)Hands on Greenplum or similar Database ExperienceExcellent oral and written communication skills with client stakeholders at all organizational and technical levels.Ability to contribute to a high-performing, motivated workgroup by applying interpersonal and collaboration skills to achieve project goals.What you can expect from us
Real opportunity for career growth in an environment where your achievements will be celebratedConstant collaboration with numerous teams to ensure client successA team that respects and embraces your ideas and expertiseCoworkers that are motivated by pursuing excellence, rather than the prospect of personal gainA workplace dedicated to supporting and bettering public safety and government agenciesBenefits
Very competitive salary based on qualifications and experienceComprehensive, Company paid Aetna Health Care Medical for you and your family (We pay your premiums and deductibles)401(k) with company matchingTravel & performance incentives3 weeks paid time off (plus Federal Holidays)$5K annual training allowance$500 book allowanceTuition reimbursement programPraescient Analytics, LLC is a Veteran-led, certified Woman-Owned Small Business (WOSB) founded in 2011 which specializes in implementing advanced analytics solutions across the defense, intelligence, and law enforcement communities. Praescient has extensive experience designing, developing, and integrating solutions for customers including the US Army, Special Operations Command (SOCOM), US Navy (USN), US Marine Corps (USMC), US Coast Guard (USCG), Department of Justice (DOJ), Drug Enforcement Administration (DEA), and Federal Bureau of Investigation (FBI), Immigration and Customs Enforcement (ICE), intelligence community, and local law enforcement agencies, among others.
Praescient Analytics is committed to providing equal employment opportunities for all. Employees and applicants without regard to race, color, age, religion, sex, sexual orientation, marital status, gender identity, national origin, legally protected physical or mental disability, genetic information, citizenship status, or status in the uniformed services of the United States, status as a disabled veteran or veteran of the Vietnam era, or on any other basis which is protected under applicable law. This includes a commitment to provide a work environment that is free from all forms of illegal harassment including sexual harassment.
This covers all terms and conditions of employment including (but not limited to):Hiring, placement, promotion, transfer, or demotion of all job classifications;Recruiting, advertising or solicitation for employment;Treatment during employment;Rates of pay or other forms of compensation;Benefits;Selection for training;Company sponsored social and recreational activities; andLayoff or termination
Applicants selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information.US Citizenship RequiredPraescient Analytics is an Equal Opportunity Employer.Interested Candidates: Please forward your resume to
recruiting@praescientanalytics.com
and please visit our website to apply online at
www.praescientanalytics.applicantstack.com/x/openings.
Senior ETL Architect
that will lead the effort to design, build and configure applications. This role will support the Return Review Program (RRP), a mission-critical, automated system that is part of the IRS's tax processing pipeline component which detects and selects potentially fraudulent returns to prevent/stop the issuance of invalid refunds. RRP maintains an integrated data warehouse that stores return data and taxpayer information for data mining, runtime scoring, scheme development and research. The successful candidate possesses strong organizational skills to create and maintain source to target documentation and a strong technical acumen needed for
Informatica
development.
This position can be supported
remotely.
U.S. citizenship is required.
Responsibilities:
Analyze source to target data definitions and develop high-quality Informatica mappings and workflows based on business transformations rules and Informatica best practices.Identify source data definitions and data quality gaps and recommend mitigation strategiesWork closely with Data Modeler and DBA for Target Data Model changes to support ETL requirementsSupport ETL Testing and resolve testing defectsRequired Qualifications:
Active IRS MBI Clearance required.7+ years working with specified software language as a developer3+ years using Rational Team Concert or equivalent toolsetDemonstrated Control-M experience (for ETL developers)Hands on Greenplum or similar Database ExperienceExcellent oral and written communication skills with client stakeholders at all organizational and technical levels.Ability to contribute to a high-performing, motivated workgroup by applying interpersonal and collaboration skills to achieve project goals.What you can expect from us
Real opportunity for career growth in an environment where your achievements will be celebratedConstant collaboration with numerous teams to ensure client successA team that respects and embraces your ideas and expertiseCoworkers that are motivated by pursuing excellence, rather than the prospect of personal gainA workplace dedicated to supporting and bettering public safety and government agenciesBenefits
Very competitive salary based on qualifications and experienceComprehensive, Company paid Aetna Health Care Medical for you and your family (We pay your premiums and deductibles)401(k) with company matchingTravel & performance incentives3 weeks paid time off (plus Federal Holidays)$5K annual training allowance$500 book allowanceTuition reimbursement programPraescient Analytics, LLC is a Veteran-led, certified Woman-Owned Small Business (WOSB) founded in 2011 which specializes in implementing advanced analytics solutions across the defense, intelligence, and law enforcement communities. Praescient has extensive experience designing, developing, and integrating solutions for customers including the US Army, Special Operations Command (SOCOM), US Navy (USN), US Marine Corps (USMC), US Coast Guard (USCG), Department of Justice (DOJ), Drug Enforcement Administration (DEA), and Federal Bureau of Investigation (FBI), Immigration and Customs Enforcement (ICE), intelligence community, and local law enforcement agencies, among others.
Praescient Analytics is committed to providing equal employment opportunities for all. Employees and applicants without regard to race, color, age, religion, sex, sexual orientation, marital status, gender identity, national origin, legally protected physical or mental disability, genetic information, citizenship status, or status in the uniformed services of the United States, status as a disabled veteran or veteran of the Vietnam era, or on any other basis which is protected under applicable law. This includes a commitment to provide a work environment that is free from all forms of illegal harassment including sexual harassment.
This covers all terms and conditions of employment including (but not limited to):Hiring, placement, promotion, transfer, or demotion of all job classifications;Recruiting, advertising or solicitation for employment;Treatment during employment;Rates of pay or other forms of compensation;Benefits;Selection for training;Company sponsored social and recreational activities; andLayoff or termination
Applicants selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information.US Citizenship RequiredPraescient Analytics is an Equal Opportunity Employer.Interested Candidates: Please forward your resume to
recruiting@praescientanalytics.com
and please visit our website to apply online at
www.praescientanalytics.applicantstack.com/x/openings.