Analytica is seeking an
Informatica Developer to support a key, long-term federal government client program and software product. The ideal candidate will be responsible for loading and testing available data, analyzing data warehousing systems, and overseeing the resolution of any issues that may arise and providing solutions for them. You should be able to develop data warehousing systems by using Informatica tools and smoothly integrate these warehousing systems with an organization or company's existing systems and troubleshoot and debug any issues, while ensuring that the requirements for all the processes have been met and regular quality checks on the stored data occur.
Analytica has been recognized by Inc. Magazine as one of the fastest-growing 250 businesses in the US for 3 years. We work with U.S. government clients in health, civilian, and national security missions to build better technology products that impact our day-to-day lives. The company offers competitive compensation with opportunities for bonuses, employer-paid health care, training and development funds, and 401k match.
Responsibilities include (but not limited to):
- Provide business analysis and develop ETL code and scripting to meet all technical specifications and business requirements according to the established designs.
- Supports development and administration of ETL using Informatica Power Center 10.2 in RHEL 7 and 10.5.3 in RHEL 8 transformations.
- Uses the Informatica DI platform to extract data from external sources and ingest them into a Data warehouse or Data Lake
- Uses the Informatica PowerCenter to perform DI operations and/or build rulesets and apply Data quality.
- Develop application systems that comply with the standard system development methodology and concepts for design, programming, backup, and recovery to deliver solutions that have superior performance and integrity.
- Contribute to determining programming approach, tools, and techniques that best meet the business requirements.
- Provide subject matter expertise in the analysis, preparation of specifications and plans for the development of data processes.
- Deploys application code and analytical models using CI/CD tools and techniques and provides support for deployed data applications and analytical models
- Develop data ingestion and stream-analytic solutions leveraging on premise and cloud based ETL technologies such as Informatica, Kafka, Python, Apache Spark, Python or AWS-based solutions.
- Identify weak points or gaps in the systems architecture and provide recommendations for improving operations and the end user experience.
- Provides technical documentation of Source and Target mappings.
- Participates in design and development reviews as per best practices.
- Works with System owners to resolve source data issues and refine transformation rules.
- Leading the support staff as the SME for troubleshooting issues.
Basic Qualifications:
- Bachelor's degree in Computer Science, Engineering, IT, or other scientific or quantitative fields
- Minimum of 5 years of Informatica ETL Application administration 10.2 and 10.5.3, Solaris 11 and RHEL OS
- Strong Informatica Admin experience with ability to migrate and upgrade from Solaris to Linux environments.
- 5+ years' Experience with advanced SQL in databases like SQL Server or Oracle as well as Linux shell scripting
- 5+ years' experience in strategic data planning, governance and standards
- 5+ years' experience in leveraging enterprise data warehouse modeling constructs and best practices to ensure flexible, scalable and high performing physical databases
- Previous hands on experience integrating systems with big data / data lake repositories using ETL tools
- Excellent communication skills, presentation and interpersonal skills are required. Ability to communicate clearly with both business and technical resources
- Must be a US Citizen with ability to secure a US Federal Clearance.
About Analytica: Analytica is a leading consulting and information technology solutions provider to public sector organizations supporting health, civilian, and national security missions. The company is an award-winning
SBA certified 8(a) small business that has been recognized by Inc. Magazine each of the past three years as one of the 250 fastest-growing companies in the U.S. Analytica specializes in providing software and systems engineering, information management, analytics & visualization, agile project management, and management consulting services. The company is appraised by the Software Engineering Institute (SEI) at CMMIยฎ Maturity Level 3 and is an ISO 9001:2008 certified provider.
As a federal contractor, Analytica is required to verify that all employees are fully vaccinated against COVID-19. If you receive an offer and are unable to get vaccinated for religious or medical reasons, you may request a reasonable accommodation.