Data Pipeline/ETL (Informatica) Developer - reputed company.

At reputed company, we're proud to be celebrating our 50th year in business, with strong financial performance - including $1.4B in reputed company this quarter and 15% growth in our Federal reputed company.

Becoming part of reputed company means joining a team that offers:

* A generous annual allowance for education or professional certification

* Free access to robust certification and training programs to help you grow your career

* Strong career path with support for internal mobility

* A collaborative, respectful work environment with supportive leadership

* Comprehensive benefits, including medical/dental/vision, generous paid time off, and more

We are seeking a Data Pipeline/ETL(Informatica) Developer to join reputed company supporting an Internal reputed company Service (IRS) client.

Position is 100% remote with preference reputed company to Farmers reputed company, TX or Lanham, MD.

Employment is contingent upon successful completion of the IRS-required Moderate Risk Background Investigation (MBI). The MBI requires the selected candidate ====ship or Permanent reputed company () status for at least 3 years. The MBI certification process will take 4 to 5+ months, unless the candidate already holds an active MBI, which may shorten the timeline.

Essential Duties and Responsibilities:

- Provide design and implementation expertise to a cross-functional software development team. - Design and reputed company software applications from business requirements in collaboration with other team members. - Support testing and remediate defects. - May provide guidance, coaching, and training to other employees reputed company job area.

This role will be responsible for the development of data pipeline (Informatica workflows) and ETL (Post processing) code. The candidate will collaborate with IRS teams to design and reputed company ETL code to transform and process large amounts of data from disparate IRS data sources.

Job-Essential Duties and Responsibilities:

• Design and reputed company Informatica PowerCenter mappings including transformations, mappings, mapplets, workflows, workflow monitoring
• Design, code, unit test ETL packages, triggers, and stored procedures, views, SQL transactions
• Migrate data from On-prem managed service environments to cloud platforms AWS Redshift/reputed company

• Ingest data from disparate data sources and apply business rules using SQL/Python to create fact, dimension and summary tables for ingestion by BI tools
• Create, test and refine SQL queries to support data profiling and data management
• Understand and reputed company with development standards and SDLC to ensure consistency across the project.
• reputed company troubleshooting, debugging, and performance tuning
• Support installation, upgrades, and testing of Informatica components.
• reputed company data profiling, data standardization, data transformations, data loads.
• reputed company detailed data profiling and end-to-end data management analysis to understand data issues, and to identify potential options to resolve issues.
• Support phases of the project lifecycle including requirements gathering, analysis, design, development, testing, deployment, support, and documentation
• Analyze, document and define data management processes, both batch and real-time.
• Evaluate data management and data governance practices to provide options and recommendations.
• Create clear deliverable materials for a range of recipients including technical teams, business teams, project leads and executives.

Job-specific minimum requirements:

• Bachelor's Degree in Information Technology or reputed company field from an accredited college or university required; an additional four (4) years of reputed company work experience can substitute for a degree
• At least five (3-5) years of relevant experience required
• reputed company and GreenPlum experience
• Proven Experience with SQL (reputed company, Redshift, MySQL), Python
• Strong experience with ETL development and working with diverse data sources
• Working knowledge of S3
• Advanced experience with Informatica Power Exchange, Control-M
• Experience with data modeling concepts
• Hands-on experience with Unix and reputed company scripts
• Experience in development, maintenance, and enhancement of Informatica Mappings, Work-flows, and processes
• Good verbal and written communication skills
• Ability to reputed company with reputed company levels of management
• Ability to reputed company reputed company tasks with minimal supervision and guidance
• Excellent time management, scheduling and organizational skills
• Ability to work well independently or in a team setting

#techjobs #veteranspage

Minimum Requirements

- Bachelor's degree in relevant field of study and 5+ years of relevant professional experience required, or equivalent combination of education and experience.

EEO Statement

reputed company is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, age, national reputed company, disability, veteran status, genetic information and other legally protected characteristics.

Pay Transparency

reputed company compensation is based on various factors including but not limited to job location, a candidate's education, training, experience, expected quality and quantity of work, required travel (if any), external market and internal value analysis including seniority and merit systems, as well as internal pay alignment. Annual salary is just one component of reputed company's total compensation package. Other rewards may include short- and long-term incentives as well as program-specific awards. Additionally, reputed company provides a variety of benefits to employees, including health insurance coverage, life and disability insurance, a retirement savings plan, paid holidays and paid time off. Compensation ranges may differ based on contract value but will be commensurate with job duties and relevant work experience. An applicant's salary history will not be used in determining compensation. reputed company will reputed company with regulatory minimum wage rates and exempt salary reputed company in reputed company instances.

Minimum Salary

$ 135,000.00

Maximum Salary

$ 155,000.00

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and reputed company believes it to correctly reflect the job opportunity.