Junior SQL - Informatica ETL Developer

Responsibilities & Qualifications

RESPONSIBILITIES

• Deliver projects and work in a manner that helps support the customer's mission and objectives.
• Develop and implement technical best practices for data movement, data quality, data cleansing, and other ETL-related activities. Develop and ensure adherence to locally defined standards for all developed components.
• Experience maintaining an enterprise data warehouse.
• Manage and administer the ETL Repository, perform maintenance of appropriate backups and Multi-project/Multi-concurrent release ETL environment.
• Maintain "common code" libraries, so objects can be shared and folders for all Environments (Dev, System Test and Production), Code Check-In/Check-Out procedures and assists in managing all environments and what releases of code are in each.
• Document designs and architect data maps, develop data quality components and establish and/or conduct unit tests.
• Participate in requirements, design, and development reviews. Conduct or participate in meetings with owners of key system components to fully understand current data and systems environments. Resolve source data issues and refine transformation rules.
• Analyze source system data to assess data quality. Work with technical and business representatives to determine strategies for handling data anomalies that are identified. Design ETL processes and develop source-to-target data mappings, integration workflows, and load processes. Design, develop, and implement enterprise-class data warehousing solutions.
• Use the Informatica platform to extract, transform, and load data. Develop, test, integrate, and deploy ETL routines using ETL tools and external programming/scripting languages as necessary.
• Provide data analysis and technical documentation.
• Help administer and maintain the ETL environment in a support role with Systems Administrators, including performing configuration management activities related to the ETL environment.
• Identify problems and propose solutions requiring analytical, evaluative, or constructive thinking in daily work.
• Prepare and present ideas and recommendations to coworkers and customer task managers.
• Apply creative and critical thought processes to identify alternative reporting solutions.
• Other duties assigned as needed.

REQUIRED QUALIFICATIONS

• 5-7 years of business/technology experience
• 3+ years of hands-on experience with Informatica
• Bachelor's degree in an IT discipline preferred
• Top Secret security clearance

Overview

We are seeking a Junior SQL/Informatica ETL Developer to join our team supporting the Federal Bureau of Investigation.

TekSynap is a fast-growing high-tech company that understands both the pace of technology today and the need to have a comprehensive well planned information management environment. "Technology moving at the speed of thought" embodies these principles - the need to nimbly utilize the best that information technology offers to meet the business needs of our Federal Government customers.

We offer our full-time employees a competitive benefits package to include health, dental, vision, 401K, life insurance, short-term and long-term disability plans, vacation time and holidays.

Visit us at www.TekSynap.com .

Apply now to explore jobs with us!

The safety and health of our employees is of the utmost importance. Employees are required to comply with any contractually mandated Federal COVID-19 requirements. More information can be found here .

Additional Job Information

WORK ENVIRONMENT AND PHYSICAL DEMANDS

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of the job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

• Location: Washington, D.C.
• Type of environment: Office
• Noise level: Medium
• Work schedule: Schedule is day shift Monday - Friday. May be requested to work evenings and weekends to meet program and contract needs.
• Amount of Travel: Less than 10%

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to use hands to handle, feel, touch; reach with hands and arms; talk and hear. The employee is regularly required to stand; walk; sit; climb or balance; and stoop, kneel, crouch, or crawl. The employee is regularly required to lift up to 10 pounds. The employee is frequently required to lift up to 25 pounds; and up to 50 pounds. The vision requirements include close vision, distance vision, peripheral vision, depth perception, and ability to adjust focus.

WORK AUTHORIZATION/SECURITY CLEARANCE

U.S. Citizen

Top Secret Security Clearance

OTHER DUTIES

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

EQUAL EMPLOYMENT OPPORTUNITY

In order to provide equal employment and advancement opportunities to all individuals, employment decisions will be based on merit, qualifications, and abilities. TekSynap does not discriminate against any person because of race, color, creed, religion, sex, national origin, disability, age, genetic information, or any other characteristic protected by law (referred to as "protected status"). This nondiscrimination policy extends to all terms, conditions, and privileges of employment as well as the use of all company facilities, participation in all company-sponsored activities, and all employment actions such as promotions, compensation, benefits, and termination of employment.