Data Developer

Asurion Corporation Sterling , VA 20163

Posted 2 weeks ago

Data Developer

The Data Developer will play a key role in the development, support and testing phases of Asurion's Software Development Life Cycle (SDLC). Primary duties are to Develop and Support of all ServiceBench Service Intelligence ETL applications. This includes development in SQL Server, Informatica, MicroStrategy. Daily activities include a broad mix of building ETL Packages in SSIS, Informatica, SQL code, MicroStrategy configuration and Web applications. Additional activities include ad hoc data analysis, troubleshooting, performance tuning, and interacting with business and technical partners.

What You'll Do:

  • Work with Technical leads to Design and Develop new or enhanced ETL streams using Sql Server Integration Services (SSIS)

  • Develop new ETL mappings using Informatica Power Center version 10.x or Intelligent Informatica Cloud Services

  • Understanding Data model and creating SSIS/Informatica Packages, Stored procs etc.

  • Working on Datawarehouse DataMart development

  • Tuning and Optimizing Queries and Indexes

  • Code delivery as per ETL development standards

  • Monitor production jobs when required and working as per Service commitments

  • Analyzing the root cause for production issues

  • Work with team to troubleshoot and performance tune applications

  • Configuring MicroStrategy Schema objects

What You Bring to the Team:

  • 2 (4 preferred) years overall database software development/ data warehouse experience

  • 2 (3 preferred) years hands on experience with ETL tools such as Informatica Power Center or SSIS

  • 1 years hands on experience with any reporting tools (MicroStrategy, Power BI or similar) is a plus

  • Strong Datawarehouse knowledge

  • Proficiency with RDBMS systems (Oracle, SQL Server) SQL, Oracle PL/SQL, UNIX Shell scripting, and database optimizations

  • Minimum hands on experience in web application development in java, C#, or similar is a plus

  • Experience in working in MPP platform databases is a plus (Vertica, ParAccel, Netezza, RedShift)

  • Database/SQL performance tuning skills a plus

  • Strong communication skills and able to work well in a team setting

  • Must be self-motivating and able to work in a rapidly changing environment

  • Bachelor's Degree in Computer Science, Software Engineering, Computer Engineering, Electrical Engineering, Electronics Engineering, or related field

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Big Data Developer

Discovery Communications, Inc.

Posted 7 days ago

VIEW JOBS 4/13/2019 12:00:00 AM 2019-07-12T00:00 Position Summary The position is for a senior Developer who has full technical knowledge of all phases of applications systems analysis and programming. This position is responsible for design and development for Bigdata and devises or modifies procedures to solve complex problems that require the consideration of operating systems capacity and limitations, operating time and form of desired results. Provides technical contribution in the development of detailed specifications from which programs will be written and perform design, coding, testing, debugging and documentation. This position will be required to frequently interact with other development personnel and would often have the responsibility for quality assurance review and evaluation of new or existing code set. Responsibilities 1. Design processes to extract, transform and load the source data to the target and Data lake.2. Develop complex code to load data in to Data lake using AWS/EMR Spark and Scala3. Perform unit and system testing on the processes and resulting data lake tables.4. Create test cases and test the data. 5. Mentor others on the team with product functionality and provide guidelines and solutions on performance tuning techniques and industry best practices.6. Understanding the existing environment, translating into new environment requirements and planning tasks to meet those requirements. Requirements * Bachelor's Degree in Engineering, Computer Science or related discipline;* 5+ years hands-on "big data" experience (Hadoop, HDFS, PIG, SPARK, Scala )* Experience with cloud "big data" infrastructure (AWS EMR, Hortonworks HDP, Cloudera,S3)* Experience creating and managing complex data architectures* Experience with data warehousing databases Redshift, oracle and techniques .* Thorough understanding of cloud computing; * Extensive data analysis skills * Understanding and experience with IAAS, PAAS, SAAS delivery models and the current competitive landscape.* Manipulating, aggregating and deriving useful information from data stored across many sources and different databases * Strong Java and Scala development skills* Talend Big data experience is plus * Must have the legal right to work in the United States Sterling, Virginia, VA Discovery Communications, Inc. Sterling VA

Data Developer

Asurion Corporation