Linked In

  • Opportunity

    our quality team can
    enhance your career

  • 1


ETL Developer

Location: Costa Mesa, CA
Atrilogy is seeking an ETL Developer for a 6 Month+ contract in Orange County, CA. The Data Warehouse ETL Developer is responsible for ETL development using Informatica in Microsoft SQL Server environment and all aspects of data warehouse reporting.
Position Duties & Responsibilities (detailed description):
  • Work as part of a team to deliver federated dimensional model for growing online consumer subscription service.
  • Play key role in adding data to the Data Warehouse through development of source to targets maps and transformation rules.
  • Participate in requirement definition, solution development and implementation phases of data warehouse and reporting projects.
  • Develop Informatica ETL for Cognos FM, cube, and report development.
  • Create and maintain ETL specifications and process documentation to produce the required data deliverables (data profiling, source to target maps, ETL flows).
  • Assist in definition of logical and physical data models B2C ecommerce business.
  • Configure and tune ETL infrastructure to optimize the data warehousing architecture
  • Troubleshoot and resolve data, system issues and performance issues. 
  • Expertise in Informatica development and performance tuning.
  • Experience with business intelligence or reporting tools (preferably Cognos BI tools: Framework Manager, Power Play, ReportNet, Metric Studio).
  • SQL Server – SSIS, SQL queries and stored procedures.
  • Good experience with data warehouse concepts and methodologies.
  • Have working experience in ecommerce industry and web analytics will be a plus
  • Good written and oral communication skills; excellent technical skills.
  • Highly motivated self-starter, detail and quality oriented and able to work independently
  • Experience with data modeling tool (ER/Studio)
  • Minimum 5 year experience in Informatica development
  • Minimum 7 year in software development
  • Education: BS degree or higher in MIS or engineering fields.
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.
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.
In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire.
this job portal is powered by CATS