Data Integration Engineer

Cetera Financial Group in Schaumburg, IL

  • Industry: Information Technology - Others
  • Type: Full Time
position filled
Description Position Title : Data Integration Engineer, Cetera Financial Group What we need : Cetera Financial Group is currently seeking a Data Engineer for our company's office located in Schaumburg, IL. What you will do: Independently design and develop solutions to support Data ingestion, ETL & Workflows needed using the appropriate platform, tools and programming languages on assorted system requests. Using independent judgment, analyze business requirements and work with data analyst team to produce specifications used in creation of ETL mappings. Develop and maintain data pipelines to key applications and data stores. Work with a multi-locational team collaboratively. Ensure newly designed systems run as needed; perform validity check on production output. Conduct performance tuning on new and existing systems to insure optimal efficiency Qualifications What you need to have: Minimum 10 years of experience developing data warehouse/ETL solutions preferably within the financial industry domain. Requires a bachelor's degree or equivalent in computer science, technology or engineering. Sound understanding of data warehouse best practices, relational data structures and dimensional data modeling is required along with strong SQL skills. Strong knowledge & understanding of big data software stack & working knowledge of big data environments. Strong prior experience with architecting complex ETL processes using tools like Informatica Power center or Informatica Big data management platform is required. Proven experience in managing complex Informatica based ETL processes and hands on experience in designing, developing and optimizing (performance tuning) Informatica mapping in a large data volume scenarios. Strong database skills in any of the databases like PostgreSQL (preferable), Oracle, or SQL Server etc. is mandatory. Strong Unix scripting skills are also expected. Experience in Big data tools on Cloudera stack such as Sqoop, Hive, Hbase, Oozie, Hue, Impala and Kudu is desired but not mandatory. Experience with data modeling tools like Erwin or Data analysis tools like Paxata or Alteryx are 'good to have' skills Must be able to communicate effectively verbally and in writing with technical and non-technical associates What we give you in return: Our competitive Health program offers a comprehensive benefits package that supports healthy lifestyles, preventative care and helps to protect against hardship. Our retirement plan offers our employees the opportunity to plan ahead for a strong financial future well beyond their working years. About Cetera Financial Group: Cetera Financial Group ("Cetera") is a leading network of independent retail broker-dealers empowering the delivery of objective financial advice to individuals, families and company retirement plans across the country through trusted financial advisors and financial institutions. Cetera is the second-largest independent financial advisor network in the nation by number of advisors, as well as a leading provider of retail services to the investment programs of banks and credit unions. Through its multiple distinct firms, Cetera offers independent and institutions-based advisors the benefits of a large, established broker-dealer and registered investment adviser, while serving advisors and institutions in a way that is customized to their needs and aspirations. Advisor support resources offered through Cetera include award-winning wealth management and advisory platforms, comprehensive broker-dealer and registered investment adviser services, practice management support and innovative technology. " Cetera Financial Group " refers to the network of retail independent broker-dealers encompassing, among others, Cetera Advisors , Cetera Advisor Networks , Cetera Financial Institutions, Cetera Financial Specialists , First Allied Securities , and Summit Brokerage Services . Cetera Financial Group is committed to providing an equal employment opportunity for all applicants and employees. For us, this is the only acceptable way to do business. Accordingly, all employment decisions at the Cetera Financial Group, including those relating to hiring, promotion, transfers, benefits, compensation, and placement, will be made without regard to race, color, ancestry, national origin, citizenship, age, physical and/or mental disability, medical condition, pregnancy, genetic characteristics, religion, religious dress and/or grooming, gender, gender identity, gender expression, sexual orientation, marital status, U.S. military status, political affiliation, or any other class protected by state and/or federal law. Agencies please note : this recruitment assignment is being managed directly by Cetera's Talent Acquisition team. We will reach out to our preferred agency partners in the rare instance we require additional talent options. Your respect for this process is appreciated. Please Note : Cetera does not accept unsolicited Agency resumes. Any unsolicited resumes received from Agencies will be considered the property of Cetera unless specifically requested by Human Resources. DICE - provided by Dice

You may be interested in these similar jobs!
Senior Software Engineer - Cloud And Analytics
GlobalLogic in Deerfield, IL

Sr. Software Engineer - Cloud and Analytics EngineeringDeerfield, IL, USA Role/Responsibilities: Analyze data from all sources and develop data mode…

Read More
Lead Data Engineer (SSIS)
IT america in Chicago, IL

Role: Lead Data Engineer (SSIS) Location: Downtown Chicago IL Duration: 6 Months Description: Responsible for designing and building new subject area…

Read More
Database Developer
Connect Search LLC in Chicago, IL

Connect Search is seeking a strong data engineer/integration developer who has a wide range of experience within: Data warehousing, Data Migration, D…

Read More
SAP FICO Architect
deegit in Chicago, IL

- Good Experience in FI-General Ledger concepts (Chart of Accounts setup, data maintenance, integration with CO)- Integration of CO with FI-AR, FI-AP…

Read More
Radiant Logic Directory Services Engineer
Request Technology, LLC in Chicago, IL

We are unable to sponsor as this is a permanent full time role A fortune 500 company is on the search for a Radiant Logic Directory Services Engineer…

Read More
Data Integration Engineer
Addison Group in Schaumburg, IL

Our client in the northwest suburbs is looking for a Data Integration Engineer for a long term engagement! We are looking for candidates that are lo…

Read More
ETL/BI Developer
SystegrationACT Group in Gurnee, IL

Our client has few open positions for ETL/BI Senior and Mid-Level developers NO SPONSORSHIP IS AVAILABLE Candidates should have strong knowledge of E…

Read More
Salesforce Integration Developer
Aptask in Libertyville, IL

Role: Salesforce Integration DeveloperLocation: Mettawa, ILDuration: Long-term ContractMust have good knowledge of Salesforce Lightning and involved …

Read More
Data Integration Engineer
C3 IoT in Chicago, IL

C3.ai is a leading enterprise AI software provider for accelerating digital transformation. The comprehensive and proven C3 AI Suite uses a model-dr…

Read More
Technical Integration Analyst
R1 RCM in Chicago, IL

R1 RCM Inc. is a leading provider of technology-enabled revenue cycle management services which transform and solve challenges across health systems,…

Read More