• Senior SQL Developer with Capital Markets exp

    Job Location(s) US-NY-New York | US-NY-New York
    Posted Date 3 weeks ago(2/27/2018 12:33 PM)
    Job ID
    # of Openings
    Technology Experts - Technical Consultant
  • Overview



    At Perficient you’ll deliver mission-critical technology and business solutions to Fortune 500 companies and some of the most recognized brands on the planet. And you’ll do it with cutting-edge technologies, thanks to our close partnerships with the world’s biggest vendors. Our network of offices across North America, as well as locations in India and China, will give you the opportunity to spread your wings, too.


    We’re proud to be publicly recognized as a “Top Workplace” year after year. This is due, in no small part, to our entrepreneurial attitude and collaborative spirit that sets us apart and keeps our colleagues impassioned, driven, and fulfilled.


    About Our Data Governance Group

    We provide exceptional integration services in the ETL, Data Catalog, Data Quality, Data Warehouse, Master Data Management (MDM), Metadata Management & Governance space


    Perficient currently has a career opportunity for a ETL Developer for Greater New York City area.


    Job Overview:

    As a Senior Technical Consultant you will participate in all aspects of the software development lifecycle which includes estimating, technical design, implementation, documentation, testing, deployment and support of application developed for our clients. As a member working in a team environment you will take direction from solution architects and Leads on development activities.




    • Participate in technical planning & requirements gathering phases including Design, code, test, troubleshoot, and document engineering software applications.
    •  Ensuring that technical software development process is followed on the project, familiar with industry best practices for software development.
    • Demonstrate the ability to adapt and work with team members of various experience level.



    • Heavy design and development experience with data warehouses and large databases

    • Expert knowledge of MS SQL Server and SSIS
    • Familiarity with scheduling tools, preferably Autosys
    • Financial services experience with an understanding of fixed income
    • 7+ years of experience in large complex 1TB + data warehouse environment and strong knowledge in ETL and big data/modern data warehouse methodology
    • 7+ years advanced hands-on development experience in using SQL Server 2012/2014/2016 Integration Service (SSIS) development to integrate highly complex data process.
    • Development experience in SSRS and Power BI  and understand Microsoft full BI stack is a plus
    • 7-10  year of experience in SQL Server 2012/2014/2016 database development such as advanced SQL, XML, function, procedure, indexes, partition, and query optimization.  
    • Understand project development life cycle and Agile methodologies
    • Advanced skills and experience with data modeling and enterprise data marts. Understand modern data warehouse design. Experience in Erwin Data Modeler
    • Experience in scheduling tool such as Autosys
    • Experience in C#, ASP.net, Javascript a plus
    • Experience in cloud technology such as AWS EC2, S3, RDS a plus
    • Experience in SQL Server Data Quality and Profiling is a plus
    • Must be a good team player and can work cooperatively
    • Ability to work in agile and fast pace environment
    • 2+ years in Financial industry
    • Client facing or consulting experience highly preferred
    • Skilled problem solvers with the desire and proven ability to create innovative solutions
    • Flexible and adaptable attitude, disciplined to manage multiple responsibilities and adjust to varied environments
    • Phenomenal communicators who can explain and present concepts to technical and non-technical audiences alike, including high level decision makers
    • Bachelor’s Degree in MIS, Computer Science, Math, Engineering or comparable major
    • Solid foundation in Computer Science, with strong competencies in data structures, algorithms and software design
    • Proficient in authoring, editing and presenting technical documents

    Perficient full-time employees receive complete and competitive benefits. We offer a collaborative work environment, competitive compensation, generous work/life opportunities and an outstanding benefits package that includes paid time off plus holidays. In addition, all colleagues are eligible for a number of rewards and recognition programs including billable bonus opportunities. Encouraging a healthy work/life balance and providing our colleagues great benefits are just part of what makes Perficient a great place to work. 


    More About Perficient


    Perficient is the leading digital transformation consulting firm serving Global 2000 and enterprise customers throughout North America. With unparalleled information technology, management consulting and creative capabilities, Perficient and its Perficient Digital agency deliver vision, execution and value with outstanding digital experience, business optimization and industry solutions.


    Our work enables clients to improve productivity and competitiveness; grow and strengthen relationships with customers, suppliers and partners; and reduce costs.  Perficient's professionals serve clients from a network of offices across North America and offshore locations in India and China. Traded on the Nasdaq Global Select Market, Perficient is a member of the Russell 2000 index and the S&P SmallCap 600 index.


    Perficient is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national, origin, disability status, protected veteran status, or any other characteristic protected by law.


    Disclaimer:  The above statements are not intended to be a complete statement of job content, rather to act as a guide to the essential functions performed by the employee assigned to this classification.  Management retains the discretion to add or change the duties of the position at any time. 




    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed