HireFT
Browse JobsHow it worksPricingAboutSuccess Stories
    Back to jobs
    PS

    PSG Global Solutions

    Outsourced Recruiting Support

    Senior ETL Architect

    Woodbridge Township, United StatesOn-SiteFull-time8+ yrs experiencePosted 3w ago
    All PSG Global Solutions jobs

    Job description

    Summary:

    We are looking for a Senior ETL Architect / Technical Lead with a solid foundation and understanding of ETL technologies and who has worked with large scale data integration projects.

    Responsibilities: 

    • Perform ETL design, data architecture, data management and data analysis
    • Manage the technical delivery of medium to large, moderately complex projects on-time, on-budget and with targeted zero defects
    • Provide planning, estimation, scheduling, prioritization and coordination of technical activities related to system development
    • Ensure system alignment to Enterprise Architecture policies and best practices; ensure that process methodologies are followed in system development
    • Accountable to business and technology management for end to end application scoping, planning, development and delivery that meets and exceeds quality standards
    • Oversee creation and approval of technical documentation including the Solution Definition document and Technical Design document; ensure documentation is aligned to the Functional Requirements and uses document templates that meet SDLC standards
    • Identify and manage dependencies and downstream impacts of the project to minimize adverse effects on other projects and / or programs
    • Manage day to day technical challenges and communicate to project manager any risks or issues associated with development
    • Assist Project manager with the estimation of technical timelines and allocation of the technical resources to specific task
    • Coordinate coding and unit testing phases of system development and facilitate Code Reviews
    • Identify opportunities for system reuse and system simplification
    • Communicate Expectations, Roles and Responsibilities to team members and hold them accountable to meet the expectations
    • Collaborate with IT partners to devise capacity plan and ensure appropriate infrastructure for the end to end system delivery
    • Supervise contingent workers and their daily tasks including onshore and offshore staff
    • At least 8 years of experience in data integration/ETL with at least 5 years of experience with IBM DataStage.
    • Strong and advanced SQL skills
    • Data modeling experience
    • Analyze and understand source data and design target data models
    • Design and implement ETL mappings applying deep know-how in the DataStage functionality.
    • SQL optimization skills and experience
    • Understand Performance issues and strategies for tuning logic and platform configuration settings
    • Understand how to implement different data integration latency strategies.
    • Solid understanding of data integration, data profiling, data quality, data modeling and strong project leadership and client management.
    • Mentor others in DataStage usage when required, keep other designers, team leads and project managers informed of progress and results.
    • 5+ years of work experience in Oracle is a MUST (should have PL/SQL development capabilities)

    All your information will be kept confidential.

    Renil John "Neil" Cervantes

    National Talent Advisor - TrueBridge Resources

    +1 980 244 3270

    Job details are sourced from the employer's original posting.

    Open job posting
    PS

    About the company

    PSG Global Solutions

    PSG is the world’s largest and fastest growing provider of outsourced recruiting support. PSG has clients across the globe, including four of the world’s ten largest staffing companies, 20% of the Staffing Industry Analysts Top 50 and multiple Fortune 500 corporations. With decades of experience in both staffing and the broader outsourced services sector, our services are easy to implement, cost effective, and drive real bottom line results. We have close to 1,200 people at our recruiting centers in the Philippines, the preferred offshore location for supporting the US and global English speaking countries. We built our company from the ground up to take advantage of an offshore delivery model closely aligned with onshore client management. With this approach, our goal is to deliver onshore performance while significantly lowering costs with offshore frontline resources. Many of our customers have had poor experiences with offshore support prior to working with us. With these customers in particular, we are thrilled when they become a case study and talk about their success in our marketing materials and with their colleagues. We partner with every customer using a consultative approach to establish a value delivery framework to ensure we are improving their profitability with every PSG resource assigned to their team.

    View all PSG Global Solutions jobs
    Industry
    Outsourced Recruiting Support
    Open roles
    362

    Interested in this role?

    Apply with HireFT

    Free to start — no card required.

    Your fit

    How well do you match?

    Sign in to see how your résumé lines up with this role.