ETL Informatica Developer

company banner
Atrilogy Solutions Group, Inc.
ETL, Informatica, Developer, Powercenter 9.0, Shell Scripting, PL/SQL, Oracle, SQL Server
Full Time, Full Time
$95k - $110k
Work from home not available Travel required to 10%.

Job Description

Our Direct client is looking for an ETL Informatica Developer for a Full Time direct hire in Cypress, CA
 
In-Person Interview Required
Onsite Role Monday - Friday
 
Candidate must be able to work full time without sponsorship  
Candidate will be required the successful completion of a background check that will include: criminal, Education verification and drug test prior to start.
 
***Travel up to 10% in the USA

 
The  ETL developer identifies, cleanses and transforms data to enable timely and data-driven decision making. In addition, the ETL developer raises the technical competency of the team by educating fellow team members on both new and existing technology, and sets future technical direction by identifying, evaluating, and implementing appropriate technology and tools.  
 
Qualifications  

  • Bachelor's Degree or equivalent work experience in a related field required.
  • Min 3 – 5 years with ETL development
  • 3+ years’ experience developing data integration processes using Informatica Powercenter 9.0 and above required
  • 3+ years’ experience developing data integration processes for retail and/or distribution-based businesses desired
  • Strong experience dealing with disparate data sources, data cleansing, and conformance required
  • Strong experience developing database applications using Oracle and SQL Server required
  • Working knowledge of data warehousing concepts and techniques required
  • Ability to effectively communicate at all levels including customers, peers, business stakeholders, and management
  • Working Knowledge of Shell Scripting
  • Prior experience developing applications using a waterfall or agile methodology preferred
  • Working knowledge of database design and PL/SQL (Query Language)
  • Must be self-motivated and able to work independently, with minimal supervision and as part of a team
  • Detail oriented with excellent interpersonal communication skills
  • Excellent customer service skills

   
The Software Engineer II / ETL Developer will be an integral member of the Technical team and will assist with developing scalable technical ETL solutions across whole company.  The individual is responsible for supporting the deployment, testing, operations, and maintenance of new and existing developments in the technical environment.  The Software Engineer II role will be required to contribute to the technical design, development tasks, estimates, and execution to completion. The Software Engineer II must also ensure that developed code meets the technical and functional specifications through unit testing and validation. In addition, the Software Engineer II will identify, cleanse and transform data to enable timely and data-driven decision making.
 
Technical Design- Able to identify, analyze, specify, design, and translate functional design to technical design. Create and document technical designs for medium to high complexity solutions that may include integration with external systems.

  • Create and document technical designs for medium to high complexity solutions that may include integrations with external systems

 
Participate in peer technical design review

  • Design systems that span multiple technologies/platforms
  • Apply design standards across all applications
  • Design solutions to meet performance requirements and scalability expectations

 
Application Development - Able to write, test, debug, and maintain applications for end-user adoption, productivity improvement and efficiency. 

  • Research, analyze, and produce high quality source code for medium to high complexity solutions
  • Create, modify, and enhance medium to high complexity programs
  • Assist with technical design
  • Troubleshoot and resolve technical issues
  • Participate in peer code reviews
  • Collaborate with cross functional teams to identify and solve software defects
  • Anticipate risks and implement contingency plans to resolve issues impacting applications
  • Design operational support systems like monitoring, reporting, fail over, error handling etc.
  • Proactively enhances systems for stability, efficiency, scalability and robustness
  • Perform file level verification tasks via UNIX Shell scripts and command-line utilities.
  • Provide support to all ETL applications and perform root cause analysis on all processes to resolve all production issues.

 
 Unit Testing and Validation - Ensures developed code meets the technical and functional specifications.

  • Develop and document effective unit test cases to test solution and validate results are as expected
  • Modify code if unit test fails
  • Document all test procedures for systems and processes and coordinate with business analysts and users to resolve all requirement issues and maintain quality for same.
  • Ensure the application operates according to functional and technical specifications
  • Troubleshooting and resolve software bugs, data, and system configuration issues
  • Develops reusable unit test case suite

 
 
For immediate consideration please submit your resume in Word format, along with daytime contact information.  LOCAL CANDIDATES ONLY PLEASE unless you are willing to relocate yourself at your own expense. Client is unable to provide H-1B Visa sponsorship at this time. All submittals will be treated confidentially.  Selected candidate may be asked to pass a comprehensive background, credit and/or drug screening.  Principals only, no third parties please.    
 
Established in 2000, Atrilogy Solutions Group, Inc. provides organizations of all sizes with high-quality, cost effective information technology (IT) and business process consulting & staffing services.  Our industry-leading service model combines experienced project managers with seasoned technical and functional consultants to eliminate client uncertainty and deliver superior value and results.   Clients turn to Atrilogy for expertise in:

  • IT staffing and placement (Project Managers, Agile/Scrum Masters, Business Analysts, DBA’s, Software Engineers, Mobile Developers (iOS, Android), DevOps, Automation, QA, Systems & Network Engineers, Cyber Security / Information Security Specialists)
  • All major ERP & CRM packages (including Oracle, Workday, PeopleSoft, JD Edwards, Lawson, SAP, Dynamics AX, Salesforce, Microsoft CRM, NetSuite)
  • Business Intelligence, Data Warehousing, and Big Data Integration
  • Creative (Interactive Project Manager/Art Director, Information Architect, UI/UX Designer, Web/Graphic Design)

 
Atrilogy has been recognized by Inc. magazine as one of the nation’s fastest-growing, privately-held companies. Headquartered in Irvine, California, Atrilogy also has offices in Denver, Phoenix, Atlanta, and Dallas with satellite offices in Boston, Jersey City, Las Vegas, Seattle, and Delhi, India.     Atrilogy Solutions Group is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, national origin, protected veteran status, or any other basis protected by applicable law, and will not be discriminated against on the basis of disability.    
 
 
 

Posted By

Irvine, CA, 92618



Company Information

Established in 2000, Atrilogy Solutions Group, Inc. provides organizations of all sizes with high-quality, cost effective information technology (IT) and business process consulting & staffing services. Our industry-leading service model combines experienced project managers with seasoned technical and functional consultants to eliminate client uncertainty and deliver superior value and results. Clients turn to Atrilogy for expertise in: • IT staffing and placement (Project Managers, Agile/Scrum Masters, Business Analysts, DBA's, Software Engineers, Mobile Developers (iOS, Android), DevOps, Automation, QA, Systems & Network Engineers, Cyber Security / Information Security Specialists) • All major ERP & CRM packages (including Oracle, Workday, PeopleSoft, JD Edwards, Lawson, SAP, Dynamics AX, Salesforce, Microsoft CRM, NetSuite) • Business Intelligence, Data Warehousing, and Big Data Integration • Creative (Interactive Project Manager/Art Director, Information Architect, UI/UX Designer, Web/Graphic Design) Atrilogy has been recognized by Inc. magazine as one of the nation's fastest-growing, privately-held companies. Headquartered in Irvine, California, Atrilogy also has offices in Denver, Phoenix, Atlanta, and Dallas with satellite offices in Boston, Jersey City, Las Vegas, Seattle, and Delhi, India.
Dice Id : atrilogy
Position Id : 11467649A

Similar Positions at Atrilogy Solutions Group, Inc.

ServiceNow Developer
  • Cypress, CA
  • 5 days ago
ETL / Data Engineer
  • Phoenix, AZ
  • 5 days ago
Database Developer
  • Boston, MA
  • 2 weeks ago
AEM Front End Developer
  • Phoenix, AZ
  • 1 week ago
Java Software Engineer
  • Phoenix, AZ
  • 3 weeks ago
Data Engineer / Developer (Python)
  • Durham, NC
  • 2 days ago